Question: When part of the data in a table depends on a field in the table that isnt the tables primary key, its known as: a.

When part of the data in a table depends on a field in the table that isn’t the table’s primary key, it’s known as:

a. Transitive dependency

b. Partial dependency

c. Psychological dependency

d. A foreign key

Step by Step Solution

★★★★★

3.49 Rating (175 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a Tra... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c1211fb3a_715961.pdf

180 KBs PDF File

Word file Icon

1803_60b8c1211fb3a_715961.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!

Q:

Use the following description of the operations of the RC_Charter2 Company to complete this exercise. ¢ The RC_Charter2 Company operates a fleet of aircraft under the Federal Air Regulations...

Q:

1. The DBA asks for your help in planning the data archive for the following Alexamara database: Marina (MarinaNum, MarinaName, Address, City, State, Zip) Owner (OwnerNum, LastName, FirstName,...

Q:

1. The DBA asks for your help in planning the data archive for the following Henry Books database: Branch (BranchNum, BranchName, BranchLocation) Publisher (PublisherCode, PublisherName, City) Author...

Q:

Consider the following data table: The above data table has: a. a composite primary key b. a transitive dependency c. a repeating group d. a partial dependency e. a DESCRIPTION field insert anomaly

Q:

Question 44 2 pts What is the normalization level of this table: (EmpNo, EmpDegree, yearEarned). Assume EmpNo is set as the primary key. Repeating data (UN) It not a, then partial dependency (INF) If...

Q:

You were just hired by an airline industry to create a database to record the various airlines and the pilots that work for them Discussions with the industry representatives focused on two initial...

Q:

You were just hired by an airline industry to create a database to record the various airlines and the pilots that work for them Discussions with the industry representatives focused on two initial...

Q:

3. Only a single attribute, not multiple attributes, can define functional dependence. a. True b. False 4. Each row in the relational table is known as an entity instance or entity occurrence in the...

Q:

TABLE NAME: INVOICE 2NF INVOICE_NUM CUST_ID CUST CNAME CUST_STREET CUST_CITY CUST_STATE CUST_ZIP INVOICE_DATE TAX_RATE Transitive Dependency Transitive Dependency TABLE NAME: INVOICE_PART_LINE 1NF...

Q:

Designing a database and populating data Multiple sclerosis, also known as MS, is a chronic inflammatory disease that attacks the central nervous system (the brain, spinal cord and optic nerves), and...

Q:

Amy says that it is her birthday and that Endeavor in December 2001. Six times her age five years ago is twice as much as twice her age next year. How old is Amy?

Q:

Every November, Smith and Jones each face the choice between burning their leaves or stuffing them into garbage bags. Burning the leaves is much easier but produces noxious smoke. The utility values...

Q:

When estimating repayment of a loan, which of the following should be considered as primary sources: new equity from investors new debt from additional creditors collateral from the asset acquired...

Q:

A computer model of the project estimate will be developed to facilitate the changing of inputs, such as labor rates or the number of labor hours for various activities

Q:

Describe the steps that transform a program written in a high-level language such as C into a representation that is directly executed by a computer processor.

Q:

Th e eight great ideas in computer architecture are similar to ideas from other fields. Match the eight ideas from computer architecture, Design for Moores Law, Use Abstraction to Simplify Design,...

Q:

Another pitfall cited in Section 1.10 is expecting to improve the overall performance of a computer by improving only one aspect of the computer. Consider a computer running a program that requires...

Q:

anwser At the bottom of all its February sales receipts, Selfert Stores Inc. printed \$2-off coupons. The coupons may be redeemed March 1-April 30. Seifert Stores Inc. accepts only cash, MasterCard,...

Q:

Sales revenue $30,000,000 General and administrative expenses 5,400,000 Deferred revenue 50,000 Interest expense 18,000 Selling expenses 800,000 Interest revenue 16,000 Cost of goods sold 9,000,000...

Q:

The following book and fair values were available for Westmont Company as of March 1 494,000 449, 500 763, 500 1,060, s00 Land Buildings Customer relationships Accounts payable Common stock...