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 6

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 6)

Question 1

Draw an extended ERD using the following specifications:

 A shape has a colour and a name  A shape may have a number of vertices (no more than 12) that define the shape. A vertex consists of an x-point and a y-point in 2D space. (x,y)  A triangle is a shape that has a triangle type (E for Equilateral, I for Isosceles and R for right- angled).  A circle is a shape that has a circumference and a radius

Question 2

Suppose a company has the following employee structure:

2 | P a g e

Draw an extended ERD for this structure. Note that the employee can only be one of the sub-classes of employees at any given time.

Question 3

Draw an EERD for the following:

 All musical instruments have a unique serial number.  All musical instruments have a date on which they were manufactured  A piano is an instrument that has a keyboard type.  A string instrument has a string type  A percussion instrument has a batterheadtype

Question 4

Draw an EERD for the following:

 A vehicle must have an engine an cannot have more than one engine.  A vehicle has between 2 and 4 tyres

Was this document helpful?

Worksheet Chapter 6

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 6)
Question 1
Draw an extended ERD using the following specifications:
A shape has a colour and a name
A shape may have a number of vertices (no more than 12) that define the shape. A vertex
consists of an x-point and a y-point in 2D space. (x,y)
A triangle is a shape that has a triangle type (E for Equilateral, I for Isosceles and R for right-
angled).
A circle is a shape that has a circumference and a radius
Question 2
Suppose a company has the following employee structure:

Students also viewed

Related documents