BCA Semester 4 – Database Management System – Unit 2: Database Design, Architecture and Model (6Hrs.)

What is Data Model? What is the difference between hierarchical and network data model? what are its types?

Design an ER diagram for Hospital System. Use your assumption for the selection attributes, entities and relationships. Show the use of total and partial participation along with the appropriate cardinalities.

a) Design an ER diagram of your choice. The ER diagram should contain at least five entities. Out of those entities, one should be weak entity. Your entities should have appropriate attributes including primary key attributes, if any. There should be presence of one to one relationship, one to many relationship and many to many relationships in your ER diagram.
b) Convert the ER diagram in Q. 19. a. into equivalent relational tables.

Describe 3-schema architecture of database.

Describe the use of ER diagram. Draw an ER diagram for a university to design a database for it.

What is data model? What are its types? Describe the structure of database.

Draw and explain three schema architecture of the database system.

What are an entity and its attributes? Write the difference between a strong and weak entity set with an example.

How participation constraints are used in ER diagram? Explain. Also 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 and has an associated due date, and the date when the payment was received.