Question: models Du, uata models, relational database, relational algebra, and ER e tupies of database systems Note: 1. Attempt all questions. The grade point of every

 models Du, uata models, relational database, relational algebra, and ER e

models Du, uata models, relational database, relational algebra, and ER e tupies of database systems Note: 1. Attempt all questions. The grade point of every question is written next to question number 2. If undergraduate students would like to earn extra or bonus points, you may attempt graduate student's question (Q3). Q1. (Total: 10 + 15 + 10 + 10 + 10 = 55 points) (a) (2*5-10 points) What are the disadvantages (any five) of database systems? (b) (53 15 Points) Discuss any three functions performed by the DBMS that (c) (10 guarantee the integrity and consistency of the data in the database. Points) What components should an implementation-ready data model contain? (d) (10 Points) What are the sources of database requirements or business rules, and what is the database designer's role with regard to business rules or requirements? (e) (10 points) Define entity integrity. What are the two requirements to ensure entity integrity? Q2. (10+10+10+15 45 points) (a) (10 points) What is a weak relationship? Provide a real-life example (must include schemas and keys in your answer). (b) (10 points) What is a ternary relationship? Provide some business rules o requirements example (at least one) that specify the need for a ternarycr higher-order relationship. (c) (10 points) Explain recursive relationships with the help of examples (at le two)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Databases Questions!