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?
You can use a query as a source of data for other queries.
What will the format look like when the input given is 987654.321 and the output value is R987,654.32
Which of the following is NOT a part of Text and Memo Data-type format symbols.
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?
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.
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.
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.
Match the concepts in the drop-down with the correct description.
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?
The physical schema of a databases describes how the data are actually stored including the files and indexes used.