Database Design Quiz: Barker Notation

Which of the following is a valid entity in a Barker ERD for a South African university system?

• Degree Type

• Student

• Email Address

• Graduation Date

Which of the following is a typical attribute of a Vehicle entity for a SA car registration system?

• Vehicle

• Registration Number

• Owner

• Registered

In a Barker ERD for an online store (e.g. Takealot), the relationship between Customer and Order is:

• Placed By

• Places

• Has

• Placed

Which is the best UID (Unique Identifier) for a South African ID Book entity?

• Full Name

• Home Address

• ID Number

• Date of Birth

In a table of Municipal Accounts, which field is best used as a Primary Key (PK)?

• Street Name

• Account Holder

• Meter Reading

• Account Number

In a Barker ERD, the Foreign Key (FK) in Traffic Fine that links it to Vehicle would be:

• Vehicle Description

• Vehicle Make

• Vehicle ID

• Traffic Officer Name

In a Barker ERD for a Capitec banking system, which of the following is a valid relationship?

• Account

• Owns

• Client Name

• ATM Location

In a Shoprite Stock System, which of the following is most likely an entity?

• Product Name

• Category

• Product

• Price

In a Barker ERD, the relationship between Driver and Licence in the South African traffic system is:

• Has

• Owns

• Drives

• Issued

In a Barker ERD, how do you resolve a many-to-many (M:N) relationship between Student and Module?

• Add a foreign key from Student to Module

• Add a foreign key from Module to Student

• Create an intersection (associative) entity such as Enrollment

• Many-to-many relationships do not need to be resolved