Differences between Various DBMSs, programming homework help

in /by

Differences between Various DBMSs, programming homework help

Assignment 3: Dropbox Assignment

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 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?

Support your answers with examples.

Cite any sources in APA format.

Submission Details

Name your document SU_ITS2110_W1_A3_LastName_FirstInitial.doc.

Assignment 3 Grading Criteria

Maximum Points
Explained the various database models. Compared the models with the relational model.

10
Explained how database models store and retrieve data.

5
Described the purpose of SQL in databases.

5
Explained the importance of referential integrity.

5
Described database concurrency and explained its use.

5
Described the functions of a DBMS and provided the name for the self-describing attribute of a database. In addition, explained the difference between a personal DBMS and an enterprise-level DBMS.

5
Described the characteristics of a poorly designed DBMS.

5
Explained the three types of database design. Mentioned the year in which and by whom the relational model was developed. Also named the DBMSs invented after the relational model.

5
Used correct spelling, grammar, and professional vocabulary. Cited all sources using APA format.

5

"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.


Discount Code: CIPD30



Click ORDER NOW..

order custom paper