
-
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 TopicOrchid 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. -
Re: CS403 Assignment 2 Solution and Discussion
Assignment No. 02SEMESTER 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 3Find the degree and cardinality of the following tables (given in 2nd question):
Table Cardinality Degree
Pharmacist
Medicine
ShelvePerform 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) U (CreditCard) (CreditCard) – (Shelve)
Shelve_id Number
Sh001 1
Sh002 2
Sh003 3
=====================================Ended=======================================For any query about the assignment, contact at [email protected]
GOOD LUCK
-
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: 20Due 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 relationsNote:
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:
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 sm001Bill:
bill_id cust_id order_id net_amount
b001 cust001 od001 500
b002 cust002 od002 550
b003 cust001 od003 600And write the output of the following relational algebra operations:
• ∏ order_id, cust_id, sman_id (Order)
Find the degree and cardinality of the relations (Order and Bill) given in the 2nd question.
• σ net_amount > 500 (Bill)
• ∏ order_status, delivery_date (σ btag_no= ‘bt002’ (Order))====================================Ended=======================================
For any query about the assignment, contact at [email protected]
GOOD LUCK
-
Assignment No. 01
SEMESTER Fall 2019
CS403- Database Management System
Total Marks: 20Due 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 [email protected]
GOOD LUCK
SOLVED CS403 GDB1 Solution and discussion
-
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. -
@zareen said in CS403 GDB1 Solution and discussion:
Now would you normalize the database or keep your database in de-normalized form.
Although, denormalized schema can greatly improve performance under extreme read-loads but the updates and inserts become complex as the data is duplicate and hence has to be updated/inserted in more than one places.
One clean way to go about solving this problem is through the use of triggers. For example in our case where the orders table has the product_name column as well, when the value of product_name has to be updated, then it can simply be done in the following way:
- Have a trigger setup on the products table that updates the product_name on any update to the products table.
- Execute the update query on the products table. The data would automatically be updated in the orders table because of the trigger.
However, when de-normalizing the schema, do take into consideration, the number of times you would be updating records compared to the number of times you would be executing SELECTs. When mixing normalization and de-normalization, focus on de-normalizing tables that are read intensive, while tables that are write intensive keep them normalized.
-
Suppose, you are going to develop an application that will be mainly used for data analysis. The database for this application contains huge amount of data which is mainly loaded in batches. This application does not require insertion/updation/deletion of individual records. Our main objective is to improve the performance of application to quickly perform desired analysis.
Now, as a student of the Database Management System, you are going to design the database for above application. In the database design, your main concern will be the “efficiency” in term of searching. Now would you normalize the database or keep your database in de-normalized form.
Justify your answer in either case with proper reasons.
Note: Answer should not exceed 200 words.
-
-
-
Relational data model
As a database designer, I’ll choose relational data model for the database designing because the relational model represents the database as a collection of relations. A relation is nothing but a table of values. Every row in the table represents a collection of related data values. These rows in the table denote a real-world entity or relationship.
The table name and column names are helpful to interpret the meaning of values in each row. The data are represented as a set of relations. In the relational model, data are stored as tables. However, the physical storage of the data is independent of the way the data are logically organized.
Relational Integrity constraints are referred to conditions which must be present for a valid relation. These integrity constraints are derived from the rules in the mini-world that the database represents.
Four basic update operations performed on relational database model are
Insert, update, delete and select. The Relational database model represents the database as a collection of relations (tables)Attribute, Tables, Tuple, Relation Schema, Degree, Cardinality, Column, Relation instance, are some important components of Relational Model Relational Integrity constraints are referred to conditions which must be present for a valid relation. The relational database is only concerned with data and not with a structure which can improve the performance of the model
50% Off on Your FEE Join US!


