Scribd
Upload
12 views2 pages

Database Schema vs. State Explained

Uploaded by

Ahmedo Telaha
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views2 pages

Database Schema vs. State Explained

Uploaded by

Ahmedo Telaha
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Chapter 2 Review Questions

Due: Sunday October 4, 2020 @ 11.59pm


1. What is the difference between a database schema and a database state?

A database schema is the skeletal structure that represent the logical view of all the
entire datasets defining how the data are organized and how the relations among them
are associated. While Database state refers to the content of a database at any point in
time.
2. Choose a database application with which you are familiar. Design a schema and show
a sample database for that application, using the notation of Figures 1.2 and 2.1. What
types of additional information and constraints would you like to represent in the
schema? Think of several users of your database and design a view for each.

Salesman
Salesman_id Name City Commission
Customer
Customer_id Cust_name City Grade Salesman_id

You might also like