Reading:
Module 6: Database Design: Relationships
Supplement Videos
Data base Design Process:
Relational Data base Relationships:
Question 1: Discussion
In this week’s reading, you learned about one-to-one and many-to-many relationships. While the concepts may seem beneficial, there are some drawbacks. For this discussion, you need to evaluate the pros and cons of each and make a recommendation regarding the usefulness of using these concepts in the JCC RDBMs.
Question 2: Assignment
You will not need to use a DBMS to complete this activity.
In an effort to further optimize the RDBMS you are developing for the JCC company, you noticed there was redundant data within the Employee Table. Following what you learned from your reading, complete the following in a 2-3 page APA-formatted paper:
Examine the Employees table. Note that the data in the Title field contains redundant values and, therefore, is a candidate for a one-field lookup table. Use your Access Query Design View or SQL skills to create a lookup table named Titles with the unique values in the Title field of the Employees table. List the steps you performed to create the lookup table.
Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount