Relational database design for truck fleet management system
SQL represents the foundation upon which commercial relational database software is based. The number of terms required to navigate use this language is relatively small, but understanding the full meaning and implications of each term requires considerable study. This report examines a selection of terms and how they are used to describe the interdependent relationships between entities and attributes.
✍️ How to write this paper — guide & tools ▾
Relational Databases
For each table, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided.
PRIMARY KEY
FOREIGN KEY
Truck
TRUCK_NUM
BASE_CODE, TYPE_CODE
Base
BASE_CODE
TYPE_CODE
Do the tables exhibit entity integrity? Answer yes or no, and then explain your answer.
ENTITY INTEGRITY
EXPLANATION
Truck
All rows under the primary key TRUCK_NUM are uniquely identified and there are no null entries
Base
All rows under the primary key BASE_CODE are uniquely identified and there are no null entries
All rows under the primary key TYPE_CODE are uniquely identified and there are no null entries
19. Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write NA (Not Applicable) if the table does not have a foreign key.
TABLE
REFERENTIAL INTEGRITY
EXPLANATION
Truck
Yes
All values under the foreign keys BASE_CODE and TYPE_CODE refer to a valid tuple in the BASE and TYPE tables, respectively. Null values are allowed
Base
NA
NA
Type
NA
NA
20. Identify the TRUCK table's candidate key(s).
Aside from the foreign keys BASE_CODE and TYPE_CODE, all other keys are candidate keys because they could be used as unique identifiers for each truck. This statement assumes that the nine trucks listed in the table is exhaustive. The candidate keys are therefore: TRUCK_NUM, TRUCK_MILES, TRUCK_BUY_DATE, and TRUCK_SERIAL_NUM.
21. For each table, identify a superkey and a secondary key.
TABLE
SUPERKEY
SECONDARY KEY
Truck
Already a member? Log in
Unlock the rest of this paper
135,000+ research papers · AI writing tools · Plagiarism & AI detection
7-Day Pass
Does not renew
Get 7-Day PassMonthly
Renews at $12.99/month until canceled
Start MonthlyAnnual
Renews at $99/year until canceled
Start Annual- Unlimited AI writing tools
- Plagiarism and AI text detection tool
Plan details
Unlimited AI writing tools are for individual, non-automated use and are subject to our Terms of Service and abuse-prevention measures.
TextChecker scans: 3 during the 7-Day Pass, or 5 per month with Monthly and Annual.
Prices exclude applicable tax.
- Colonel, C., Morris, S., & Rob, P. (2012). Database Systems: Design, Implementation, and Management (10th edition). Boston, MA: Cengage Learning.
Always verify citation format against your institution’s current style guide requirements.