ITS2110 Differences Between Various Database Management Systems Paper

ITS2110 Differences Between Various Database Management Systems Paper

Question Description

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?

Support your answers with examples.

Cite any sources in APA format.