Database Management

User Generated

Ghgbe1313

Computer Science

Description

For each of the following respond with at least 450 words.

Q1.

Review the advantages of database management systems in the Connolly text? Describe which advantage you think is the most important? Explain this choice by describing a database you use (either in your personal or professional experience) and how this advantage makes the system more effective.

Q2.

Discuss the characteristics of the relational data model, how that differs from a hierarchical model, and why/when the relational model may be better.

Q3.

In your own words - explain domain, Superkey, and Primary key. (It is OK to ask for feedback where you are uncertain.)Using the below figure discuss which fields could be Candidate keys and why. Provide an example of a Superkey (hint: it will probably be a combination of more than 1 field) Owners Table: (OwnerSS is a person’s social security number, we will also assign a unique OwnerID to each person). (we need to consider the domain of values) - assume this table is designed only for persons who are assigned a SS#!



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

Hi, I am back,, I have done your second assignment..please see attachment :). Plagiarism has been checked already :)

1

Database Management
Name
Affiliate
Date

2

Q1.
Review the advantages of database management systems in the Connolly text?
Describe which advantage you think is the most important? Explain this choice by
describing a database you use (either in your personal or professional experience)
and how this advantage makes the system more effective.
Answer:
Based on the advantages of Database Management System in Connolly text, the
most advantage for me is it improve the security of data. The more clients get the
information, the more prominent the dangers of information security ruptures. Companies
contribute significant measures of time, exertion, and cash to guarantee that corporate
information is utilized legitimately. A DBMS gives a system to better implementation of
information protection and security approaches. It improves the security of data in a way
that: controlling get entry to the database, such as making logins for clients and placing
parts for every client. a few customers may additionally simply want to inquiry the
information, while others are associated with entering new records. Supplying help
administrations to the stop customers, as an example, ensuring all clients know how to
utilize the database. Overseeing technique for reinforcement and recovery of facts, if
there have to be a prevalence of mistakes made through customers or framework crashes.
You will pick no longer to lose all the worthwhile facts on account that the strength went
out. Making sure records trustworthiness, which implies that data are completed, exact
and contemporary for the roles wanting to be achieved. Controlling facts protection,
together with forestalling unapproved access to the information and making sure against
other protection dangers (Almutairi, & Abdulrahman, 2012). Placing facts security,
which implies that lone approved humans can see certain information. as an instance,
there's no requirement for absolutely everyone within the affiliation to have the capacity
to see all of the faculty files ...


Anonymous
Awesome! Made my life easier.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags