a) List any three causes of database failures and explain any one of those causes. [4]...

a) List any three causes of database failures and explain any one of those causes. [4]

b) Explain any six characteristics of a Relation [6]

Solutions

Expert Solution

a)There are many causes of database failure. The main three causes according to me are

File System Damaged
Software Failure
File Corruption

Here I want to discuss one of the main cause for database failure File corruption.

File Corruption: When a primary file in a set of file get corrupted that corrupted primary file can corrupt the entire file system that causes database failure. The primary file can be corrupt due to change in SQL server, deletion of data or file header change. When a secondary file gets corrupted we can't access the database.

We use Relation in the database for some benefit. Some of them are fast access of data from the database , to ensure no duplicate data stored in our database. data stored in the database must be in order.

So the main characteristics of a Relation is :

Prevention of Duplicate tuples: Relation used in DBMS to ensure that there are no duplicate tuples in the database.
Single valued attributes: Every attribute must contain only one value.
Data integrity: Data integrity can be achieved by using relation in a database by linking table property.
Security of Data: Relational database provides who can access data or perform which operation into the database.
Primary Key: One of the main features of the relational database is the use of Primary Key. Primary Key use to link tables, access any row.
Values in a column of a relational database must have the same data format and the same attribute domain.

venereology answered 10 months ago

Next > < Previous

Related Solutions

1. A transaction is sequence of database operations that access the database. list and explain the...

1. A transaction is sequence of database operations that access the database. list and explain the six states in which a transaction can exit. 2. Explain the techniques that transaction recovery procedures follow.

List three applications that use UDP and three applications that use TCP and explain why those...

List three applications that use UDP and three applications that use TCP and explain why those applications use the selected Transport layer protocol.

b. List and explain the 4 causes of market failure included in the slides, including how...

b. List and explain the 4 causes of market failure included in the slides, including how they actually lead to market failure. Don’t miss this part! Need more detailed explanation here. How do these actually lead to market failure.

Explain Aristotle’s 4 causes.

List the features for an industry characterized by monopolistic competition. Explain which one of those features is...

List the features for an industry characterized by monopolistic competition. Explain which one of those features is the key reason for the shape of the firms demand curve.

In examining the list of the top ten causes of medical errors, are there any detectable...

In examining the list of the top ten causes of medical errors, are there any detectable patterns or categories of errors you would devise? Are any of these errors directly related exclusively to human error? If an error was caused, in part, by the health issues of the patient, should it be considered the hospital or health professional’s error? Do the measurements of quality in a nursing home include any of the ten medical errors identified in Van Den Bos’...

Question