Answer ALL questions Marks Question 1 a) Explain the term relational database. 2 b) Explain the following terms: 2 i) Entity ii) Attribute c) Identify FOUR (4) types of entities for which an airline might store data. 4 d) Explain the term metadata and describe its purpose in a relational database. 2 Total 10 Marks Question 2 a) A database is an example of a CRUD application. What does the acronym CRUD stand for? 4 b) The following table is part of a database for insurance policies. It is in Third Normal Form (3NF). Suggest appropriate data types and keys (if applicable) for the attributes listed 6
Added by Nancy P.
Close
Step 1
Question 1 Show more…
Show all steps
Your feedback will help us improve your experience
James Kiss and 92 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Akash M.
What is a DBMS? Provide examples. List and describe some typical DBMS processes.
Chandra J.
CBR-ERD The following ERD will be used to answer the questions on this examination. You may reference this image on-screen or download the image so that you can more comfortably scroll in to enhance readability. Please use this ERD when answering all questions. Instructions for A: If a table is already properly normalized, then you do not need to make any modifications to it. Only write down your response to those table(s) that require normalization. Answer the following referring to the CUSTOMER schema. You are to properly normalize the tables to 3NF, allowing customers to have more than one phone number. Format: TableName ([PK] Primary Key, [FK] Foreign Key, Attribute Fields)
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD