Summary:

This task aligns with Student Learning Outcome 4 (SLO4), where you will explain how relationships between entities are defined and refined, and Course Learning Objective 4 (CLO4), where you will evaluate entity relationships and incorporate them into a sound database design.

Deliverables:

1. Review and Refine Relationships: Revisit the following schema and improve the relationships. (attached below the assignment files)
2. Define Integrity Constraints: Specify primary keys for each table, and establish foreign keys to connect related tables. Define any necessary constraints (such as NOT NULL or UNIQUE) that will help ensure the accuracy of your data.
3. Use the following video as a reference on how to achieve similar tasks
4. :
6. Provide detailed report APA style with 1-2 pages that explain the changes you did with at least 2 peer reviewed resources

Use the following files (ERD diagram and Schema) [click and right-click then save file] or use the files from the week 4 content

Struggling with your essay and deadlines?

Get this or a similar paper done in as fast as 4 hours, 24/7.

NB: We do not sell prewritten papers. All essays are written from scratch according to specific needs and instructions

✔Secure Service ✔ Plagiarism Free ✔On-time Delivery

WRITE MY PAPER