Question

tableA is a table in a relational database with a non-composite prime key. You have just...

tableA is a table in a relational database with a non-composite prime key. You have just ensured that each cell in tableA contains only one value. What is the highest normal form of tableA of which you may be certain? Explain your answer

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

SOLUTION:- The highest normal form of tableA is 2NF.

EXPLANATION:- tableA has a non-composite prime key and each cell (i.e., intersection of a row and a column) in tableA contains only one value. The rules of 1NF states that each table cell should contain a single value and each record needs to be unique. Here, tableA satsfies this rule so it is in 1NF. But, now we will consider another important aspect of tableA that tableA has a non-composite prime key i.e., a single column primary key. The rules of 2NF states that table has to be in 1st NF and also having single column primary key. Here, tableA is already in 1NF and contains non-composite prime key i.e., a single column primary key so tableA is in 2NF.

Therefore, we can say that the highest normal form of tableA is 2NF.

========================================================================

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
An IT support organization within a large company wants to develop a relational database to keep...
An IT support organization within a large company wants to develop a relational database to keep track of its work. We will call users of the organization’s service CLIENTs. CLIENTs, as needed, submit requests for help called TICKETs. Each TICKET, in turn, can have multiple PROBLEM_ITEMs. There are many SUPPORT_SPECIALISTs in the organization. Eventually each PROBLEM_ITEM is assigned to a unique SUPPORT_SPECIALIST. Each SUPPORT_SPECIALIST can have multiple PROBLEM_ITEMs assigned to him or her. Since PROBLEM_ITEMs may not be assigned to...
The following table stores details on employees and the projects they have worked on and the...
The following table stores details on employees and the projects they have worked on and the hours they spent on the project each week: WORKLOAD EmpID EmpName ProjID ProjName HoursPerWeek E01 Smith P02 Database 10 E02 Smith P01 Web Portal 5 E03 Robinson P02 Database 20 Question: Explain why the above table is not in 2nd normal form. Then normalise it to 2nd normal form. Once the table is in 2nd normal form, test if the result is in 3rd...
Suppose we have the following relation R with composite primary key {A,B} together with the set...
Suppose we have the following relation R with composite primary key {A,B} together with the set FD of functional dependencies: R(A,B,C,D,E,F,G). FD = { C -> G, E -> B, A -> D, AB -> C, AB -> D, AB -> E. AB -> F, AB -> G } Draw the initial dependency diagram using the above information. The relation from part a) is in first normal form. Using the techniques described in the lecture, convert it to 2NF by...
You have learned some database components such as entities (tables) with attributes (columns/fields) and keys in...
You have learned some database components such as entities (tables) with attributes (columns/fields) and keys in previous lessons such as Relational Databases, Database Fields and Field Specifications, and Establishing Keys. Now based on the examples in those lessons, you will design a database for CTU, which includes three entities (tables): Students, Faculty, and Classes. Note a class refers to a particular class section. For example, the current CS253 you are taking is one class instance (i.e. CS253-01), and another CS253...
You are a database consultant with Ace Software, Inc., and have been assigned to develop a...
You are a database consultant with Ace Software, Inc., and have been assigned to develop a database for the Mom and Pop Johnson video store in town. Mom and Pop have been keeping their records of videos and DVDs purchased from distributors and rented to customers in stacks of invoices and piles of rental forms for years. They have finally decided to automate their record keeping with a relational database. You sit down with Mom and Pop to discuss their...
1. Is it important to encrypt your database? Does the Academic Database have sensitive data that...
1. Is it important to encrypt your database? Does the Academic Database have sensitive data that needs to be encrypted? Why or why not? Address these questions in the space below; your answer should be addressed in 100 to 150 words. 2. Which of the case studies that you read (Walmart, Target or 5 Big Data Industries) caught your attention and why? Before reading the articles, did you think about data being used in the manner that it is? Name...
Create a relational model and ER diagram based on the following info. Emerald Realty Group, Inc....
Create a relational model and ER diagram based on the following info. Emerald Realty Group, Inc. is a local real estate company that is specialized in leasing office space to businesses. The company does not own all the properties it leases. The company has its own suppliers and customers. We refer to the person or the company that owns the office space as a supplier. A customer is the person or the company that rents the office space. Emerald Realty...
You are hired to design a database for a fitness center. As the fitness center is...
You are hired to design a database for a fitness center. As the fitness center is expanding with more than one branch, they want to create a database to keep track of its customers, facilities and employees. Each branch has a unique id and address (building number, street, district, and city). A branch may have more than one facility (e.g. swimming pool, spa, etc.). Each facility must belong to only one branch, and the information for a facility is name...
If you had to create a new table in your database called EMPLOYEE and load data...
If you had to create a new table in your database called EMPLOYEE and load data into it using SQL commands below. CREATE TABLE EMPLOYEE (               EMP_ID INT PRIMARY KEY,               EMP_FNAME VARCHAR(200) NOT NULL,               EMP_LNAME VARCHAR(200) NOT NULL,               EMP_CITY VARCHAR(500) NULL ,               EMP_STATE VARCHAR(20) NULL ) INSERT INTO EMPLOYEE VALUE (1, ‘Kevin’, ‘Lailnay’, NULL, ‘PA’) INSERT INTO EMPLOYEE VALUE (2, ‘Sarita, ‘Kawn, ‘Princeton’,’NJ’) INSERT INTO EMPLOYEE VALUE (2, ‘Gloria, ‘Pitts, ‘Allentown, ‘PA’) INSERT INTO EMPLOYEE...
1. Which of the following is NOT a type of data anomaly? a. Insertion b. Transformation...
1. Which of the following is NOT a type of data anomaly? a. Insertion b. Transformation c. Deletion d. Modification 2. Functional dependency has the following characteristics EXCEPT a. Attribute Y is functionally dependent upon attribute X, if the value of X uniquely determines the value of Y b. It's a constraint between two tables c. It's a constraint between two attributes (columns) d. Represented as Determinant(s) -> Dependent(s) 3. The definition of a partial dependency is a.One or more...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT