Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions