Construct substantial data model, Database Management System

PART MARKING:  We will only mark TWO of the four questions below but you must submit answers to all four. We will choose the questions we mark randomly and we will supply you with model answers to all the questions.

Construct data models for the following specifications. Include an ERD and a list of relations (entity list). Your relations must show all attributes, primary keys and foreign keys. You must use the USQ (Finkelstein) methodology as described in your Study Book, the lectures and the tutorials.

Question 1

An ambulance driver may be assigned to many teams over time. A team comprises of a minimum of one driver but could have up to twelve.  For driver, we store the name, address and birth date. For team, we store the team id and the location. We also need to store the date a driver is assigned to a team, the date a driver leaves the team and the rating of the driver within the team.

Question 2

A course may have many prerequisite courses. A prerequisite must relate to only one course. A prerequisite is also a course. For course, we store the course number and course name.

Question 3

A course may have many prerequisite courses. A prerequisite may relate to many courses. A prerequisite is also a course. For course, we store the course number and course name. We would also like to store the level of the prerequisite for a particular course.

Question 4

A mattress must be assigned to a specific category but a category may apply to many mattresses. A mattress may be combined with many beds and a bed with many mattresses. A bed is made by one manufacturer but a manufacturer may make many beds. For mattress, we store the id number and brand name, while we store a category number and name for category. For bed, we store the brand name (unique), size, length and width. Each time a specific mattress is allocated to a bed, we need to store the comfort rating and the rating date.

Posted Date: 2/28/2013 2:26:33 AM | Location : United States







Related Discussions:- Construct substantial data model, Assignment Help, Ask Question on Construct substantial data model, Get Answer, Expert's Help, Construct substantial data model Discussions

Write discussion on Construct substantial data model
Your posts are moderated
Related Questions
Explain the ACID properties of a transaction Ans: ACID properties are a significant concept for databases. The ACID stands for Atomicity, Consistency, Isolation, and Durability

Product adder required for Ecommerce website Project Description: Want a product adder for 500 products I have a magento website and need products pulled from site A to my si

Differance between DDL and SDL? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and

Atomicity: It describes a transaction to be a one unit of processing. We can also say either a transaction will be finished completely or not at all. In the transaction example 1

Problem 1. Write an assembly program to find the smallest among two numbers Writing an assembly program to find the smallest among two numbers 2. Explain the intern

Authorisation Authorisation is the culmination of the administrative policies of the organisation.  As the name shows, authorisation is a set of rules that can be used to verif

The aims of the project are: 1. To enable the students to undertake the detailed design of a specific plant or process 2. The design projects includes: process selection; und

Project Description: Critical Project for VMware Technical support. VMWare ESXi 5.1 support for upgradation and migration problem. Technical expert of Vmware needed. Sk

Use again the GE Flight Quest Data and build on the work done for homework 1 and 2. The goal is to create a classification model which classifies flights into "on-time" (you can de

What is Nested Trigger? A trigger can also having INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause ano