5) When asked for an insurance quotation, an auto insurance compaty looks up the base rate of insuring a specific make, model and year of car. It then mutiplies the base rate by percentages according to the business rules below to calculate the quote for a customer:
• Drivers over 55 year of age with good driving records pay the 90% of the base rate
• Drivers who are male and under 25 years of age pay 150% of the base rate
• Anyone whoe uses the car for business pay a premium of 120% of what they would pay for personal use only
Example: the base rate for a 2005 Honda Civic might be $500.000. A retired senior with a good driving record would pay $450.000 for coverage to for insurance to drive 2005 Honda Civic. However, if that senior has a business as a messenger for which he uess the car, his rate becomess $540.000
a. Draw a decision table to calculate the quotation for a client
b. Use the decision table above to help design test cases for the test objective: Every driver who requests a quotation is tild the correct rate.
Notes: “Criteria for success” refers to deciding whether application passes the test, not whether the driver gets insurance.

Locard's Exchange Principle is a fundamental concept in forensic science which states that when two objects come into contact, there will always be a transfer of materials between them. This principle is often used to link suspects to crime scenes or to establish connections between individuals.

In my own life, there are many ways in which I leave traces of where I have been. For example, my phone's GPS records my location throughout the day, my credit card transactions show where I have made purchases, and my social media activity can provide a timeline of my movements and interactions.

Therefore, To demonstrate this, I could use a map of my location data from my phone's GPS over a given period of time, without revealing specific addresses or locations that could compromise my privacy.

Read more about Locard's Exchange Principle here:

https://brainly.com/question/23154090

#SPJ1

In order to build a coherent and reusable unit of code, programmers "modularize" or "encapsulate" the statements that make up a module.

A module in computer software is an addition to a main programme that is devoted to carrying out a particular task. A module in computing is a chunk of code that is inserted all at once or is made to be easily reused.

A group of expressions and/or statements that you create to carry out a task or an activity constitute a statement. Statements are binary; they either carry out duties or do not. Any statement that has the ability to produce a value qualifies by default for use as an expression.

To know more about encapsulate visit:

https://brainly.com/question/29762276

#SPJ9

Answer:

It allows users to access multiple resources on one machine is considered a benefit of virtual computing.

Explanation:

Virtual computing allows multiple virtual machines to run on a single physical machine, which means that users can access multiple resources on that single machine. This can increase efficiency and productivity, as users can run different operating systems and software on different virtual machines without having to switch between physical machines. It can also save space, as multiple virtual machines can be stored on a single physical machine. Additionally, virtual machines can be easily copied and moved to other physical machines, making it easier to manage and backup files. Overall, virtual computing provides a flexible and efficient way to use and access multiple resources on a single machine.

Answer:

- Virtual Computing Offers secure file backups.

- It allows users to access multiple resources on one machine

Explanation:

1. Virtual Computing with Data backup software installed in the virtual machine can help you protect and restore your data when something goes wrong.

2. By default Default the reason for virtual computing is accessibility, virtual-based applications and data are accessible from virtually any internet-connected device, Virtual Computing allows computer users remote access to software applications and processes when they need it and this could be done simultaneously.

Socket type, chipset, and power requirements are a few examples of elements that affect how compatible computer components are with one another.

Hardware and software are the two essential parts of every computer. Everything that can be seen or touched is referred to as "hardware," including the display, casing, keyboard, mouse, and printer. the section of the programme where the physical elements are used

All computers, at their most basic level, consist of a processor (CPU), memory, and input/output components. The input that each computer gets from various devices is processed by the CPU and RAM.

To know more about computer  visit:-

https://brainly.com/question/16400403

#SPJ1

Answer:

- Microsoft Office, or simply Office, is a discontinued family of client software, server software, and services developed by Microsoft. It was first announced by Bill Gates on August 1, 1988, at COMDEX in Las Vegas.

Functions of MS Office

- Microsoft Office is a suite of applications designed to help with productivity and completing common tasks on a computer. You can create and edit documents containing text and images, work with data in spreadsheets and databases, and create presentations and posters.

The purpose of the Circle Invalid Data command is to circle data that is invalid after it has been entered.

The correct option is A.

The purpose of the Circle Invalid Data command is to circle or highlight data that has been identified as invalid after it has been entered, typically in a spreadsheet or form.

This is done to draw the user's attention to the invalid data and prompt them to correct it.

The command does not necessarily stop the user from entering invalid data in the first place, but it does help to ensure that any mistakes are caught and corrected in a timely manner. It does not autocorrect data entry mistakes or send messages to data entry personnel about the mistakes.

Learn more about Data command at: https://brainly.com/question/19562945

#SPJ1

The three main learning theories that are widely discussed in the field of education:

Behaviorism: This learning theory suggests that all behaviors are learned through conditioning. It focuses on the idea that individuals respond to stimuli in their environment, and that their behaviors are shaped through rewards and punishments. Behaviorists believe that learning occurs through repetition and reinforcement, and that behavior can be changed or modified by manipulating the environment.

Cognitivism: This learning theory emphasizes the importance of mental processes, such as perception, memory, and problem-solving, in the learning process.

Lastly, Constructivism: This learning theory posits that learners actively construct their own knowledge and meaning from their experiences. It emphasizes the idea that individuals create their own understanding of the world based on their experiences and interactions with their environment.

Read more about learning theories here:

https://brainly.com/question/17546524

#SPJ1

The success of a company depends heavily on the satisfaction of its customers, and one of the key factors in achieving that satisfaction is through effective customer support.

As customer demands continue to evolve, it is important for companies to stay on top of their support activities in order to keep their customers happy.

Customer support teams play a critical role in ensuring customer satisfaction, and monitoring the performance of these teams is essential in providing the best service possible. By tracking support KPIs (Key Performance Indicators) and metrics, companies can gain valuable insights into the effectiveness of their support activities and make data-driven decisions to improve their customer service.

Therefore, Effective customer support not only helps to keep existing customers happy, but it also helps to boost customer loyalty and attract new customers.

Read more about customer support  here:

https://brainly.com/question/1286522

#SPJ1

Home tab in MS Word's components: The Clipboard, Font, Paragraph, and Styles tabs are the four separate sections that make up the Home tab.

To learn more about Clipboard, refer to:

https://brainly.com/question/30006106

Answer:

Here's an example Java code that can print all permutations of names given as input:

Explanation:

import java.util.Scanner;

public class Permutations {

   public static void main(String[] args) {

       Scanner input = new Scanner(System.in);

       String[] names = new String[10];

       int n = 0;

       // read the names from input and store them in an array

       while (input.hasNext()) {

           String name = input.next();

           if (name.equals("-1")) {

               break;

           }

           names[n++] = name;

       }

       // call the method to print all permutations of names

       printPermutations(names, 0, n-1);

   }

   // recursive method to print all permutations of names

   public static void printPermutations(String[] names, int left, int right) {

       if (left == right) {

           // base case: if left and right are equal, it means we have reached the end of the name list

           for (int i = 0; i <= right; i++) {

               if (i == right) {

                   System.out.print(names[i]); // print the last name without a comma

               } else {

                   System.out.print(names[i] + ", "); // print the name with a comma after it

               }

           }

           System.out.println(); // print a new line after printing the names

       } else {

           // recursive case: perform permutations of names at different positions

           for (int i = left; i <= right; i++) {

               // swap the name at position i with the name at position left

               String temp = names[left];

               names[left] = names[i];

               names[i] = temp;

               // perform permutations at position left+1

               printPermutations(names, left+1, right);

               // swap the name at position i back to its original position

               names[i] = names[left];

               names[left] = temp;

           }

       }

   }

}

The table of values of the kids name and the ages, hat and animal when completed is shown below

Based on the given information, we can make the following deductions:

Only the 10.year old kid has the same initial in his/her name and in his/her beloved animal

So, we have

Gorilla  -  Gabriel or

Lion -  Lucas

Gabriel either has a green hat or loves the gorilla

So, we have

Gabriel -- Green or Gorilla

Lion -  Lucas

The crocodile is either Zaira's favorite, or the kid with the white hat's favorite.

This means that

Zaira --- Crocodile or White hat --- Crocodile

Neither Gabriel nor Lucas are 12

Gabriel -- 11 or 13

Gabriel is 1 year older than the kid with the red hat and Neither of them love the zebra

This means that

Red hat --- 12

Gabriel -- Green or Gorilla -- 13

So, we have the following:

Kid's Age Kid's Name Hat Color Favorite Animal

13                    Gabriel         Green           Lion

10                      Zaira        White       Crocodile

12                          Lucas       Red                      Lion

11                   Charlotte  Blue           Zebra

Read more about pattern at

https://brainly.com/question/17386984

#SPJ1

The Microsoft Power Platform Command Line Interface (CLI) provides the following three functions when developing Power Apps component framework controls:

Create a new PCF project: The CLI allows developers to create a new Power Apps component framework (PCF) project using templates and configure the required settings.

Build and package a PCF control: The CLI enables developers to build and package a PCF control using standard web development tools, such as TypeScript and Node.js.

Deploy a PCF control: The CLI facilitates the deployment of a PCF control to a Power Apps environment or a Dynamics 365 instance, making it available for use within an app or solution.

Read more about framework here:

https://brainly.com/question/30280665

#SPJ1

A high school diploma or an equivalent credential and achieving a minimum number on a standardized test like the SAT or ACT are usually the two minimum requirements for admission to the university of technology.

The University of Technology offers what services?

Universities of technology are unique in that they concentrate on technological innovation and transfer and provide educational programmes with a technological job emphasis. They collaborate with business to conduct creative, problem-solving study.

Which institution was the first in India?

The University of Calcutta, the University of Madras, and the University of Mumbai all share the oldest foundation date on the UGC list, which is 1857.

To know more about SAT visit:

https://brainly.com/question/2383909

#SPJ9

This company should prepare for the following issues or concerns:

A. Domain reputation.

C. URL redirections.

In Computer technology, a malware is any type of software program such as a game or screen saver, that is designed and developed to be intentionally harmful to a host computer, website, server, or software program, files, network, especially for the purpose of wreaking havoc, disruption, and destruction.

In Computer technology, some examples of a malware include the following:

In this scenario, we can reasonably infer and logically deduce that this company should prepare for domain reputation and uniform resource location (URL) redirections by the external hackers.

Read more on a malware here: brainly.com/question/28260161

#SPJ1

Complete Question:

External hackers have some access to a company's website and made some changes. Customers have submitted multiple complaints via email for wrong orders and inappropriate images on the website. The Chief Information Officer (CIO) is now worried about the distribution of malware. The company should prepare for which of the following other issues or concerns? (Select all that apply.)

A. Domain reputation

B. Domain hijacking

C. URL redirections

D. DNS poisoning

Answer:

The most appropriate programming language to create a video game for a desktop computer is C++. C++ is a powerful and versatile language that is well-suited for game development. It is also a relatively easy language to learn, making it a good choice for beginners.

C++ is a statically typed language, which means that the type of each variable is known at compile time. This makes C++ code more efficient and easier to maintain. C++ is also a compiled language, which means that the code is converted into machine code before it is executed. This makes C++ code faster than interpreted languages, such as Python.

C++ is a good choice for game development because it is a powerful and versatile language. C++ can be used to create games of all genres, from simple 2D games to complex 3D games. C++ is also a good choice for game development because it is a relatively easy language to learn. There are many resources available online and in libraries that can help you learn C++.

If you are interested in creating video games, C++ is a good language to learn. C++ is a powerful and versatile language that is well-suited for game development. It is also a relatively easy language to learn, making it a good choice for beginners.

Explanation:

In C++,  we use the ifstream class to open the file "example.txt". We then use a while loop to read each line of the file into the line variable. Finally, we print each line using the cout statement.

To read a text file and store the data in C++, you can use the following steps:

Learn more about C++ at: https://brainly.com/question/28959658

#SPJ1

Online Learning Platforms: These are digital platforms that provide access to educational materials and resources, as well as interactive tools for communication and collaboration. They allow for asynchronous learning, and can provide personalized learning experiences.

Learning Management Systems (LMS): These are software applications used for administration, documentation, tracking, reporting, and delivery of educational courses, training programs, or learning and development programs.

Educational Apps: These are software applications designed to enhance the learning experience and provide opportunities for interactive, self-directed learning. Examples include language learning apps, math games, and educational videos.

Read more about edutech here:

https://brainly.com/question/14804477

#SPJ1

Answer:

import java.util.Scanner;

public class Linkify {

   public static void main(String[] args) {

       int[][] records = {

           {1232, 10, 23, 45, 56},

           {2343, 45, 43, 24, 78},

           {2343, 34, 45, 45, 45},

           {3423, 67, 65, 65, 56}

       };

       Scanner input = new Scanner(System.in);

       int choice;

       do {

           System.out.println("MENU");

           System.out.println("1. View all students' records");

           System.out.println("2. View a student's records by ID");

           System.out.print("Please enter your choice: ");

           choice = input.nextInt();

           switch(choice) {

               case 1:

                   System.out.println("| StudentID | Quiz1 | Quiz2 | Mid-Term | Final |");

                   for(int i = 0; i < records.length; i++) {

                       System.out.printf("| %-9d | %-5d | %-5d | %-8d | %-5d |\n",

                                         records[i][0], records[i][1], records[i][2],

                                         records[i][3], records[i][4]);

                   }

                   break;

               case 2:

                   System.out.print("Enter a student ID: ");

                   int id = input.nextInt();

                   boolean found = false;

                   for(int i = 0; i < records.length; i++) {

                       if(records[i][0] == id) {

                           System.out.printf("| %-9d | %-5d | %-5d | %-8d | %-5d |\n",

                                             records[i][0], records[i][1], records[i][2],

                                             records[i][3], records[i][4]);

                           found = true;

                           break;

                       }

                   }

                   if(!found) {

                       System.out.println("Invalid ID, please try again.");

                   }

                   break;

               default:

                   System.out.println("Invalid choice, please try again.");

                   break;

           }

           System.out.println();

       } while(choice != 1 && choice != 2);

       input.close();

   }

}

Explanation:

This program first initializes a 2D array called records with the student records data. It then displays a menu with two choices: 1) view all student records, or 2) view a specific student's record by ID.

The program uses a do-while loop to keep displaying the menu and accepting input until the user chooses either option 1 or option 2. Inside the switch statement, the program either loops through the entire records array to print all student records or prompts the user to enter a student ID and searches the records array for a matching ID to print the corresponding record.

The printf method is used to format the output into columns with fixed widths. If an invalid choice or ID is entered, an error message is displayed and the menu is displayed again. Once the user chooses either option 1 or option 2, the program exits.

The SQL query that find the service ID and property ID for each service is added below

To find the service ID and property ID for each service request whose estimated hours are greater than the number of estimated hours of at least one service request on which the category number is 5, we can use the following SQL query:

SELECT s.service_id, s.property_id

FROM service_requests s

WHERE s.estimated_hours > ANY (

   SELECT s2.estimated_hours

   FROM service_requests s2

   WHERE s2.category_number = 5

)

This query uses a subquery to find the maximum number of estimated hours for service requests with category number 5, and then uses the ANY operator to compare each service request's estimated hours to that maximum value.

Read more about SQL statement at

https://brainly.com/question/30078874

#SPJ1

A mathematical notation known as asymptotic notation is used to explain how a function behaves when the input size approaches infinity. Analyzing the effectiveness of algorithms and data structures is a common use for it.

As the input of an algorithm tends towards a specific value or a limiting value, asymptotic notations are used to mathematically define the program's running duration. For instance: The bubble sort algorithm runs in linear time, which is the best case scenario, when the input array has already been sorted.

Limit notation is a more nuanced means of expressing a concept than just saying or. Any number or infinity can serve as the letter.

To know more about function visit:-

brainly.com/question/28939774

#SPJ1

Here's an example assembly code in x86-64 syntax that reads a string from standard input, modifies it according to the given rules, and prints the modified string along with the name of the program:

lua

section .data

   input db 100    ; buffer to hold the input string

   output db 100   ; buffer to hold the output string

   newline db 10   ; ASCII code for newline character

   my_name db "ChatGPT"

section .text

   global _start

_start:

   ; read input string from stdin

   mov eax, 3      ; syscall code for read

   mov ebx, 0      ; file descriptor for stdin

   mov ecx, input  ; buffer to hold input string

   mov edx, 100    ; maximum number of bytes to read

   int 0x80        ; invoke syscall

   ; process input string

   mov esi, input  ; source index register

   mov edi, output ; destination index register

   mov bl, 0       ; loop counter

.loop:

   mov al, byte [esi]

   cmp al, '.'     ; check if end of string

   je .end

   cmp al, 'A'

   jb .lowercase

   cmp al, 'Z'

   ja .lowercase

   add al, 32      ; convert upper case to lower case

   jmp .copy

Read more about Assembly code here:

https://brainly.com/question/13171889

#SPJ1

Here's a sample spreadsheet for your payroll:

Employee Name Hourly Rate Hours Worked Total Pay Tax Rate Taxes Withheld Net Pay

Sean $8.25 10 =B2*C2 5% =D2*E2 =D2-F2

Justine $9.00 30 =B3*C3 6% =D3*E3 =D3-F3

In this spreadsheet, we have columns for the employee name, hourly rate, hours worked, total pay, tax rate, taxes withheld, and net pay.

For each employee, we use a formula to calculate their total pay based on their hourly rate and hours worked. The formula used in the Total Pay column is "=hourly rate * hours worked".

We also have a column for tax rate, where we input the percentage at which the employee is taxed. Using this tax rate, we calculate the taxes withheld from the employee's pay in the Taxes Withheld column. The formula used in the Taxes Withheld column is "=total pay * (tax rate/100)".

Finally, we calculate the net pay for each employee by subtracting the taxes withheld from their total pay in the Net Pay column. The formula used in the Net Pay column is "=total pay - taxes withheld".

Read more about spreadsheets here:

https://brainly.com/question/26919847
#SPJ1

Answer:A student information management system (SIMS) is a software tool that enables educational institutions to manage student information in a centralized and organized way. A SIMS typically includes a range of features, such as student records management, enrollment management, scheduling, and reporting.

The purpose of a SIMS is to provide educators with a comprehensive view of student information, including personal information, academic records, attendance records, and other important data. This information can be used to support decision-making, improve communication, and streamline administrative processes.

Some common features of a SIMS may include:

Student records management: This feature allows educators to store and manage student records, including personal information, academic records, and contact information.

Enrollment management: This feature enables educators to manage the enrollment process, including registration, course selection, and fees.

Scheduling: This feature allows educators to schedule classes and manage timetables.

Attendance tracking: This feature enables educators to track student attendance and monitor patterns of attendance.

Reporting: A SIMS may include reporting tools, which allow educators to generate reports on student progress, attendance, and other important data.

Communication tools: Some SIMS may include communication tools, such as messaging or email, which allow educators to communicate directly with parents or students.

to know more about attendance tracking system visit metaguardin

Explanation:

Choosing a compatible CPU for the motherboard, removing the protective cover, aligning and inserting the CPU into the socket, and securing it with the retention arm are all steps in the CPU installation procedure.

Start by placing your motherboard on a level place outside of your computer's chassis. Remove the little metal lever retaining the motherboard's LGA socket for Intel's CPU retention bracket. Insert your chip at this point.

You should first upgrade your motherboard if you're planning to use a new CPU before moving on. Your old motherboard should have all of its parts and cables removed before you can take it out of the chassis.

To know more about motherboard visit:-

https://brainly.com/question/29834097

#SPJ1

Answer:

The Hough transform is a feature extraction technique used in image analysis, computer vision, and digital image processing. It is used to detect simple shapes such as lines, circles, and ellipses in images. The Hough transform algorithm works by mapping points in an image space to lines in a parameter space. The algorithm then searches for peaks in the parameter space to detect lines in the image space.

Edge linking is often applied as a second step after applying the Hough transform. In edge linking, each peak represents a line across the image. You can visit the pixels along that line, find the ones that are set (assuming a binary input image) .

For example, let’s say you have an image of a circuit board with lines on it. You can use edge detection algorithms to detect edges of the lines in the image. Then you can apply the Hough transform algorithm to detect straight lines in the image. Finally, you can apply edge linking to connect these straight lines into longer lines .

Answer:

Explanation:

The area in Microsoft Edge that keeps things you collect on the web is called the "Hub". The Hub includes several sections, including:

Favorites: This section contains links to your favorite websites that you have saved for quick access.

Reading list: This section contains articles or web pages that you have saved to read later.

Browsing history: This section contains a list of the websites you have visited in the past.

Downloads: This section contains a list of files you have downloaded using Microsoft Edge.

To access the Hub in Microsoft Edge, click on the "Hub" icon located in the top-right corner of the browser window. It looks like three horizontal lines stacked on top of each other. Once you click on the Hub icon, you can navigate to the different sections by clicking on the appropriate tab

The area in Microsoft Edge that keeps things you collect on the web is called the "Hub". The Hub includes several sections, including Favorites,as well as reading list.

Favorite is the section contains links to your favorite websites that you have saved for quick access. and reading list is considered as the section contains articles or web pages that you have saved to read later.

Browsing history: This section contains a list of the websites you have visited in the past. Downloads: This section contains a list of files you have downloaded using Microsoft Edge.

To access the Hub in Microsoft Edge, click on the "Hub" icon located in the top-right corner of the browser window. It looks like three horizontal lines stacked on top of each other. Once you click on the Hub icon, you can navigate to the different sections by clicking on the appropriate tab.

Therefore, The area in Microsoft Edge that keeps things you collect on the web is called the "Hub". The Hub includes several sections, including Favorites,as well as reading list.

Learn more about Microsoft Edge on:

https://brainly.com/question/30474652

#SPJ2

In terms of question 1:

STUDENT (STUDENT SSN, ST_NAME, MAJOR, ADVISOR_NUM, ADV_NAME, ADV_OFFICE, ADV_PHONE, ST_CREDITHRS, CLASS_STANDING)

a. UNF (contains repeating group)

b. Dependency diagram:

STUDENT SSN → ST_NAME, MAJOR, ADVISOR_NUM, ST_CREDITHRS, CLASS_STANDING

ADVISOR_NUM → ADV_NAME, ADV_OFFICE, ADV_PHONE

c. Transformation to 3NF:

STUDENT (STUDENT SSN, ST_NAME, MAJOR, ADVISOR_NUM, ST_CREDITHRS, CLASS_STANDING)

ADVISOR (ADVISOR_NUM, ADV_NAME, ADV_OFFICE, ADV_PHONE)

Others are given in the document attached.

Normalization is the process of organizing a database into a set of tables with well-defined relationships between them to minimize redundancy and data inconsistencies. It involves breaking down a larger table into smaller, more focused tables that have a single topic or theme.

Therefore, the goal of normalization is to eliminate data redundancy and improve data integrity by avoiding common issues such as update anomalies, insertion anomalies, and deletion anomalies. By reducing the number of duplicate entries, normalization ensures that data is consistent and easier to maintain.

Read more about dependencies  here:

https://brainly.com/question/14377298

#SPJ1

See text below

Part II: additional problems 1, 2, and 3 listed below.

For each problem:

a. Identify the given table as 1NF, 2NF, 3NF, or UNF (contains repeating group).

b. Identify all partial and transitive dependencies by drawing a dependency diagram

(for a UNF table, transform it to 1NF, then draw the dependency diagram).

c.

Transform all tables into 3NF by following the steps below. For c, you do NOT have

to draw dependency diagrams.

Example (it uses the Figure 6.3 as the starting point):

Step a:

PROJECT (PROJ NUM, EMP_NUM, PROJ_NAME, EMP_NAME, JOB_CLASS,

CHG HOUR, HOURS)

(has partial dependencies and transitive dependency) (so it is in 1NF)

Step b: draw dependency diagram (refer to Figure 6.3 in textbook)

Step c:

INF→ 2NF (put partial dependencies in separate tables)

EMPLOYEE (EMP_NUM, EMP_NAME, JOB_CLASS, CHG_HOUR)

(no PD, but has TD) (so it is in 2NF)

PROJECT (PROJ NUM, PROJ_NAME)

(no PD, no TD) (in fact it is already in 3NF)

EMPLOYEE (EMP_NUM EMP_NAME, JOB CLASS)

3NF (no PD, no ID)

PROJECT (PROL NUM PROJ_NAME)

3NF (no PD, no TD)

ASSIGN (PROJ_NUM EMP NUM HOURS)

3NF (no PD, no TD)

1. STUDENT (STUDENT SSN, ST_NAME, MAJOR, ADVISOR_NUM, ADV_NAME, ADV_OFFICE, ADV_PHONE, ST_CREDITHRS, CLASS_STANDING)

where:

STUDENT SSN→ All other attributes

ADVISOR NUM→ ADV_NAME, ADV_OFFICE, ADV_PHONE

ST_CREDIT_HRS CLASS STANDING

Note: XYZ QRS means that XYZ determines QRS

You can also find this notation in figure 6.3 and definition of determination on page

62

2. MOVIE (MOVIE_NUM, MOVIE TITLE STAR_NUM STAR_NAME)

Sample data: You can determine pronary key based on the sample data

MOVIE NUM

M001

M002

MOVIE TITLE The Mummy

Crash

STAR NUM

S001

5000

S001

S003

STAR NAME Brendan Fraser Rachel Wenz

Brendan Fraser

Sandra Bullock

You may notice one mothe can feature many stars and one star can act in many movies

3 MOVIE (MOVIE_NUM MOVIE_TITLE, DIRECTOR NUM DIR_NAME

where:

MOVIE NUM

→ MOVIE TITLE DIRECTOR_NUM DIR_NAME

DIRECTOR NUM→ DIR_NAME

Requirement

Finish all problems parts Clearly mark each problem and put problems in the correct order. You can finish this homework in PowerPoint if you wish. Word is also acceptable as always.

Submission

Submit your solution file (Word or PowerPoint) through Canvas system electronically Printout (hard copies) or emails will NOT be accepted.

Turn in your homework on time. After the due time for every 24 hours it will be treated as a day late. I will use submission time in Canvas System as reference. 20% off for each day late.