ITC6000-Class 3 Assignment Download the file caseo5 1Datalmg.gif. The table it c

Question

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

Explanation / Answer

Weaknesses in the table design:

After normalization table will look as follows:

EmployeeID

Name

Project

Time

Project

EmployeeID

EmployeeID

Name

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.