Homework answers / question archive / Your organization has requested that you create a new database to support organizational needs

Your organization has requested that you create a new database to support organizational needs

Computer Science

Share With

Your organization has requested that you create a new database to support organizational needs. Based on the information you provided in this week’s Discussion, create a database as defined in the database project.

The project must include at least five tables, and should have no more than 10 tables.

1. Define your database.
o Describe the database, its purpose, why it was created, who it was created for, who the
users are, and what type of processes and functions it will support.
o List the entities of your database.
o Present the business rules that determine connectivity, using the format reviewed in
Week 2.
o Draw the ERD; copy the drawing into your Word project document.
2. Create the database and tables for the database. Show all SQL statements. Include
primary and foreign keys.-SEE BELOW