Font size
WorksheetsDatabase Quizz
Total questions: 10
Worksheet time: 8mins
The following are the list of lecturers that teach Database Design and Modelling in this semester, except..
Prati Hutari Gani
Anisa Herdiani
Kemas Muslim Lhaksamana
Monterico Adrian
you can put your data in a (a) . For managing the data, one can use ...
Please write your suggestion for me in teaching this course.
See the picture above. In relational schema, which table will have Foreign Key?
Order and Customer
Order
Customer
none
See the picture above. How many tables that we should make in the relational schema?
3 (Completes, Employee, and Course)
3 (Employee, DateCompleted, and Course)
2 (Employee, and Course)
3 (Employee ID, Completes, and Course)
See the picture above. Which tables that will not have foreign keys?
Shipment
Customer and Shipment
Vendor and Shipment
Customer and Vendor
From the picture above, which attributes will be foreign keys? and where we should put these foreign keys?
FK: (Customer ID, Vendor ID), table contains FK: Shipment
FK: (Customer ID, Vendor ID), table contains FK: (Customer, Vendor)
FK: (shipment ID, Vendor ID), table contains FK: Shipment
FK: (Customer ID, Vendor ID), table contains FK: Customer
.. is data that describe the properties of end user data
Information
Knowledge
Raw data
Metadata
The following are the advantages of using DBMS, except...
Program-Data independence
Improved Data consistency
Increasing Data Redundancy
Enforcement of Standards
Which people from the list underneath that should read E-R Diagram?
Database Developer
End User
Project Manager
All people above should read
