DATABASE CONCEPTS

computer science

Description

Q1. Explain the distinction between total and partial constraints. [1

Marks]

Q2. Explain the difference between a weak and a strong entity set. [1

Marks]

Q3. Explain the distinction between condition-defined and user-defined constraints. Which of these

constraints can the system check automatically? Explain your answer [1 Marks]

Q4. Design a database for an airline. The database must keep track of customers and their

reservations, flights and their status, seat assignments on individual flights, and the schedule and

routing of future flights. (Your design should include an E-R diagram, a set of relational schemas, and

a list of constraints, including primary-key and foreign-key constraints.)

Instruction Files

Related Questions in computer science category