Description
All information in pic
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
hello am happy to tell you that I have your work ready
1
TITLE PAGE
Assignment Name
Class
Student Name
Student ID
TABLE OF CONTENTS
Title Page
……………………………………………………………….
Pg1
Work proposal
……………………………………………………………….
Pg 2
Introduction
……………………………………………………………….
Pg3
Task 2a
………………………………………………………………
Pg4
Task 2b
……………………………………………………………….
Pg 5
Task 3
……………………………………………………………….
Pg 7
Normalization
……………………………………………………………….
Pg 8
References
……………………………………………………………….
Pg 10
Task 2
2
WORK PROPOSAL
Task 2
Summary
The intended task is aimed to help me understand and design a logical structure for a database
using an Entity Relationship diagram. This is well demonstrated in task 2 as I have to use my
skills to design a logical Structure for a Pharmacy database using an Entity Relationship
diagram.
Skill demonstrated
With this I can demonstrate my knowledge about entities, keys, relationship between entities,
cardinality constraints and Assumptions necessary.
I can demonstrate my knowledge and skill in showing how to accommodate other entities in the
database without damage to the logical structure.
Terms Defined
Entity
: Abstract data that is seen in data bases like, Drugs, Customers mostly a Noun.
Key
Data attribute identifying an entity can be primary or foreign
Primary K...