09 Sep Normalize the ER Diagram you created last week The diagram may not have significant changes if it was well designed originally. However, there are usually some changes or updates that would
Step 1: Normalize the ER Diagram you created last week (attached below). The diagram may not have significant changes if it was well designed originally. However, there are usually some changes or updates that would be appropriate. Explain why this step is important. Describe how you eliminated or reduced redundancy through this step. Include all documentation in a Word document and submit it to your instructor via the online class.
Step 2: Continue to work on your database (Links to an external site.) using in Access or your selected application. You may start to use Oracle Cloud or MS Database (Links to an external site.) and import your information. Take screen captures and include them in a Word document with a description of your experience in the database (Links to an external site.) thus far. Submit your Word document to your professor via the online class.
Note:No copypaste strickly, plagiarism results in termination.
Include references
Running head: ASSIGNMENT1
ASSIGNMENT2
Week 2 Assignment
Shanthi Sirsavada
Alliant International University
Week 2 Assignment
Department Name |
||
Department Name |
Data started (sales) |
Manager (in-charge) |
Category |
|
Item category |
Number of stock |
Business Rule 2
Category |
|
Items |
Includes |
Business Rule 3
Salesperson |
|
sales |
Items |
Business Rule 4
Store |
||
Incorporates |
Salesperson |
Business Rule 5
Office |
|
Manages |
Store |
Complete ERD Diagram
image5.png
image6.png
image1.png
image2.png
image3.png
image4.png