logo

Crowdly

Browser

Add to Chrome

DBD181[Active]

Looking for DBD181[Active] test answers and solutions? Browse our comprehensive collection of verified answers for DBD181[Active] at connect.belgiumcampus.ac.za.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

You are building a Library database. The Book table has a repeating group for authors because some books have multiple authors. What should you do to ensure this table conforms to 1NF?

0%
0%
0%
0%
0%
View this question

A foreign key must match a value in the primary key of the parent table and may not contain a null.

0%
0%
View this question

A salesperson serves many customers, but each customer is assigned to only one salesperson. A customer can place many orders, but an order can belong to only one customer. An order contains many products. A product may also appear on many orders.

Identify the steps you will take to create an Entity Relationship Diagram (ERD) for the above scenario.  [10]

Note: Even though you are not required to submit the ERD, you may benefit from creating the ERD on paper before before answering this question.

Select all options that apply. 1 mark will be deducted for each incorrect choice.

0%
0%
0%
0%
0%
0%
0%
0%
0%
View this question

Milly Bonka, owner of Milly’s Chocolate Factory, has hired you as a consultant to design a database management system to help keep track of the make-up of items and their sales between her branches. You are given the following incomplete Entity Relationship Diagram (ERD) and the following requirements. 

Image failed to load

  • Items may be sold by one or more branches.
  • An Item can be composed of multiple other items.

Select all the tasks required to finalize the ERD. [9 marks]

Note: Even though you are not required to submit the ERD, you may benefit from creating the ERD on paper before answering this question.

Select all options that apply. Negative marking applies to this question.

0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
View this question

A table in 2NF may still have transitive dependencies.

100%
0%
View this question

Most database problems can be traced back to poor design. Which of the following statements is not correct?

View this question

You have two tables Employee and Department. An employee belongs to a particular department. You delete a department “Public Relations” from the Department table but all the employees who belong to that department still remain in the Employee table. What database rule have you violated?

View this question

Normalization follows certain rules for efficiently organizing data in a database. A table is in Boyce-Codd Normal Form (BCNF) when:

View this question

Want instant access to all verified answers on connect.belgiumcampus.ac.za?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Browser

Add to Chrome