ITC XXXXXXXXXXS I Version 2 - Published 22 January 2019ITC556 - Database SystemsTable of...

Question

ITC XXXXXXXXXXS I Version 2 - Published 22 January 2019
ITC556 - Database Systems
Table of Contents
Subject Summary ............................................................................................... XXXXXXXXXX2
Subject Coordinator ........................................................................................... XXXXXXXXXX2
Subject Coordinator .............................................................................. XXXXXXXXXX2
Email ...................................................................................................... XXXXXXXXXX2
Phone ..................................................................................................... XXXXXXXXXX2
Consultation procedures ...................................................................... XXXXXXXXXX2
Subject Overview................................................................................................ XXXXXXXXXX2
Abstract .................................................................................................. XXXXXXXXXX2
Learning outcomes................................................................................ XXXXXXXXXX3
Subject content ..................................................................................... XXXXXXXXXX3
Key subjects........................................................................................... XXXXXXXXXX3
Subject Schedule & Delivery .............................................................................. XXXXXXXXXX3
Prescribed text....................................................................................... XXXXXXXXXX3
Class/tutorial times and location ......................................................... XXXXXXXXXX3
Schedule ................................................................................................ XXXXXXXXXX4
Learning materials................................................................................. XXXXXXXXXX6
Learning, teaching and support strategies .......................................... XXXXXXXXXX6
Recommended student time commitment ......................................... XXXXXXXXXX9
Assessment Items ...............................................................................................

itc556201930si-version2-iowvbq1j.pdf

Amit · Accepted Answer

39859/39859.docx
Title of the assignment: Normalization 
Student’s name:
Professor’s name:
Course title: ITC 556 (Assignment – 3)
Date:
Table of Contents
1.	Dependency diagram	3
2.	3NF based dependency diagram	3
3.	Crow’s Foot ERD	4
4.	References:	5
1. Dependency diagram
The dependency diagram is used to show the possible dependencies in presented relation in graphical way, so that the database handlers can overcome these dependencies for making required changes in database. The dependency diagram to supplied “patient Record” table in my assignment is:  
2. 3NF based dependency diagram
Performing normalization to 3NF requires that the dataset must provide satisfaction to 1NF and 2 NF. When the required dataset becomes in 2NF, then, its transitive and partial dependencies are removed from it to make it in 3NF. So, the dependency diagram to supplied “patient Record” table in 3NF is:
3. Crow’s Foot ERD 
The Crow’s Foot ERD diagram to supplied “patient Record” table in my assignment is:  
4. References: 
Raiha, K. J., Raiha, K. J., & Mannila, H. (1992). Design of relational databases. Addison Wesley Publishing Company.
Elmasri, R., & Navathe, S. (2016). Fundamentals of database systems. London: Pearson.
Coronel, C., & Morris, S. (2016). Database systems: design, implementation, & management. Cengage Learning.
5
39859/ITC556_1.png
39859/ITC556_1.

ITC XXXXXXXXXXS I Version 2 - Published 22 January 2019 ITC556 - Database Systems Table of Contents Subject Summary...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment