We are here with you hands in hands to facilitate your learning & don't appreciate the idea of copying or replicating solutions. Read More>>

Looking For Something at vustudents.ning.com? Click Here to Search


+ Link For Assignments, GDBs & Online Quizzes Solution


+ Link For Past Papers, Solved MCQs, Short Notes & More

Dear Students! Share your Assignments / GDBs / Quizzes files as you receive in your LMS, So it can be discussed/solved timely. Add Discussion

How to Add New Discussion in Study Group ? Step By Step Guide Click Here.

CS405 Assignment No 01 Fall 2019 Solution & Discussion Due Date: 14-11-2019

Semester: Fall 2019
Lectures Covered : 01-07
Total Marks: 20
Due Date: 14/11/2019

Students will be able to learn:
• Entity Relationship Diagram
• Structured Query Language
• How to write SQL Statement
Please read the following instructions carefully before submitting assignment:
It should be clear that your assignment will not get any credit if:

 The assignment is submitted after due date.
 The assignment is submitted via email.
 The assignment is copied from Internet or from any other student.
 The submitted assignment does not open or file is corrupt.
 It is in some format other than .doc/docx.

Note: All types of plagiarism are strictly prohibited.

For any query about the assignment, contact at

Question no 1
You are required to draw Entity Relationship Diagram of the following scenario to show how you would track this information. Show entity names, primary keys, attributes for each entity, relationships between the entities and cardinality.
“A shipping company named ABC shippers keeps up-to-date information upon the processing and current location of each shipped item. For record keeping, following product information is stored: product name, product ID and quantity. Products are made up of many components and each component can be supplied by one or more suppliers. The following component information is stored in databases for record keeping: component ID, name, description, suppliers, and products in which they are used.”
Keep the following assumptions in mind while drawing ERD
I. A supplier can exist without providing components.
II. A component does not have to be associated with a supplier.
III. A component does not have to be associated with a product. Not all components are used in products.
IV. A product cannot exist without components.
Question no 2
Consider the following table and its attributes:
Employee (emp_id, emp_name, designation, phone_no, address, joining_date, salary, department)

You are required to use this table to write SQL statements for the following cases:
a) Display the name and annual salary of all employees.
b) Display the name of all employees whose name is at least 4 characters long.
c) Display the name and department of the employees who earns the maximum salary.
d) Display data for all employees who earn between 10000 and 20000.
e) Count no. of employees working in each department.

+ How to Follow the New Added Discussions at Your Mail Address?

+ How to Join Subject Study Groups & Get Helping Material?

+ How to become Top Reputation, Angels, Intellectual, Featured Members & Moderators?

+ VU Students Reserves The Right to Delete Your Profile, If?

See Your Saved Posts Timeline

Views: 67


+ http://bit.ly/vucodes (Link for Assignments, GDBs & Online Quizzes Solution)

+ http://bit.ly/papersvu (Link for Past Papers, Solved MCQs, Short Notes & More)

+ Click Here to Search (Looking For something at vustudents.ning.com?)

+ Click Here To Join (Our facebook study Group)

Replies to This Discussion

A salesperson may sell many cars, but each car is sold by only one salesperson. A customer may buy many cars, but each car is bought by only one customer. A salesperson writes a single invoice for each car he or she sells. A customer gets an invoice for each car he or she buys. A customer may come in just to have his or her car serviced; that is, a customer need not buy a car to be classified as a customer. When a customer takes one or more cars in for repair or service, one service ticket is written for each car. The car dealership maintains a service history for each of the cars serviced. The service  records are referenced by the car’s serial number. A car brought in for service can be worked on by many mechanics, and each mechanic may work on many cars. A car that is serviced may or may not need parts (e.g., adjusting a carburetor or cleaning a fuel injector nozzle does not require providing new parts). 

ERD Answer

ERD Answer

Component(CompID, CompName, Description) PK=CompID

Product(ProdID, ProdName, QtyOnHand) PK=ProdID

Supplier(SuppID, SuppName) PK = SuppID

CompSupp(CompID, SuppID) PK = CompID, SuppID

Build(CompID, ProdID, QtyOfComp) PK= CompID, ProdID

Entity-Relationship Diagram Tutorial | ER Diagram Tutorial Part 1


Latest Activity

Rosetta added 2 discussions to the group SOC101 Introduction to Sociology
2 hours ago
Mani Siddiqui BS VIII posted a status
"مجھے تو کیسے خدا کے سپرد کر رہا ہے؟ میں تیرے ذمہ ہوں تو کہہ رہا ہے خدا حافظ"
2 hours ago
Mani Siddiqui BS VIII posted a status
"یہ دھواں دھواں جو خیال ہیں اسی بات کی تو دلیل ہیں کوئی بات آگ مجھ میں ضرور تھی جسے بے حسی نے بجھا دیا۔۔۔۔۔۔۔"
3 hours ago
Mani Siddiqui BS VIII posted discussions
4 hours ago
Hira rafique joined +M.Tariq Malik's group
4 hours ago
Profile IconMehwish Ghulam Nazik, Silent Boy, Sofia_Khan and 1 more joined Virtual University of Pakistan
5 hours ago
Rana Shoaib liked Mirha's profile
16 hours ago
Laila kabeer commented on +!!!StRaNGeR!!! +'s blog post جاناں
17 hours ago
Laila kabeer replied to Awais's discussion دل کے دشمن کو مہمان کر رکھا ھے
17 hours ago
khan joined +M.Tariq Malik's group
18 hours ago
Mushk liked zohaib iftikhar's blog post ...* MALAIKA KI DUA ...*
18 hours ago
Mushk liked Mani Siddiqui BS VIII's discussion خراب ریاضی
18 hours ago

© 2020   Created by +M.Tariq Malik.   Powered by

Promote Us  |  Report an Issue  |  Privacy Policy  |  Terms of Service