CS614 Assignment No 1 Spring 2020
Dear Students, Here you can read or download CS614 - Data Warehousing Assignment 1 Solution of Semester Spring 2020. The Assignment Due Date is 1st June 2020. Total Marks are 20. CS614 Assignment 1 Solution Spring 2020 File and Sample Preview have also been added below. Previously we shared CS201 Assignment No 1 Solution Spring 2020. |
| CS614 Assignment No 1 Solution Spring 2020 |
CS614 Assignment Objectives:
After completing this assignment, the students will be able to:- Identify Database entities from a given scenario
- Understanding and designing the system’s constraints from a given scenario
- Understand the database table structure
- Normalize a database table up to 2nd Normal Form (2NF)
CS614 Assignment Instructions:
Please read the following instructions carefully before submitting the assignment:It should be clear that your assignment will not get any credit if:
- The assignment is submitted after the due date.
- The submitted assignment does not open or file is corrupt.
- The assignment is copied (From the internet/ to from students).
- Assignment is submitted other than word format (.doc, .docx).
CS614 Assignment Question:
XYZ polyclinic is a well-reputed clinic providing good medical facilities in a posh area of Lahore. They also have a facility to admit a patient if the treatment requires. XYZ polyclinic was working manually for the last 10 years. You are hired by XYZ polyclinic management to design a database by reading the system’s requirements. Management of XYZ polyclinic decides to improve their system that would lead to convert the Database system to Data Warehouse for XYZ polyclinic in the future.Database Requirements:
The organization is interested in storing name, patient’s CNIC, address, city, zip, province, country, phone number, referred by, admission date, and discharge date for storing patient’s information in the database. The referred by (would contain doctor’s id), admission date and discharge date attributes are only used in case of patient’s admission in a specific room. From the doctor’s point of view, they are interested to store doctor name, CNIC of a doctor, address, city, zip, province, country, doctor’s phone number, area of specialization. We must store the treatment information that is suggested by the doctor for a specific patient which includes prescribed medicines. Medicine details must contain medicine id, name, dosage, and potency as attributes along with the reference to treatment that is suggested by a doctor. If a patient would require getting admit in polyclinic then the room type (executive/common), phone extension, and charges per day are going to be stored in the system as room attributes.Some additional constraints about the system are as under;
- One patient is referred to as one/more doctors at a time.
- Multiple patients would be examined by the doctor in a day
- One patient may have multiple visits to a single doctor
- Room capacity/facilities for attendants would not be handled at this time
- One patient may use many medicines as suggested by the doctor
- Every time visit to a doctor may result in a change of medicine or admitted to the polyclinic
TASK to Perform and Submit:
Identify relevant entities, primary keys, foreign keys, proper attributes, and relations as per 2NF for the above scenario and provide database/schema/table-structure in MS-Word format that is Normalized up to 2nd Normal Form.Important Note:
- There’s no need to implement the solution using any DBMS
- Attribute Names should be clearly mentioned
CS614 Assignment 1 Solution Spring 2020
You can see the Sample Preview of CS614 Assignment 1 Solution 2020 provided by (Virtual Study Solutions) below. Click on Download Button to Download Solution File in Your PC. Please Share it with your friends. You can also like our Facebook Page or Subscribe Us on YouTube for Latest Updates related to Assignment Solution and Past Papers.
We also recommend you to read:
CS614 Mid Term Past Papers Collection
| File Name | Download Link |
|---|---|
| CS614 Mid Term Papers Collection.zip | Download |
Please Note:
We are here to facilitate your learning and we do not appreciate the idea of copying or replicating solutions.
CS614 Assignment 1 Solution Explanation - Watch Video
Please Note: This Solution is in MS Excel but you have to submit assignment in MS Word File. Otherwise you will get zero marks.
Download CS614 Assignment 1 Solution Spring 2020
| File Name | Download Link |
|---|---|
| CS601 Assignment 1 Solution Spring 2020.docx | Download |
Post a Comment