IS DEFINITELY 263: Database Concepts

Module 2: Introduction to Data Building

IS

263

DATA

BASE

CONCEPTS:

Tutorial

1 GUIDE

ONE

Intro

to

Data

Modeling

By Joel S.

Mtebe

Problem 1

Generate narrative claims for the following:

is linked

Customer

Consumer

can place

teach

Educators

Property

Buy

Students

Query 2

Draw the ERD for this scenarios:

A player plays for a team.

Each patient offers one or more patient histories; each instance of patient record belongs to a single patient.

A worker may be documented as having many jobs; a particular job can be recorded because having been held by many staff.

A person is citizenship of a nation.

A customer may well place various orders; an order is specific to 1 customer. Query 3

Demonstrate how it will be easy to break down the following romance so that it could possibly be implemented on a relational data source.

CUSTOMER

CATALOGS

Question 4

Draw a great ERD to get a small university database composed of the organization types: DIVISION, COURSE, SCHOLAR and LECTURER.

Each division has many lecturers, one of to whom is the mind of division. A lecturer belongs to merely one department. Every single department provides many different courses, and many academics can teach about the same course. Academics can also teach on more than one course. A student may sign-up for many programs offered by diverse departments.

Question 5

A local education authority (LEA) needs a system to hold details of the applicants who have apply for programs run by local educational institutions. Each program is manage at only one particular college, nevertheless more than one course is manage at each college or university. An applicant may well apply for several courses. Details are to be retained of the regular qualifications that the majority of applicants have, such as GCSEs. Draw an ERD is this system. Question 6

A school has a scholar enrolment system. Each student is enrolled on one study course. The...