Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

17. The one-to-many (1:M) relationship is easily implemented in the relational model by putting the of the 1 side in the table of the many

image text in transcribed

17. The one-to-many (1:M) relationship is easily implemented in the relational model by putting the of the "1" side in the table of the "many" side as a a. primary key, primary key b. primary key, foreign key c. foreign key, primary key d. foreign key, foreign key 18. A(n) table is the implementation of a composite entity used to implement an M:N relationship. a. linking b. bridge c. associative d. association 19. A(n) is an orderly arrangement used to logically access rows in a table. a. primary rule b. superkey c. relationship d. index 20. Relation schema R={A1,A2,.,An} is a set of attributes S subset-of R with the property that no two tuples t1 and t2 in any legal relation state r of R will have t1[S]=t2[S] a. Normal form b. Super key c. Candidate key. d. Foreign key 21. In a university, the data of students such as student id, name, and address are recorded in the STUDENT table and the courses are stored in a COURSE table by the course code, number of credits, and professor teaching. Usually, a student takes up to 5 courses per cycle, and each course has a minimum of 2 students. What kind of relationship exists between the courses and students? a. 1:1 b. 1:M c. Functional dependence. d. M:N 22. A database stores the data of the sales using the primary key RECEIVE_NUM in the SALE table and the products in the PRODUCT table with primary key PROD_NUM. To create the relation that represents what products were sold in a SALE a M:N relationship is necessary. What should be used to represent this in a relational model? a. composite attribute with RECEIVE_NUM + PROD_NUM b. composite entity with RECEIVE_NUM + PROD_NUM c. a product table SALE x PRODUCT d. a join table SALE + PRODUCT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Microsoft SQL Server 2014 Administration

Authors: Adam Jorgensen, Bradley Ball

1st Edition

111885926X, 9781118859261

More Books

Students also viewed these Databases questions

Question

Know the three main dimensions of the service environment.

Answered: 1 week ago

Question

Understand the roles of signs, symbols, and artifacts.

Answered: 1 week ago