Database Design & Development
MODULE:
DATABASE DESIGN & DEVELOPMENT
ASSIGNMENT TITLE:
VETERINARY SURGERY DATABASE DEVELOPMENT
Table of Content
Task 1 Page 2
Task 2 Page 5
Task 3 Page 14
Task 4 Page 28
Task 5 Page 30
Reference Page 32
Bibliography Page 33
Task 1
Question:
AIM: Draw an Entity Relationship Data Model that describes the content and structure of the data held by Petcare. Specify the cardinality ratio and participation constraint of each relationship type.
Answer:
I have prepared this assignment to demonstrate an understanding of applying data modeling and analysis techniques to the design and development of database solutions. I am as a sub-contracted to design the database system supporting the Veterinary Doctor for the Petcare. Entity relationship Model: a data model originally had three primary constructs: entity, relationship and attributes.
There are three primary constructs in ER models: • Entities are the "things" about which we seek information. • Attributes are the data we collect about the entities. • Relationships provide the structure needed to draw information from multiple entities.
[pic]
Figure1 is shown the entity relationship diagram for the “Petcare”.
[pic]
Figure 2 is shown the entity relationship diagram showing primary key, foreign key and attribute.
The diagrams in this figure specify the different set of data requirements, namely... An Animal must be only one of Animal Type. The relation ship Between the Animal and Animal Type entity there is an 1:M An Animal is owned by one Owner. The relation ship Between the Animal and Owner entity there is an 1:M An Appointment contains a number of Animal. The relation ship Between the Appointment and Animal entity there is an 1:M An Appointment contains a number of Veterinary Doctor. The relation ship Between the Appointment and Veterinary Doctor entity there is an 1:M An Veterinary Doctor works one of Branch. The relation ship Between the
DATABASE DESIGN & DEVELOPMENT
ASSIGNMENT TITLE:
VETERINARY SURGERY DATABASE DEVELOPMENT
Table of Content
Task 1 Page 2
Task 2 Page 5
Task 3 Page 14
Task 4 Page 28
Task 5 Page 30
Reference Page 32
Bibliography Page 33
Task 1
Question:
AIM: Draw an Entity Relationship Data Model that describes the content and structure of the data held by Petcare. Specify the cardinality ratio and participation constraint of each relationship type.
Answer:
I have prepared this assignment to demonstrate an understanding of applying data modeling and analysis techniques to the design and development of database solutions. I am as a sub-contracted to design the database system supporting the Veterinary Doctor for the Petcare. Entity relationship Model: a data model originally had three primary constructs: entity, relationship and attributes.
There are three primary constructs in ER models: • Entities are the "things" about which we seek information. • Attributes are the data we collect about the entities. • Relationships provide the structure needed to draw information from multiple entities.
[pic]
Figure1 is shown the entity relationship diagram for the “Petcare”.
[pic]
Figure 2 is shown the entity relationship diagram showing primary key, foreign key and attribute.
The diagrams in this figure specify the different set of data requirements, namely... An Animal must be only one of Animal Type. The relation ship Between the Animal and Animal Type entity there is an 1:M An Animal is owned by one Owner. The relation ship Between the Animal and Owner entity there is an 1:M An Appointment contains a number of Animal. The relation ship Between the Appointment and Animal entity there is an 1:M An Appointment contains a number of Veterinary Doctor. The relation ship Between the Appointment and Veterinary Doctor entity there is an 1:M An Veterinary Doctor works one of Branch. The relation ship Between the