Question: Need some help with this database question on normalization ITC6000-Class 3 Assignment Download the file caseo5 1Datalmg.gif. The table it contains describes the project assignments
ITC6000-Class 3 Assignment Download the file caseo5 1Datalmg.gif. The table it contains describes the project assignments and time put into the projects by a number of employees. Explain all the weaknesses you see in this table design. After the table design has undergone the normalization processes that you learned about in Chapter 5, what should the overall design look tike? 1. EmployeelD Name Project Time B1-26 B11-33 BN1-35 81-3 Bit-8 Bi1.4 Sen ?Brien 30.452-T3,30457-T332-244T3 Amy Guye Steven Barano 30-42 T3,31-238 TC Biateth Fosin 35-152-TC Caol Schaaf6272-TC 025,040,030 30-452-T3,30-382-TC, 32-244 T3 005,035,060 0.15,080 090 075 020,070 eandra vung 31-23&TC31-241-TC 2. Chapter 5 described an atomic attribute as one that cannot be further subdivided. Such an attribute is said to portray atomicity. Outline all the benefits gained from ensuring atomicity in database design. Provide an example ot a database design scenario in which atomicity ensures the integrity and fiexiblity of the database system
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
