Database, business and finance assignment help

User Generated

anan636

Business Finance

Description

All information in pic

Unformatted Attachment Preview

Relational Database Systems(COMP 1005) - Fall - 16-CW1-All كلية الشرق الأوسط| Middle East College Relational Database Systems (COMP 1005) Individual Assignment Fall 2016 Level: 5 Hand out week: Week 3 Duration: 7 weeks Submission Date & Time: Before 15th December 2016, 11:55 pm Total Weightage: 100 marks scaled down to 30 marks Objective: This is an individual assignment aimed to give the student exposure in understanding, designing, building and analyzing database systems for a given real-time based scenario and be able to conduct optimal strategies for efficient management of databases. Intended Learning Outcomes covered: 1. Design the logical structure of a database using Entity-Relationship diagram. 2. Apply normalization techniques to reduce redundancy in a database. Relational Database Systems(COMP 1005) - Fall - 16 - CW1-All Task 2: Scenario: Apollo Hospitals (AH) is a popular medical service provider in Oman. AH wants to automate its business functions into an information system. The proposed information system must be developed keeping in mind the following business rules. As part of this, you need to analyse and develop an Entity Relationship model depicting the following various business requirements and functionalities for the proposed Pharmacy Information System of AH. Dr. Prathap Reddy, Chairman, is aware that other multi-specialty hospitals are coming up in a big way and AH will face fierce competition from new healthcare systems. So, he has decided to take all measures to always be ahead of others in the market. It is increasingly important to AH that Reddy be able to analyse services rendered by AH and perception of patients more thoroughly. The Pharmacy places requests to the Purchase Department whenever it is in need of drugs. Pharmacy is identified by unique id, name and telephone number. Purchase Department is identified by a unique number. The other elements are phone number, manager. The Purchase Department submits many orders or may not submit an order. An order is uniquely identified by an id. The other elements of order are placement date, fulfillment date, received date, order amount. An order consists of one or more drugs or items. A drug is supplied by one or more supplier. A supplier supplies many drugs or may not supply a drug. Whenever a supplier supplies a drug, AH wants to record the shipment details such as date of supply. The elements of drug are unique id, name, type, manufacturer id, manufacture date, expiry date, batch number, unit cost. A supplier is uniquely identified by id. The other elements of supplier are name, address, phone number, email, location and track record. a) Construct the Entity Relationship Diagram (ERD) for the above given scenario. Identify all the entities, attributes of each entity including primary key, relationship between the entities and cardinality constraints. State any assumptions necessary to support your design. (30 marks) b) For the task 2a, analyse and recommend how the proposed ER model could accommodate the shipment and payments. (15 marks) Page COMP 1005 Relational Database Systems(COMP 1005) - Fall - 16 - CW1-All Task 3: (30 marks) a) Normalize the below given Patient Prescription Bin to First Normal Form, Second Normal Form and Third Normal Form, PHARMACY INFORMATION SYSTEM, APOLLO HOSPITALS Patient Prescription Bill Bill date: 02-May-2016 Prescription Number: 501 Patient Address: Al Khuwair Patient Category: M Bill number: 0000501 Registration Number: 0500010001 Patient Name: Mohsin Doctor ID: 129 Doctor Name: Imaan Total Unit Price 2.00 Quantity 10 20.00 36.00 9.00 4 5.00 20.00 Pres. Date Drug ID Drug Name 29/12/2015 1111 AAAAA 19/03/2016 1232 GGGGG 19/03/2016 2425 SYRINGE 21/03/2016 1111 AAAAA 21/03/2016 3339 PANADOL 10 10 0.50 2.00 1.00 TOTAL LESS 10% 10 10.00 91.00 9.10 81.90 NETT PAYABLE AMOUNT (OMR) b) For the finally arrived normalized form in task 3a above, discuss how the redundancy has (15 marks) been minimized. Task 4: Be ready for a written viva to demonstrate your knowledge with the different concepts used in preparing the assignment Schedule for the written viva will be announced in the class and on Moodle/MEC mail. Marks for task 2 and task 3 will depend on the written viva. Note: Task 4 is compulsory. No marks will be awarded to tasks 2 & 3 if written viva is not taken by a student Guidelines Follow the guidelines mentioned below for your assignment. Submit a work proposal detailing aspects such as initial understanding of the given tasks, timelines to complete each task, literature sources for solving the tasks. COMP 1005 Page 3 of 8 Relational Database Systems(COMP 1005) - Fall - 16 -CW1-All Assignment should be typed and uploaded to Moodle and will undergo plagiarism detection test through Turnitin (a plagiarism detection tool) Handwritten assignments will not be accepted. > Assignment should have a Title Page Title Page should contain the following information Assignment Name Class Student name Student ID > It should have Table of Contents → Use page numbers > Assignment should typed in your own words using Times New Roman font size 12. > Heading should be with Font Size 14, Bold, Underline > Use Diagrams and Examples to explain your topic. > Copy paste from the Internet or other student work is strictly not acceptable. > References should be included in the last page as follows Author name, Book Title, Publisher, Year in case of books In case of web site references type the full path of the web page with referenced date In case of journals/magazines/periodicals type article name, magazine name, Issue Number and date Р 005
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags