Question
Analyze the proposed project table structure below and determine the candidate and primary key fields. Follow the rules listed in the Elements of a Candidate
Analyze the proposed project table structure below and determine the candidate and primary key fields. Follow the rules listed in the Elements of a Candidate Key and Elements of a Primary Key sections on the internet. Complete the following steps:
Step 1. Before you can determine the primary keys and candidate keys, you will need to ask a series of questions (Q&A) about the project table shown below. List your questions and answers, then follow Step 2 below. You may need to make some assumptions (e.g., the purpose of the project table); if so, document them.
Step 2. For each of the fields in the proposed projects table, list details, and assumptions based on the information you collected in Step 1.
Step 3. Based on the information you gathered in Steps 1 and 2, make any necessary changes to the project table structure. Feel free to propose additional tables in order to meet the requirements. Describe the rationale for your assignments of the primary key and candidate keys in your table(s) and explain any changes that you propose to the project table structure or any additional table(s).
Project Table
ProjDescription | ProjLocation | ProjStartDate | DeptName | EmpName | TimeOnJob | Parts |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started