Differences between Various DBMSs
The distinction between single-user DBMSs and multiuser DBMSs is clear from reading the names, but there are other classifications of databases. Relational databases are the most widely used model at this time.
Using the South University Online Library or the Internet, research various types of DBMSs.
Based on your research and understanding, create a 2- to 3-page Microsoft Word document that includes answers to the following:
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?