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

Ask an Expert

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

Write your message here..

Related Questions

What is storage manager, What is storage manager? A storage manager is ... What is storage manager? A storage manager is a program module that gives the interface among the low level data keeps in a database and the application programs and queries su

Define shadow paging, Define shadow paging. An alternative to log-based... Define shadow paging. An alternative to log-based crash recovery method is shadow paging. This technique requires fewer disk accesses than do the log-based methods.

Create table statements for original database, MySQL statements for extendi... MySQL statements for extending the database to incorporate new facilities Deliverables for submission You must submit the following deliverables in the Assignment Dropbox in

I need automated trading engine for crypto currencies, Project Description:... Project Description: Looking to prepare automated trading engine for alternate cyprto currencies starting with Cryptsy, finally integrating into other exchanges. Need to work wi

Need for multiple access paths, Need for Multiple Access Paths In pract... Need for Multiple Access Paths In practice, most of the online information systems need the support of multi-key files. For example, consider a banking database application hav

How the one-to-one associations have to be implemented, Discuss how the one... Discuss how the one-to-one associations have to be implemented. Some of properties of associations can be implemented directly by providing suitable declarations of the data me

Update operations in dbms - insert operation, Update Operations and Dealing... Update Operations and Dealing with Constraint Violations There are three basic operations to be executes on relations: Insertion Deletion Update The INSER

What is the use of with clause in sql, What is the use of with clause in SQ... What is the use of with clause in SQL? The with clause gives a way of defining a temporary view whose explanation is available only to the query in which the with clause occurs

Difference among a primary index and a secondary index, What is the differe... What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.

Normalization, in case of functional dependencies how we get the higher nor... in case of functional dependencies how we get the higher normal form.