Database and Design Assignment

HS2021 Database Design and Use

Week 3 - 2020 Tutorial

Date:

Instructions:

This exam has three (3) questions.

You are expected to select one question out of three (3) questions and to submit your answer via the blackboard assessment system.

Assessment Weight:

This test accounts for five per cent (5%) of total marks.

Total marks for the paper 5 marks

Question A: Create the DDL statement to create tables described in the following Entity-Relationship Diagram

Question B: Create the DDL statement to create tables described in the following Entity-Relationship Diagram

Question C: Create the Entity-Relationship Diagram and the Relational Schema for the following scenario

Student Name: _____________________________________________________

Student ID: ____________________________

Employee

Role

Role ID

Security Level

Salary Level

Employee ID

First Name

Last Name

Package

Delivery ID

Delivery Date

Package ID

Sender

Delivery

Receiver

Student

Lecturer

Lecturer ID

Name

Student ID

Name

Email

Phone Ext