Question

1- How can database systems improve data quality and data integrity? 2- Discuss database constraints: Primary...

1- How can database systems improve data quality and data integrity?

2- Discuss database constraints: Primary key, check, and referential integrity constraints? Give an example for each.

Homework Answers

Answer #1

Hope you will like the answer if you have any query ask me in comment section I will reply your solution as soon as possible and please upvote me for the efforts given to this answer

1.

The world of data is constantly changing and evolving every second. This in turn has created a completely new dimension of growth and challenges for companies around the globe. By accurately recording data, storing, updating and tracking them on an efficient and regular basis, companies can address their challenges on one hand and make use of the immense potentials offered by this sector on the other hand.

A database management system stores, organizes and manages a large amount of information within a single software application. The use of this system increases efficiency of business operations and reduces overall costs.

Database management systems are important in businesses and organisations because they provide a highly efficient method for handling multiple types of data. Some of the data that are easily managed with this type of system include: employee records, student information, payroll, accounting, project management and inventory. These systems are built to be extremely versatile.

Without database management, tasks have to be done manually and take more time. Data can be categorized and structured to suit the needs of the company or organization. Data is entered into the system and accessed on a routine basis by assigned users. Each user may have an assigned password to gain access to their part of the system. Multiple users can use the system at the same time in different ways.

Data Quality refers to the characteristics that determine the reliability of information to serve an intended purpose including planning, decision making and operations. It is the state of complete features and attributes that define the usability of information to address specific needs in context of real-world circumstances and implications

Data Integrity refers to the characteristics that determine the reliability of the information in terms of its physical and logical validity. Data Integrity is based on parameters such as accuracy, validity and consistency of the data across its lifecycle.

2.

The PRIMARY KEY constraint uniquely identifies each record in a table.

Primary keys must contain UNIQUE values, and cannot contain NULL values.

A table can have only ONE primary key; and in the table, this primary key can consist of single or multiple columns (fields).

Example:

The following SQL creates a PRIMARY KEY on the "ID" column when the "Persons" table is created:

MySQL:

CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    PRIMARY KEY (ID)
);

The CHECK constraint is used to limit the value range that can be placed in a column.

If you define a CHECK constraint on a single column it allows only certain values for this column.

If you define a CHECK constraint on a table it can limit the values in certain columns based on values in other columns in the row.

The following SQL creates a CHECK constraint on the "Age" column when the "Persons" table is created. The CHECK constraint ensures that the age of a person must be 18, or older:

MySQL:

CREATE TABLE Persons (
    ID int NOT NULL,
    LastName varchar(255) NOT NULL,
    FirstName varchar(255),
    Age int,
    CHECK (Age>=18)
);

Referential integrity requires that a foreign key must have a matching primary key or it must be null. This constraint is specified between two tables (parent and child); it maintains the correspondence between rows in these tables. It means the reference from a row in one table to another table must be valid.

Examples of referential integrity constraint in the Customer/Order database of the Company:

  • Customer(CustID, CustName)
  • Order(OrderID, CustID, OrderDate)

To ensure that there are no orphan records, we need to enforce referential integrity. An orphan record is one whose foreign key FK value is not found in the corresponding entity – the entity where the PK is located. Recall that a typical join is between a PK and FK.

The referential integrity constraint states that the customer ID (CustID) in the Order table must match a valid CustID in the Customer table. Most relational databases have declarative referential integrity. In other words, when the tables are created the referential integrity constraints are set up.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
1. Suppose StudentID is the primary key of one table (e.g., the Students table) and the...
1. Suppose StudentID is the primary key of one table (e.g., the Students table) and the foreign key of another table (e.g., the Top10DesiredJobs table). If you can’t enforce the referential integrity relationship between these two tables, what might be the cause? Select one: a. The values of the primary key column are referenced by the values of the foreign key column. b. The foreign key contains duplicate data. c. The foreign key column contains values that do not exist...
Explain how a health care organization could or did use the data to improve the quality...
Explain how a health care organization could or did use the data to improve the quality of patient care and the implications of using data that is not valid ( following concepts: data recovery, data integrity, and/or data reliability related to health care databases).
Question 1 2 Marks Briefly explain the referential integrity rule. Provide a suitable situation when the...
Question 1 2 Marks Briefly explain the referential integrity rule. Provide a suitable situation when the referential integrity constraint is violated. Question 2 2 Marks This question refers to the Part table as used in this unit lecture slides about the customers to order homeware parts. Using SQL DCL command to write a statement to permit a user with the log in ID of JOHNSON to access the Part table and update its UnitPrice value. Question 3 2 Marks Consider...
How can data provide information to evaluate quality patient outcomes? Give an example of data that...
How can data provide information to evaluate quality patient outcomes? Give an example of data that can reflect poor quality in care. How can quality improvement be a daily task in patient care? Why does continuous quality improvement need to be associated with change?
***** this is question and answer i just need the schema Data Modelling is the primary...
***** this is question and answer i just need the schema Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data. Data Modeling:- Data Modeling is the first step in database designing.It is the representation of data model, or collected data. Also shows that collected data stored in database and linked...
In MS Access, if you have two related tables and you check the box to enforce...
In MS Access, if you have two related tables and you check the box to enforce referential integrity, how does the software behave during the insertion of a new record into the many table? Question 34 options: 1) It prevents a row from being inserted into the many table if the data in the foreign key column does not match any of the values in the primary key column of the one table. 2) It prevents any records from being...
How can data integrity promote patient safety.   Can you think of – or do you have...
How can data integrity promote patient safety.   Can you think of – or do you have an example, when an alert may have prevented a medical error?
car dealership needs to design a database for their business. It is assumed there are three...
car dealership needs to design a database for their business. It is assumed there are three tables in the database with 6 fields in each table. Give your suggestions for the most necessary fields and their proper types, propertis and PK (primary key) / FK (foreign key) You can enlarge the answer window this way. Click in the answer box, then on the bottom right of the answer box, click on the triangle of dots icon and drag the window...
Question 1 Why does an organisation need to prepare systems documentation? Explain two reasons accountants need...
Question 1 Why does an organisation need to prepare systems documentation? Explain two reasons accountants need to be familiar with systems documentation techniques.    Question 2 The following data elements comprise the conceptual level schema for a database: billing address cost credit limit customer name customer number description invoice number item number price quantity on hand quantity sold shipping address terms You are required to create the schema tables. Specify the primary key(s), foreign key(s), and other data for each...
1) Constraints limit the degree to which the objective can be pushed in linear programming. As...
1) Constraints limit the degree to which the objective can be pushed in linear programming. As a manager, how do you know which constraints are proper to use in your decision model? Describe a basic situation and give an example of a constraint you are able to identify. 2) What role does feasibility play in linear programming, in your opinion?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT