What are the different database models? How do these models compare with the rel

Question

What are the different database models? How do these models compare with the relational model? Do the various database models store and retrieve data differently? Explain? What is SQL and for what purpose is it used in databases? What is referential integrity and why is it important? What is database concurrency and what does it prevent? A database is self-describing. By what other name is this attribute known as? What are the functions of a DBMS? List them and provide a brief but meaningful description of each. What separates a personal DBMS from an enterprise-level DBMS? Database design is important and full of challenges. Many databases are poorly designed. What are the characteristics of a poor database design? What are the three types of database design? In what year was the relational model developed and who developed it? What other DBMS constructs came after relational databases?

Explanation / Answer

Different database models are : Relational, Transactional, Multi-dimensional Yes, relational DB stores relations between data, multi-dimensional DB stores multi-dimensional views of data, etc. SQL is a query language used to store and retrieve data to and from database respectively. Referential integrity is a property of data which, when satisfied, requires every value of one attribute (column) of a relation to exist as a value of another attribute in a different (or the same) relation.. database concurrency is the concept by which database can be updated by multiple users at the same time. It prevents redundancy of data. Metadata. Functions of DBMS: data dictionary management, data storage management, data transformation and presentation, security management, multiuser access control, backup and recovery management, data integrity management, database access languages and application programming interfaces, database communication interfaces, and transaction management. Personal DBMS is used to store personal data which is small in size whereas enterprise-level DBMS is used to store large volumes of data. Poor Database Design: It has redundant data Missing Values Different data formats of data, etc. Three types of database design are: conceptual schema Logically structured data Phsical design relational model was developed by E.F. Codd in 1970 ROLAP - Relational Online Transaction Processing.

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.