Need help with 1-6
Can you fill out the tables how they are structured. And also draw the diagram using MS Visio so i could see the relationships and a attributes. Thank you
Conceptual and Logical Design The online store database needs to keep track of orders for its inventory. When a customer places orders, the system must record that the order and order items. The system must update the available quantity on hand to reflect that the by product(s) has been sold. When an employee processes orders, the system must confirm that the ordered items are in stock. The online store need to keep track of customers and employees, too. The system must update the available quantity on hand to reflect that the by product(s) has been sold. One customer may or may not place many orders. One order must be placed by one and only one customer. One order must contain one or more item. One item may or may not be in many orders. One employee may or may not process many orders. One order must be processed by one and only one employee. One customer must be either a business or individual customer. One business customer or individual customer must be a customer 1. Identify entity types and relationship types. Fill out the following relationship matrix 2.Draw an EER diagram includes 1 entity types, 2) relationship types, 3) keys, 4) cardinality constraints (must show participation) 3. Database Logical Design: Map the ER diagram to a relational database schema indicating the relation name, primary key and foreign key. Add appropriate additional attributes by yourself Table Name Table Name Table Name Table Name Table Name Table Name Table Name Table Name Establish join paths for the above relational database using the referential integrity by drawing arrow lines between the above tables. Indicate all the foreign keys (FK). 4. F.K. P.K. (Foreign Key refers to Primary Key) 5. Do function analysis for each of your tables Attribute A ->Attribute B (Determinant attribute(s) Show all the normalized tables and indicate the normalization form for each of your tables. Table Name Determines Dependent Attribute(s)) 6. INF 2NF 3NF