Part-ii relational database implementation

SMB4102 T216 Assignment-2

Objectives

Your ER model must:

• show all necessary entities, attributes and relationships

• You are required to write brief definitions for the entities and attributes in your model. For each entity and attribute in your model, write a sentence to describe the meaning of that entity or attribute.

What you need to should submit

You should submit a Microsoft Word document containing:

Part-II Relational database implementation

The recommended tool for this assignment is Microsoft Access.

In implementing the ERD provided, you must complete the following tasks:

• Populate the database with sample data. You must include sufficient sample data to test your queries and report(s). You should aim for at least 4-5 rows in every table.

Data integrity

You are required to implement integrity constraints within the database to enforce the following requirements:

• Date paid cannot be in the future.

For invoice statements:

• Statement total must be greater than 0.

• The payment date must be on or later than the statement date.

Information requests

4. Show details of any student who has had or will be having a piano lesson.

What you need to should submit

• A Microsoft Access database

Alignment of Assessment Tasks to Learning Outcomes

Alignment of Attributes to Learning Outcomes