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!

Records displayed using a query can change if the raw data in the original table changes. These records are known as?

View this question

You can use a query as a source of data for other queries.

0%
100%
View this question

What will the format look like when the input given is 987654.321 and the output value is R987,654.32

0%
0%
0%
View this question

Which of the following is NOT a part of Text and Memo Data-type format symbols.

View this question

Sometimes you need entire tables to perform data validation and enable users to pick values from a dropdown list instead of typing the values. What is the easiest option to achieve that?

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 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

Match the concepts in the drop-down with the correct description.

View this question

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

The physical schema of a databases describes how the data are actually stored including the files and indexes used.

100%
0%
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