Шукаєте відповіді та рішення тестів для DBD181[Active]? Перегляньте нашу велику колекцію перевірених відповідей для DBD181[Active] в connect.belgiumcampus.ac.za.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
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.