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
#question. Draw a picture of a moving source and the waves surrounding it according to what you observed in this experiment. How does the spacing of the wave-fronts in front of the

At its most essential level the DBMS architecture can be divide into two parts: the back end and the front end. The back end is responsible for managing the physical database an

As with other software, databases can potentially be used for unethical purposes. As a database developer, and a consumer, you should recognize database misuse, and how it may affe

Define the following constraints for the table client. (i) BAL_DUE must be at least 1000. (ii) NAME is a unique key. (i)ALTER TABLE CLIENT ADD CONSTRAINT CLIENT_BAL_DUE_C1

What is inheritance? Inheritance is an object orientation concept that allows reusability of code / design. Basic sense of inheritance is that if one class is predefined than a

Write the syntax of creating an INDEX ? Syntax of Creating an Index: CREATE [BITMAP] [UNIQUE] INDEX ON ( [, ] . . .);

Implementing software control To implement software control designer must redesign strategy of state event model which is present in dynamic model. There are three basic ap

explain in details about one to one binary relationship

Explain the term- Query. Queries are used to repossess and show specific records in a table. They can also be used to show specific fields of specific records, which meet the co

First Normal Form and second normal form First Normal Form (1NF) A relation is said to be in 1NF if it having no non-atomic values and each row can give a unique combinat