Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started