Question: 1. What does physical data independence mean? Give an example using SQL and explain why it is important to database systems. 2. Explain the

1. What does

1. What does "physical data independence" mean? Give an example using SQL and explain why it is important to database systems. 2. Explain the difference between database and database management system. 3. A vehicle registration database has the following fields: vin (vehicle identification number), tag_number, make, model, year, color. Which field or fields can be considered as superkey(s)? Which field or fields can be considered as candidate keys? Which field or fields is the best for primary key? Give reasons of your answer. 4. Write SQL DDL to do the following: (following the integer, varchar() data types as shown in the textbook) 4a. Create a table driver with the following fields: license, name, address. Select a primary key. 4b. Create a table car with the following fields: plate, model, year, color. Select a primary key. 4c. Create a table owner with the following fields: license, plate. Select a primary key. When everything works, copy and paste your SQL commands from the query to the word file with the answer of the first three questions. Submit the word file.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Lets break down the information provided in your image and answer each question step by step 1 Physical data independence refers to the capacity of a database system to allow the database schema at th... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!