Skip to document
Welcome to StudocuSign in to access the best study resources
Guest user
0followers
HomeMy LibraryAsk AI
  • You don't have any recent items yet.
My Library
  • You don't have any courses yet.
  • You don't have any books yet.
  • You don't have any Studylists yet.

Worksheet Chapter 5 Memo

Worksheets for practise with memos
Course

Introduction to Databases and Databases Management Systems:Part 1 (CSIQ2634)

37 Documents
Students shared 37 documents in this course
Academic year: 2021/2022
Uploaded by:
Anonymous Student
This document has been uploaded by a student, just like you, who decided to remain anonymous.
University of the Free State

Comments

Please sign in or register to post comments.

Students also viewed

Related documents

Preview text

1 | P a g e

UNIVERSITY OF THE FREE STATE

Department of Computer Science

and Informatics

CSIS

Worksheet (Chapter 5)

Question 1

Create an ERD using UML notation that can implement the following application from the manufacturing industry at least the following business rules. Make sure you include all appropriate entities, relationships, connectivities and cardinalities:

 Each supplier has a unique name.  More than one supplier can be located in the same city.  Each part has a unique part number.  Each part has a colour,  A supplier can supply more than one part.  A part can be supplied by more than one supplier.  A supplier can supply a fixed quantity of each part.

Normalisation has not been done yet, so colour and city are not separate entitities

Supplier

PK SupplierName

SupplierPart

PK SupplierName

SupplierPartQuantity

PK Part_Id

Part

PK Part_Id

Part_Colour

SupplierCity

  1. 1..* supplies >

1..*

1..

supplied by >

2 | P a g e

Question 2

The Motor Vehicle Branch administers driving tests and issues driver’s licences. Any person who wants a driver’s licence must first take a learner’s exam at any Motor Vehicle Branch in the province. If he/she fails the exam, he can take the exam again at any time after a week of the failed exam date, at any branch. If he passes the exam, he is issued a licence (type=learner’s) with a unique licence number. A learner’s licence may contain a single restriction on it. The person may take his driver’s exam at any branch any time before the learner’s licence expiry date (which is usually set at six months after the licence issue date). If he passes the exam, the branch issues him a driver’s licence. A driver’s licence must also record if the driver has complete driver’s education, for insurance purposes.

Driver

PK DriverId

Branch

PK BranchId

Licence

PK LicenceNo

1..

1..

is issued >

0..* 1 .. issued at >

Question 3

Imagine you are a consultant called into the office of a new start-up called Movies4All. This company admires the success of the Internet Movie Database (IMDb) in collecting and publishing movie- related information via the web and thinks it can set up its own database to rival the IMDb. The pay- back to Movies4All, they hope, will be advertising revenue once thousands of people start to visit their site looking for movie information. You are hired to assist them in the development of their site. They want to maintain the following information:

 Movies: title, cast, crew, story-line, genre, studio, year made and year released  Actors: biographical, photos, files they appeared in  Crew: occupation, biographical  Studios: contact information. Each movie is produced by a studio  Awards: given to movies

Design an ERD for the system.

Was this document helpful?

Worksheet Chapter 5 Memo

Course: Introduction to Databases and Databases Management Systems:Part 1 (CSIQ2634)

37 Documents
Students shared 37 documents in this course

University: University of the Free State

Was this document helpful?
1 | P a g e
UNIVERSITY OF THE FREE STATE
Department of Computer Science
and Informatics
CSIS2634
Worksheet (Chapter 5)
Question 1
Create an ERD using UML notation that can implement the following application from the
manufacturing industry at least the following business rules. Make sure you include all appropriate
entities, relationships, connectivities and cardinalities:
Each supplier has a unique name.
More than one supplier can be located in the same city.
Each part has a unique part number.
Each part has a colour,
A supplier can supply more than one part.
A part can be supplied by more than one supplier.
A supplier can supply a fixed quantity of each part.
Normalisation has not been done yet, so colour and city are not separate entitities
Supplier
SupplierNamePK
SupplierPart
SupplierNamePK
SupplierPartQuantity
Part_IdPK
Part
Part_IdPK
Part_Colour
SupplierCity
1..1 1..*
supplies >
1..*
1..1
supplied by >

Students also viewed

Related documents