1. Use MS Visio to create relational data schemas and data dependency diagrams for all entities...

 

Transcribed Image Text:

1. Use MS Visio to create relational data schemas and data dependency diagrams for all entities (tables). Start out with listing all data attributes in 1NF, then label partial dependencies and potential transitive dependencies. Refer to guided practice 3.2. 2. Next, break down all partial dependencies into their own entities (tables) normalizing to 2NF. Note: You can create new pages in Visio using the plus sign at the bottom of the page. 3. Lastly, break down any transitive dependencies into their respective entities, normalizing to 3NF. Keep in mind that it is possible not to have any transitive dependencies and therefore your diagrams and schemas in 2NF could also be in 3NF. Be sure that each entity (table) is in 3NF and identifies primary and foreign keys. 4. Create an ER diagram of your tables in 3NF. Include all minimum and maximum cardinalities with the crow's feet notation. Tables, Primary Keys, & Attributes Table: Employees o Primary Keys: EmpID o Attributes: EmpFName, EmpLName • Table: Products o Primary Keys: ProdID o Attributes: ProdType, ProdName, ProdPrice, ProdBrand • Table: Console o Primary Keys: ConID o Attributes: ConName, ConBrand ● Table: Transaction o Primary Keys: TranID o Attributes: TranType, TranDate 1. Use MS Visio to create relational data schemas and data dependency diagrams for all entities (tables). Start out with listing all data attributes in 1NF, then label partial dependencies and potential transitive dependencies. Refer to guided practice 3.2. 2. Next, break down all partial dependencies into their own entities (tables) normalizing to 2NF. Note: You can create new pages in Visio using the plus sign at the bottom of the page. 3. Lastly, break down any transitive dependencies into their respective entities, normalizing to 3NF. Keep in mind that it is possible not to have any transitive dependencies and therefore your diagrams and schemas in 2NF could also be in 3NF. Be sure that each entity (table) is in 3NF and identifies primary and foreign keys. 4. Create an ER diagram of your tables in 3NF. Include all minimum and maximum cardinalities with the crow's feet notation. Tables, Primary Keys, & Attributes Table: Employees o Primary Keys: EmpID o Attributes: EmpFName, EmpLName • Table: Products o Primary Keys: ProdID o Attributes: ProdType, ProdName, ProdPrice, ProdBrand • Table: Console o Primary Keys: ConID o Attributes: ConName, ConBrand ● Table: Transaction o Primary Keys: TranID o Attributes: TranType, TranDate