Skip to document

Worksheet Chapter 6 - 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.

Preview text

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:

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.

Was this document helpful?

Worksheet Chapter 6 - Memo

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

37 Documents
Students shared 37 documents in this course
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