Re: CS403 Assignment 2 Solution and Discussion
Assignment No. 02
SEMESTER Spring 2020
CS403- Database Management System
Total Marks: 20
Due 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 operations
Note:
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 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
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/2025
Shelve
Shelve_id Number
Sh001 1
Sh002 2
Sh003 3
(Shelve) U (CreditCard)
(CreditCard) – (Shelve)
=====================================Ended=======================================
For any query about the assignment, contact at CS403@vu.edu.pk
GOOD LUCK
Spring 2020_CS403_2.doc
Re: CS403 GDB1 Solution and discussion
Total Marks 5
Starting Date Monday, February 15, 2021
Closing Date Tuesday, February 16, 2021
Status Open
Question Title GDB Topic
Question Description
GDB Topic
Orchid bank is a private sector bank which has branches in different countries. Orchid bank uses database for the storage of clients’ data because databases can store very large numbers of records efficiently. By using database, we can add, edit or delete data easily. It is more efficient in data searching and data sorting. Database can be used by more than one user to access same data simultaneously.
As a database designer, which type of database (distributed database & centralized database) you will use in this scenario to ensure data consistency, easy management and easy backup?
Also, what you think that replication of database suitable in the above given scenario?
Note: Your GDB answer should not exceed 4 to 5 lines.
GDB Instructions:
You need to provide precise and to the point answer, avoid irrelevant details.
Copied from the internet or another student will get zero marks.
You cannot participate in the discussion after the due date via email.
The GDB will open and close on specified date and time. Please note that no grace day or extra time will be given for posting comments on GDB.
GDB Topic:
The Virtual University has a multi-disciplinary approach and offers extensive degree programs in numerous academic disciplines. Although undergraduate and post graduate degrees are awarded in many disciplines, the most sought and highly popular degrees offered by the University are in the fields of Computer and IT. BS, MS and PhD program offered under the department of CS and IT. Students get enrolled and study the relevant courses in a particular semester. VU manages the information about students, degree programs, student’s achievements, course credentials and many more.
Let’s suppose, you are the database designer and asked to design the database of above given scenario.
In order to design the database, you have to choose a data model from the following data models:
Hierarchical data model
Network data model
Relational data model
As a database designer which data model will you choose for the database designing? Justify your answer in either case with only very solid points.
Note: Answer should not exceed 200 words.
GDB Instructions:
You need to provide precise and to the point answer, avoid irrelevant details.
Copied from the internet or another student will get zero marks.
You cannot participate in the discussion after the due date via email.
The GDB will open and close on specified date and time. Please note that no grace day or extra time will be given for posting comments on GDB.
EDU302 Assignment No. 02
SEMESTER Spring 2019
CS403- Database Management System
Total Marks: 20
Due Date: 02/12/2019
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 full 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
Objectives
The objective of this assignment is to able the Students:
• To understand the relational database model
• To understand the Conversion of ERD into relational data model
• To understand the Cartesian product of two relations
• To understand the degree and cardinalities of relations
Note:
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 # 10 - 17
Deadline
Your assignment must be uploaded/submitted on or before 02/12/2019.
Question Statement
Our second assignment is the continuation of the first assignment. In the first assignment an ERD was required for the given scenario, which is given below:
[image: RN2Q5Ix.png]
You’re required to perform the following tasks:
Convert the above Entity Relationship Diagram into Relational data model.
You have to convert all the components of the ERD into Relational Data model.
Consider the following two tables:
Order:
order_id order_status delivery_date btag_no cust_id sman_id
od001 Completed 10/30/2019 bt001 cust001 sm001
od002 Completed 10/30/2019 bt002 cust002 sm001
od003 Completed 10/30/2019 bt003 cust003 sm001
Bill:
bill_id cust_id order_id net_amount
b001 cust001 od001 500
b002 cust002 od002 550
b003 cust001 od003 600
And write the output of the following relational algebra operations:
• ∏ order_id, cust_id, sman_id (Order)
• σ net_amount > 500 (Bill)
• ∏ order_status, delivery_date (σ btag_no= ‘bt002’ (Order))
Find the degree and cardinality of the relations (Order and Bill) given in the 2nd question.
====================================Ended=======================================
For any query about the assignment, contact at CS403@vu.edu.pk
GOOD LUCK
Assignment No. 01
SEMESTER Fall 2019
CS403- Database Management System
Total Marks: 20
Due Date: 13/11/2019
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 full or partially copied from (other student or ditto copy from handouts or internet).
• 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
Objective
The objective of this assignment is
• To give basic knowledge and understanding of Database.
• To be able to understand Conceptual Database Design.
Note:
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 # 01 - 08
Deadline
Your assignment must be uploaded/submitted on or before 13/11/2019.
Question
Suppose a water filtration company “ABC” wants to develop a database system for his business flow. This database system will manage its customers, employees, stocks and sales area details. Database system will manage the different sales areas for delivery, defined by the company upon customer request. Customers can place the delivery request at least one day before. The Manager can check the customer order request and generate the bill/voucher accordingly. The salesman will deliver the order to the customer. The customer will pay the dues. After delivery, salesman can also update the order status. Customers can give their feedback about water quality and delivery system. Company will give special discounts and water dispensers to their special customers, and these special facilities depend on the usage of water bottles. Company also wants to keep track of their delivered bottles details.
• Draw the context level diagram.
• Identify Entities, their attributes, relationships among entities in above scenario and draw Entity Relationship Diagram (ERD) for it.
Note: You are required to submit Context level diagram and ERD as your solution only.
=====================================Ended=======================================
For any query about the assignment, contact at CS403@vu.edu.pk
GOOD LUCK
CS403 Assignment 1 Solution and Discussion
CS403 - Database Management Systems
2
Posts
1
Posters
3.6k
Views
1
Watching
PAK VS BAN Live
File Sharing
