Why is the relational model important?

Determine whether the following statement is TRUE / FALSE   1. A data model is usually graphical.    2. Database designers determine the data and information that yield the required understanding of the entire business.   3. Business rules must be rendered in writing.   4. A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user. 5. Each row in the relational table is known as an entity instance or entity occurrence in the ER model.   6. In an SQL-based relational database, rows in different tables are related based on common values in common attributes.   7. M:N relationships are not appropriate in a relational model.   8. In Chen notation, entities and relationships have to be oriented horizontally; not vertically.   9. Today, most relational database products can be classified as object/relational.   10. The network model has structural level dependence.

Are the tables normalized? If so, can you explain how and why your logical (relational) model is in first, second, and third normal form in relation to the question specifically?

Give THREE (3) limitations of the relational model which have led to alternative data models being proposed. Name three of these alternative models.

How do entities differ from attributes in a relational data model?

Explain the ACID and BASE properties in the context of database transactions. When is each property more suitable?

Give a justification for why a relational database cannot support many-to-many relationships, and support your position with an example?

Create tables based on the below given relational model. Define your own data type to the attributes and apply your own constraints to the attributes Identify the primary, Hospital tables: patients (patient-id, name, insurance, date-admitted, date-checked-out) doctors (doctor-id, name, specialization) test (testid, testname, date, time, result)

QUESTION 7 Answer All the questions: Consider the below Student table and write the appropriate relational algebra query: SNAME SLNAME Mariam Al Alawi Al Salti Al Ruzaiqi SID AGE CID CNAME City ITDR2106 | Introduction to Database Sur ITDR2104 Programming 1001 20 1002 Sara 22 Sohar 1003 Rahma 1004 Busma 22 ITDR1101 Introduction to IT Muscat Al Mammari ITDR2104 Programming 23 Muscat 1005 Salim Al Busaidi 24 ITSW3101 App. Sw. Development Muscat Find the name of the students and the city name whose age is above 20 years and below 24 years?