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 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
Get step-by-step solutions from verified subject matter experts
