CS403 Assignment 2 Solution and Discussion
-
Re: CS403 Assignment 2 Solution and Discussion
Assignment No. 02
SEMESTER Spring 2020
CS403- Database Management System
Total Marks: 20Due Date: 15/06/2020
Instructions
Please read the following instructions carefully before solving & submitting assignment:
It should be clear that your assignment will not get any credit if:
• The assignment is submitted after due date.
• The submitted assignment does not open or file corrupt.
• The assignment is fully or partially copied (from other student or ditto copy from handouts or internet).
• Student ID is not mentioned in the assignment File or name of file is other than student ID.
• The assignment is not submitted in .doc or .docx format.
Uploading instructions
Your submission must include:• Assignment should be in .doc or .docx format.
• Save your assignment with your ID (e.g. bx020200786.doc).
• Assignment submission through email is NOT acceptable.
Objectives
The objectives of this assignment are:
• To be able to understand Logical Database Design
• To be able to perform different relational algebra operationsNote:
Your answer must follow the below given specifications.
• Font style: “Times New Roman”
• Font color: “Black”
• Font size: “12”
• Bold for heading only.
• Font in Italic is not allowed at all.
• No formatting or bullets are allowed to use.
• Your answer should be precise and to the point, avoid irrelevant detail.Lectures Covered: This assignment covers Lecture # 14 - 17
Deadline
Your assignment must be uploaded/submitted on or before 15/06/2020.Question Statement
Our second assignment is the continuation of our first assignment.
In the first assignment one question is related to entity relationship data model.
The entity relationship diagram is given below:Now in second assignment, you are required to perform the following tasks:
- Convert the above entity relationship diagram into relational data model. You have to convert all the three important components (entities, attributes and relationships between different entities) of the entity relationship diagram into relational data model.
- Consider the following tables and perform cross matrix of Shelve, Medicine and Pharmacist
(Shelve X Medicine X Pharmacist)
Pharmacist
Pharm_id Name Address
Ph001 Ahmad Lahore
Ph002 Tahir Islamabad
Ph003 Ather KarachiMedicine
Med_id Name Price Expiry_date
Md001 Panadol 20 22/2/2022
Md002 Disprin 20 22/3/2023
Md003 Brufen 40 22/4/2024Shelve
Shelve_id Number
Sh001 1
Sh002 2
Sh003 3-
Find the degree and cardinality of the following tables (given in 2nd question):
Table Cardinality Degree
Pharmacist
Medicine
Shelve -
Perform the following operations on the mentioned table and write the corresponding output:
σ Address == ‘Islamabad’ (Pharmacist)
∏ Med_id, Name, Expiry_date (σ Price<= 20 (Medicine)) -
Consider the following relations/tables and perform the following binary operations and write the output:
CreditCard
card_number expriy_date
Cardnumber001 23/5/2025
Cardnumber002 24/6/2025
Cardnumber003 25/7/2025Shelve
Shelve_id Number
Sh001 1
Sh002 2
Sh003 3- (Shelve) U (CreditCard)
- (CreditCard) – (Shelve)
=====================================Ended=======================================
For any query about the assignment, contact at [email protected]
GOOD LUCK
-
-
@cyberian said in CS403 Assignment 2 Solution and Discussion:
Convert the above entity relationship diagram into relational data model. You have to convert all the three important components (entities, attributes and relationships between different entities) of the entity relationship diagram into relational data model.
-
@cyberian said in CS403 Assignment 2 Solution and Discussion:
Consider the following tables and perform cross matrix of Shelve, Medicine and Pharmacist
(Shelve X Medicine X Pharmacist)Pharmacist
Pharm_id Name Address
Ph001 Ahmad Lahore
Ph002 Tahir Islamabad
Ph003 Ather Karachi
Medicine
Med_id Name Price Expiry_date
Md001 Panadol 20 22/2/2022
Md002 Disprin 20 22/3/2023
Md003 Brufen 40 22/4/2024
Shelve
Shelve_id Number
Sh001 1
Sh002 2
Sh003 3
Solution
f -
@cyberian said in CS403 Assignment 2 Solution and Discussion:
Find the degree and cardinality of the following tables (given in 2nd question):
Table Cardinality Degree
Pharmacist
Medicine
Shelve -
@cyberian said in CS403 Assignment 2 Solution and Discussion:
Perform the following operations on the mentioned table and write the corresponding output:
σ Address == ‘Islamabad’ (Pharmacist)
∏ Med_id, Name, Expiry_date (σ Price<= 20 (Medicine)) -
@cyberian said in CS403 Assignment 2 Solution and Discussion:
Consider the following relations/tables and perform the following binary operations and write the output:
CreditCard
card_number expriy_date
Cardnumber001 23/5/2025
Cardnumber002 24/6/2025
Cardnumber003 25/7/2025
Shelve
Shelve_id Number
Sh001 1
Sh002 2
Sh003 3(Shelve) U (CreditCard)
(CreditCard) – (Shelve) -
Assignment 2 CS403 file Solution Fall 2020
@zaasmi
Question: In this technological era manually managing any system is a time-consuming task. A construction company named “Global Construction” wants to computerize their manual system, so that they can easily and efficiently manage their employees, clients, projects and finance. It will be beneficial for both clients and company. Company has different employees who work on different projects. Global Construction database system will store all the information in an organized manner by following the below business rules:
Client can visit the website, view completed projects details and client’s review/feedback about projects, places an order by filling the order form, give review/feedback.
Manager can assign projects to employees, view assigned projects. Manger can also view placed orders, can accept or cancel the order. He can also generate receipt; client will be able to view and download the receipt. Employees will be able to view assigned projects, he can also update status of the project as started, partially completed, or completed.
Required
• Draw the ER diagram.
• Draw relationship cardinalities in alphabetical notation.
-