Question: 18. In a relational database table, a foreign key column can contain: (a) NULLS or blanks (b) duplicate values (c) both a and b above

18. In a relational database table, a foreign key column can contain: (a) NULLS or blanks (b) duplicate values (c) both a and b above (d) neither a nor b above 19. A small college database contains INSTRUCTOR and CLASS entities/tables. Instructor-ID; PK of CLASS table is Class-Code. To create a relationship between these two tables, what would PK of INSTRUCTOR table is you do? (a) include Instructor-ID column in CLASS table as a foreign key column (b) include Class-Code in INSTRUCTOR table as a foreign key column (c) place a third table between INSTRUCTOR and CLASS tables 20. In ER diagrams, the term "many" means: (a) any number zero or more (c) any number including zero, less than zero, and more than zero (b) any number one or more

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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

Students Have Also Explored These Related Databases Questions!

16. In typical a hospital, a patient is examined by many doctors and a doctor examines many patients. A database for the hospital has a PATIENTS table whose PK column is Patient-ID and it has a...

Assignment 1: Setting up Databases (15%) This assignment relates to the following Cowrse Learning Requirements: CLR 1 - Plan, Prepare, Install, Configure, and Use a market-leading Database Management...

Question 11 Which of the following is a legal character in the Oracle Naming Standard? a. % b. ^ c. # d. * 2 points Question 12 ____ commands are used to add new database objects. a. DML b. DDL c....

Which of the following describes referential integrity? A primary key of a relational table must not contain a null value The value for a foreign key attribute must either be null or match one of the...

When an event participated in a stock-flow relationship, which of the following is true? The other participant in the relationship must be a focal event. The other participant in the relationship...

The resource that is most likely to be found in multiple business processes in all types of organizations is: Employee Cash Cash disbursement Inventory sale Which pair is most likely to be linked...

In relational database design, a primary key of one table that is also included in another table Usually ensure that we can get all the information we need to make a decision by querying only one...

Linear Company engaged in the following transactions: July 2 Purchased merchandise on credit from Green Company, terms 2/10, n/30, FOB destination, invoice dated July 1, $2,000. 6 Returned some...

b) Write a definition of Asphaltic bitumen and make a comparative analysis discussion on the properties of Hot mixed asphalt versus cold mixes asphalt. (CO1-PO3)(C3) (10 marks) c) Roads cross section...

A private sectoc , not - for - profit hospital recelved a pledge of $ 2 5 0 , 0 0 0 in 2 0 r ) to be used for a bullding to be constructed in 2 0 2 0 but contingect on the hospital being able to rabe...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

In Visual Studio 2017 with an open OLAP Cube, what is the connection to an advanced OLAP viewer?

What is the main benefit of the multidimensional framework of OLAP Cubes?

Provide an example of how the sort level Unspecified can be excluded from the Gender Dimension in a Pivot Table worksheet genderwaggap01.