ITS2110 Differences Between Various Database Management Systems Paper

User Generated

EblnyErory

Programming

ITS2110

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Running head: DATABASE MANAGEMENT SYSTEMS (DBMSs)

Database Management Systems (DBMSs)
Name:
Institutional Affiliations:

1

DATABASE MANAGEMENT SYSTEMS (DBMSs)

2

Database Management Systems (DBMSs)
Q. 1.
The database model describes the database structure and logical design and describes the
information will be accessed, updated, and stored in the database system of management. Whereas
the Relational Model involves the highly broadly utilized database model, but there exist other
models also. However, the several database models are the Hierarchical, network model, and the
entity-association Model. Relational model involves the most known database model that uses a
format based on a table, also called relations, everyone of which comprises of rows and columns,
every column lists entity’s attributes in question, like the birth date, zip code, and price (Lithmee,
2019). Together, those attributes in a relation refer to a domain.
Q. 2.
Yes, the different database models is involved with data retrieval and data storage
differently. The relational database model stores the associations between the data, the multidimensional database on the other hand stores the multi-dimensional information views. The
entity-relationship model of data is grounded on several basic objects, known as entities, as ...


Anonymous
Excellent resource! Really helped me get the gist of things.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags