Information Processes and Technology

Home > Information Processes and Technology > Information Systems and Databases > Data Dictionary and Schematic Diagrams

Data modelling: Data dictionary and schematic diagrams

This activity addresses aspects of the following syllabus outcome:

Outcome

A student:

H7.2 uses methods to thoroughly document the development of individual and team projects.

Extract from the Stage 6 Information Processes and Technology Syllabus © Board of Studies 2007.

Introduction

A banking business is presented to provide a context for the documentation of a simple relational database. The bank has many customers who open and maintain one or more accounts. For each customer, the bank keeps a record of their name and address. The customer ID is a unique identifier or primary key.

All accounts are assigned a unique account number. The account can either be checking (cheque) or savings. A savings account can earn interest but the only transactions allowed are deposits and withdrawals.

Go to the Zicklin School of Business web site and answer the following questions:

Questions:

1. Define the term data dictionary and identify the main components.
2. From the Access tables provided develop a data dictionary for both the Customer and Accounts tables.
Answer
Create a schematic diagram for the banking case study. It should include the Customer and Accounts tables.
Answer
Identify the foreign key in the Accounts Table. Justify your choice.
Answer