Question: Quesytion 2 and 3 Database Design 1: Normalization display the TaskID, description, category, and price. Assume that each client that requests a particular service task

 Quesytion 2 and 3 Database Design 1: Normalization display the TaskID,description, category, and price. Assume that each client that requests a particular

Quesytion 2 and 3

Database Design 1: Normalization display the TaskID, description, category, and price. Assume that each client that requests a particular service task pays the same price. Convert this table to an equivalent collection of tables that are in third normal form: Invoice (InvoiceNum, clientNum, LastName, FirstName, Street, City, State, Zip Code, Date, (TaskID, Description. Category, Price)) 3. BITS wants to store information about the supervisors, including their supervisor number and the relationship to consultants. Supervisors can work with multiple consultants, but consultants only have one supervisor. In addition, supervisors specialize in working with clients in specific task categories. Using this information, convert the following unnormalized relation to fourth normal form: Consultant (Conslt Num, LastName, FirstName, Street, City, ZipCode, Hours, Rate, (SupervisorNum, SupervisorName). (Tasks, Description, 187

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!