MODULE-2
1. Explain specialization and generalization concepts in ER diagram with suitable example
2. Design a generalization–specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles, passenger cars, vans, and buses. Justify your placement of attributes at each level of the hierarchy. Explain why they should not be placed at a higher or lower level.
3. Construct an E-R diagram for a car-insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents
4. Explain specialization and generalization concepts in ER diagrams with suitable examples.
5. Write a note on the trigger.
6. Draw an E-R diagram for the bank management system. OR Define E-R diagram. Draw an E-R diagram for the Library Management System. Assume relevant entities and attributes for the given system.
7. What is the difference between data security and data integrity?
8. 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.
9. Design a database for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted. 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.
10. What is constraint? Explain types of constraints
11. The relational database schema is given below. employee (person-name, street, city) works (person-name, company-name, salary) company (company-name, city) manages (person-name, manager-name) Write the relational algebra expressions for the given queries. 1.Find the names of all employees who work for First Bank Corporation. 2.Find the names and cities of residence of all employees who work for First Bank Corporation. 3.. Find the names, street address, and cities of residence of all employees who work for First Bank Corporation and earn more than $10,000 per annum. 4. Find the names of all employees in this database who do not work for First Bank Corporation
12. Construct an E-R diagram for a car insurance company whose customers own one or more cars each. Each car has associated with it zero to any number of recorded accidents. Each insurance policy covers one or more cars, and has one or more premium payments associated with it. Each payment is for a particular period of time and has an associated due date and the date when the payment was received.
13. What do you mean by integrity constraints? Discuss various integrity constraints.
0 Comments