Part I. Please include the questions with your answers. Answer in complete sente

Question

Part I. Please include the questions with your answers. Answer in complete sentences where applicable. 1.List the characteristics that a table must have to be considered a relation.. 2.List two synonyms for “file,” two for “record,” and two for “field.”. 3.What are the four uses of a primary key?. 4.What are the desirable characteristics of a primary key?. 5.What is a surrogate key and when do you use them?. 6.What is a foreign key?. 7.What is referential integrity and why is it important?. 8.What are the three possible interpretations of a null value?. 9.What is normalization? Why is it important?. Part II. After you install Microsoft Access, please use the Microsoft Website Support of Getting Started to learn the steps of creating a database for your assignment. You find the tutorials https://support.office.com/en-us/article/Access-2013-training-courses-videos-and-tutorials-a4bd10ea-d5f4-40c5-8b37-d254561f8bce Using Microsoft Access, create a small database of your own (do not use the examples given in the text or lectures). The database should have two tables that have a relationship through a foreign key. In this document please tell me the name of the primary key of each table and the name of the foreign key. Please save your database and submit the database file (.accdb file) to this assignment in addition to the Word document containing the 9 questions here.

Explanation / Answer

1.
-we need to have rows and columns
-we need to have cells which hold values
-each column has a unique name
-We need to have primary key and foriegn key.
-with the help of the above two keys we can maintain a relation between two tables as the first table should have primary key and other table which we are looking to hae realation should have foriegn key.

2.
File - Table
Record -Tuple,row,entity
Field - Column,Attribute,metadata

3.

- To identify a row
- To represent the row in foreign keys
- To maintain relation with other tables with the help of foriegn key
- As a basis for indexes and other structures to facilitate searching in storage

4.

-It is Stable as it does not change over time
- It is Minimal as it fewest attributes necessary
- It is Minimal as it is Factlessit has no hidden information
-It is Definitive as the value always exists
-It is Accessible available when data created
-The main characterstics is it is Unique as it have absolutely no duplicates

5.

Surrogate key is also a uniquekey and it also called as substitution for the natural primary key.It mainly used in Dataware housing A surrogate key is a unique, numeric identifier that is appended to a relation to serve as the primary key.he only requirement for a surrogate primary key is that it is unique for each row in the table.Data warehouses typically use a surrogate, (also known as artificial or identity key), key for the dimension tables primary keys. They can use Infa sequence generator, or Oracle sequence, or SQL Server Identity values for the surrogate key.

6.

A foregin key is used to maintain relation between two tables as A FOREIGN KEY in one table points to a PRIMARY KEY in another table.There are many constriants which includes foreign key as In a foreign key reference, a link is created between two tables when the column or columns that hold the primary key value for one table are referenced by the column or columns in another table. This column becomes a foreign key in the second table.

7.

There has a rule that if we want to match i mean to relate a table then we need two keys like primary key and forein key as referal integrity defines that these both keys should have a similar value.Referential integrity is a relational database concept in which multiple tables share a relationship based on the data stored in the tables, and that relationship must remain consistent.

8.

Three possible interpretations are:
1. Value not appropriate
2. Value known to be blank
3. Value appropriate and unknown

9.

The purpose of the normalization process is to prevent update problems in the tables (relations) in the database. The nature of the normalization process is that we break up relations as necessary to ensure that every determinant is a candidate key.Normalization is the process of efficiently organizing data in a database. There are two goals of the normalization process: eliminating redundant data (for example, storing the same data in more than one table) and ensuring data dependencies make sense (only storing related data in a table). Both of these are worthy goals as they reduce the amount of space a database consumes and ensure that data is logically stored.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.