Design the NEW JCC RDBMS and demonstrate some of the functionality.

Reading:

Module 4: The Relational Model: Advanced Topics

Assessment :

Submit your answers to the following questions in a 2–3-page APA-formatted paper.

Using everything you have learned in the course thus far; it is now time to design the NEW JCC RDBMS and demonstrate some of the functionality:

• Using the tables from the Sample Data for JCC, examine each table and determine which tables it would make sense to link and discuss why.
• Create the necessary Joins to link these tables together.
• Create a VIEW for these joined tables to provide JCC visibility.
• JCC needs to be able to contact clients when problems arise concerning an estimate. Which other attributes could JCC include in the client’s table to assist in contacting clients?
• JCC wants the database to include data on all its employees, not just those who may be involved in projects. Which additional entities would the DBA need to include in the database to store this data? Which attributes?
• What kinds of unstructured data or big data might JCC want to gather in the future?