SAD Tutorial 2

Tutorial 2

by TechMan

Multiple Choice

1. In STUDENT shown below, Marital_status is an example of a(n) ________.

• [A] attribute

• [B] entity

• [C] primary key

• [D] relationship

• [E] instance of an entity

Multiple Choice

2. In CUSTOMER shown below, identify the primary key.

• [A] Name

• [B] Address

• [C] Work_phone_number

• [D] Cell_phone_number

• [E] A suitable key is not present; will have to add our own key

Multiple Choice

4. Identify the primary key of CUSTOMER_ACCOUNT, which records information about the monthly amount a customer owes at a clothing store.

• [A] Account_no

• [B] Account_open_date

• [C] Amount_owing

• [D] Total_loyalty_points

• [E] A suitable key is not present; we will have to add our own key

Multiple Choice

3. In STUDENT shown below, identify the primary key.

• [A] Name

• [B] Surname

• [C] Student_number

• [D] Contact_phone_number

• [E] A suitable key is not present; will have to add our own key

Multiple Choice

5. The most appropriate symbol to replace circle 1 is ________.

Multiple Choice

6. The most appropriate symbol to replace circle 2 is ________.

Multiple Choice

7. If students started using each other’s SIM cards, how would circle 2 change?

Multiple Choice

8. It is optional for ________.

• [A] the manager to manage a team

• [B] the team to be made up of players

• [C] players to make up a team

• [D] a player to be supported by a fan

• [E] a fan to support a player

Multiple Choice

9. It is mandatory for ________

• [A] a fan to support a player

• [B] a player to be supported by a fan

• [C] a team to be managed by a manager

• [D] players to make up a team

• [E] [A] and [D]

Multiple Choice

10.The diagram below shows that ________.

i) a module can be lectured by more than one lecturer

ii) a lecturer can lecture no more than one module

iii) a student must take a minimum of one module

iv) all modules are taken by at least one student

• [A] i) and ii)

• [B] ii) and iii)

• [C] iii) and iv)

• [D] i) and iii)

• [E] ii) and iv)

Multiple Choice

11.At UKZN, the modules ISTN100 (End User Computing), ISTN101 (IS&T for Business), and ISTN103 (Development and Applications Fundamentals) are all examples of ________.

• [A] primary keys

• [B] entities

• [C] instances of an attribute

• [D] instances of an entity

• [E] attributes

​12.At our university, students register for degrees. A student may register for one or more degrees over time. However, the university offers the degree, even if no students register for it. The university keeps records of the degree’s name, the degree’s abbreviation, the total number of credits required, and the minimum and maximum completion time. The university also keeps records of each student’s number, name, surname, address and cell phone number.

​

Draw an Entity-Relationship diagram of this situation, showing the entities, attributes, relationship(s), cardinalities and primary keys. Denote your primary key with a double asterisk **.

​12.

​

​13.At our university, a lecturer may be assigned a laptop but some lecturers are not assigned a laptop (e.g. if they already have a desktop computer). A laptop is assigned to one and only one lecturer. When a lecturer is assigned a laptop, his/her name, surname, staff number, building name and office number is recorded. The laptop brand, serial number and date allocated is also stored.

Draw an Entity-Relationship diagram of this situation, showing the entities, attributes, relationship(s), cardinalities and primary keys. Denote your primary key with a double asterisk **.

​13.

​

​14.At a university, a School offers many courses. A School will offer at least one course. A specific course is offered by only one School. Each School has a name, a Head of School and a Deputy Head of School. A course has a name, a code, a course level (1st year, 2nd year, 3rd year, …), and a number of credit points. Each course is offered on one or more campus. A campus offers many courses. The university system records the campus name and the town it is in.

Draw an Entity-Relationship diagram of this situation, showing the entities, attributes, relationship(s), cardinalities and primary keys. Denote your primary key with a double asterisk **.

​14

​

​18. The following screenshot came from the SterKinekor website (http://www.sterkinekor.com/#/info/3947/The Best Exotic Marigold Hotel/ accessed on 2 Aug 2012). The SterKinekor website gives information about movies that are showing. One can also book to see a movie from this website.

​

a) Identify the entity/ies and attributes which the cinema chain will use to store the data represented on this screenshot. What are the primary keys? Add the relationship(s) to the diagram.

​18a.

​b) Using ERD terminology, explain what Boardwalk, Gateway Nouveau, Gateway, Musgrave and Shelly Beach are examples of in the screenshot below.

​Boardwalk, Gateway Nouveau, Gateway, Musgrave and Shelly Beach are examples of instances of the entity CINEMA.

​

​