Match the database form to its meaning, as it relates to normalization 1. First normal form...
Match the database form to its meaning, as it relates to normalization
1. First normal form
2. Second normal form
3. Third normal form
A. a relation is in first normal form and non-key attributes are functionally dependent on the primary key
B. there is a key to uniquely identify each row in the relation and there are no repeating groups
C. a relation is in first normal form and second normal form, and non-key attributes are functionally dependent on the primary key, the whole primary key and no other attribute but the primary key
Homework Answers
1-B
2-A
3-C
First normal form-there is a key to uniquely identify each row in the relation and there are no repeating groups
Second normal form-a relation is in first normal form and non-key attributes are functionally dependent on the primary key
Third normal form-a relation is in first normal form and second normal form, and non-key attributes are functionally dependent on the primary key, the whole primary key and no other attribute but the primary key
Add Answer to:
Match the database form to its meaning, as it relates to
normalization
1. First normal form...
The employee is table, the best candidate for primary key is Select one: a. Department ID...
The employee is table, the best candidate for primary key is Select one: a. Department ID b. Employee hiredate c. Employee ID d. Employee salary Question 2 A primary key can be composed of more than one attribute. Select one: True False Question 3 A foreign key allows you to join two tables. Select one: True False Question 4 Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key? Select...
Assignment 7 Activities: Using the order form below identify entities to be used in a relational...
Assignment 7
Activities:
Using the order form below identify entities to be used
in a relational database. Normalize to first, second, and third
normal form. Clearly identify within each form with the tables in
each form and specify any assumptions made.
Utilize the following format for each table:
TableName(attribute,etc)
Indicate Primary Key by underlining the attribute name. List
Foreign Keys as such FK=attribute, below the table
listing.
Example:
Sales Rep (EmployeeID, MTD Sales, YTD Sales, MTD
Commission, YTD Commission,...
To be in the third normal form, Hint: In order to in 3NF you must first...
To be in the third normal form,
Hint: In order to in 3NF you must first have attained 1NF and
2NF so all of the above is the correct answer. In the database
design world the saying is that to be completely normalized the
data be represented "by the key, the whole key, and nothing but the
key so help me Codd". Ted Codd was the person behind the
development of the relational theory back in the 1960s and 70s....
Identify, in the list below, a row in the result. Dragons B) Giants C) Lions D)...
Identify, in the list below, a row in the result. Dragons B) Giants C) Lions D) Ham Fighters 26. If all function dependencies in a table are "very good" or "bad", the table is in A) 1NF B) 2NF C) 3NF D) BCNF 27·Determine the normal form for the relation R(ABCD) and FD's: AD ? C; D A) 1NF B) 2NF C) BCNF D) 3NF -28. Which of the following is not a candidate key for R(ABCD) FD's: BD ?...
This is questions of Accounting Information Systems 1) Fo a database. Each row in this spreadsheet...
This is questions of Accounting Information Systems
1) Fo a database. Each row in this spreadsheet represents a: ur Tet Industries tracks customer information using various Microsoft Excel spreadsheets stored in a. Field b. Record c. File d. Database 2) A d tables is a. What is the correct term for the database field in Table 1? latabase field in Table 1 that serves as a unique identifier in Table 2 and is used to link both of the a....
QUESTION 2 Copy of 1-3 Vocab Match the vocabulary word for each definition below A relational...
QUESTION 2 Copy of 1-3 Vocab Match the vocabulary word for each definition below A relational database chart that is used to map the infor-mation from the entity relationship diagram A. Nulls the unique identifier for each row of data B. Unique Links data in one table to the data in a second table by re-ferring to the PK column in the second table C. Table instance chart Indicates if a column must contain a value D. Foreign key (FK)...
QUESTION 1 The following tables form part of a database held in a relational DBMS for storing the information of Customer, Item, Transaction, and temSale A transaction can contain multiple ite...
QUESTION 1 The following tables form part of a database held in a relational DBMS for storing the information of Customer, Item, Transaction, and temSale A transaction can contain multiple items and an item can be in multiple transactions as depicted in the following sample data Item(itemid, name, category, price Itemid pk) name category price Iteml Pencil Stationery $30 paperStationery Item2 $25 $15 Item3 Cards Stationery S40 Item4 Ink Stationery S13 Item5 Sprite Itemo Food S4 Milk Food Transaction ctransid,...
DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed Apr...
DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed April 8 Introduction to Coursework You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database...
Please help me answer the following questions regarding data relationship tables. Employee ID First Name Last...
Please help me answer the following questions regarding data relationship tables. Employee ID First Name Last Name email Title Address Extension Department Department ID Hiring Date Department Phone # 0001 John Smith jsmith Accountant 1300 West st 5775 Accounting 2100 8/1998 407-366-5700 0002 Brian Miller badams Admin Assistant 1552 Palm dr 5367 Human resource 2300 4/1995 407-366-5300 0003 James Miller miller Inventory Manager 2713 Buck rd 5432 Production 2520 8/1998 407-366-5400 0004 John Jackson jackson_sam Sales Person 433 tree dr...
Please do not delete the questions. 1. What is the purpose of a database? 2. What...
Please do not delete the questions. 1. What is the purpose of a database? 2. What is the reason to use a database over a spreadsheet? 3. Based on the previous answers (#1 & #2), there is a simple rule of thumb. A spread sheet is used when there is _________________________. A database is used when there are _________________________. 4. Please answer followings. a) A group of 8 bits is called a ____________ (from Chapter 4). b) The answers of...
Assignment 7
Activities:
Using the order form below identify entities to be used
in a relational database. Normalize to first, second, and third
normal form. Clearly identify within each form with the tables in
each form and specify any assumptions made.
Utilize the following format for each table:
TableName(attribute,etc)
Indicate Primary Key by underlining the attribute name. List
Foreign Keys as such FK=attribute, below the table
listing.
Example:
Sales Rep (EmployeeID, MTD Sales, YTD Sales, MTD
Commission, YTD Commission,...
Identify, in the list below, a row in the result. Dragons B) Giants C) Lions D) Ham Fighters 26. If all function dependencies in a table are "very good" or "bad", the table is in A) 1NF B) 2NF C) 3NF D) BCNF 27·Determine the normal form for the relation R(ABCD) and FD's: AD ? C; D A) 1NF B) 2NF C) BCNF D) 3NF -28. Which of the following is not a candidate key for R(ABCD) FD's: BD ?...
This is questions of Accounting Information Systems
1) Fo a database. Each row in this spreadsheet represents a: ur Tet Industries tracks customer information using various Microsoft Excel spreadsheets stored in a. Field b. Record c. File d. Database 2) A d tables is a. What is the correct term for the database field in Table 1? latabase field in Table 1 that serves as a unique identifier in Table 2 and is used to link both of the a....
QUESTION 2 Copy of 1-3 Vocab Match the vocabulary word for each definition below A relational database chart that is used to map the infor-mation from the entity relationship diagram A. Nulls the unique identifier for each row of data B. Unique Links data in one table to the data in a second table by re-ferring to the PK column in the second table C. Table instance chart Indicates if a column must contain a value D. Foreign key (FK)...
QUESTION 1 The following tables form part of a database held in a relational DBMS for storing the information of Customer, Item, Transaction, and temSale A transaction can contain multiple items and an item can be in multiple transactions as depicted in the following sample data Item(itemid, name, category, price Itemid pk) name category price Iteml Pencil Stationery $30 paperStationery Item2 $25 $15 Item3 Cards Stationery S40 Item4 Ink Stationery S13 Item5 Sprite Itemo Food S4 Milk Food Transaction ctransid,...
DATABASE SYSTEMS Project INDIVIDUAL WORK DELIVERABLE #: SUBMISSION DATE No Group Work Allowed April 8 Introduction to Coursework You have been approached by a University for the design and implementation of a relational database system that will provide information on the courses it offers, the academic departments that run the courses, the academic staff and the enrolled students. The system will be used mainly by the students and the academic staff. The requirement collection and analysis phase of the database...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago