Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1 (1 point) After making table A in the first normal form , how many entities will be there (including associative entities, if any

image text in transcribed

Question 1 (1 point)

After making table A in the first normal form , how many entities will be there (including associative entities, if any exists)?

Question 1 options:

2

3

1

None of the above

Question 2 (1 point)

After making table A in the first normal form , how many "one to many" relationships will be there?

Question 2 options:

0

2

3

1

Question 3 (1 point)

After making table B in first normal form, how many entities will be there (including associative entities, if any exists)?

Question 3 options:

2

3

4

None of the above

Question 4 (1 point)

After making table A in first normal form, how many "many to many" relationships will be there?

Question 4 options:

1

0

2

None of the above

Question 5 (1 point)

After making table B in first normal form, what is the number of records in the entity that has the highest number of records?

Question 5 options:

5

4

3

None of the above

Question 6 (1 point)

After making table B in the first normal for, how many primary keys will be there?

Question 6 options:

0

1

2

3

Question 7 (1 point)

After making table A in first normal form, what is the number of records in the entity that has highest number of records?

Question 7 options:

2

4

3

None of the above

Question 8 (1 point)

After making table B in first normal form, how many "many to many" relationships will be there?

Question 8 options:

0

2

1

None of the above

Question 9 (1 point)

After making table A in first normal form, how many foreign keys will be there?

Question 9 options:

1

2

0

None of the above

Question 10 (1 point)

After making table B in first normal form, how many foreign keys will be there?

Question 10 options:

2

1

3

None of the above

Note: The student can take more than one course and the course can have many students R) Note: The department can have many employees but the employee should be assigned to one department only Note: The student can take more than one course and the course can have many students R) Note: The department can have many employees but the employee should be assigned to one department only

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

Step: 3

blur-text-image

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

Provider Audit In England Evaluating Medical Audit

Authors: James Buttery, Yvette; Walshe, Kieran; Rumsey, Moira; Amess, Moyra; Bennett, Jennifer & Coles

1st Edition

1898845034, 978-1898845034

More Books

Students also viewed these Accounting questions