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 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...
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...
Oracle Database Analysis and Design This project is to develop and implement an Oracle database. See...
Oracle Database Analysis and Design This project is to develop and implement an Oracle database. See the scenario of the Investment database. This simplified Investment Portfolio case study maintains information regarding clients that invest in stocks and mutual funds. Each client has a unique taxpayer identification number. A client may invest in stocks or mutual funds. A stock is uniquely identified by its ticker, which is symbol on the stock exchange. The name of issue for a stock is the...
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...
The relational schema for the Academics database is as follows: DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode)...
The relational schema for the Academics database is as follows: DEPARTMENT(deptnum, descrip, instname, deptname, state, postcode) ACADEMIC(acnum, deptnum*, famname, givename, initials, title) PAPER(panum, title) AUTHOR(panum*, acnum*) FIELD(fieldnum, id, title) INTEREST(fieldnum*, acnum*, descrip) Some notes on the Academics database: An academic department belongs to one institution (instname) and often has many academics. An academic only works for one department. Research papers (PAPER) are often authored by several academics, and of course an academic often writes several papers (AUTHOR). A research field...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT