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

www.bit.ly/vucodes

+ Link For Assignments, GDBs & Online Quizzes Solution

www.bit.ly/papersvu

+ 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.

Assignment No. 02(Graded)
SEMESTER Spring 2016
CS403- Database Management System

Total Marks: 20

Due Date:19/07/2016

Instructions:

Please read the following instructions carefully before solving & submitting assignment:

It should be clear that your assignment will not get any credit (zero marks) if:

  • The assignment is submitted after due date.
  • The submitted assignment does NOT open or file is corrupt.
  • The assignment is copied (from other student or ditto copy from handouts or internet).
    • You are supposed to submit your assignment in .doc / Docx format. Any other formats like scan images,                      PDF, Zip, rar, bmp etc will not be accepted.

 

Objectives:

The objectives of this assignment are,

  • Giving the idea of most commonly used semantic data model for graphical representation of conceptual database design i.e. Entity Relationship Data model. 
  • Giving the idea of entities, attributes, cardinalities and relationship between the entities in the system.
  • Providing an understanding of types of relationships i.e. in how many ways an entity interact with other entity in real world.

 

 

For any query about the assignment, contact at cs403@vu.edu.pk

GOOD LUCK

 

Marks: 20 

 


Cooking Channel Database System

Food is one of human beings’ favorite obsessions. Most people spend a great deal of time physically and mentally preoccupied with food: we organize and prepare meals, we daydream about what’s for lunch or dinner; we eat.

"We are What We Eat"

As food is a major part of every one’s life so cooking channels are getting so much popularity nowadays. Cooking Channels are television specialty channels that only on air programs about food and cooking.

A number of cooking shows have run for many seasons on channels. Many of the more popular cooking shows have had flamboyant hosts whose unique personalities have made them into celebrities. From recent past, famous chefs are hosting the shows. The organization keeps the records of these shows, name, producer, timing etc along with the detailed information about the hosts. Administrator has full rights on this data as he/she is responsible for maintaining the system.

The channels also store the cooking recipes categories wise. There are categories like Breakfast, Salad Entrees, Soups, Fish, Chicken, Meat, Vegetarian Entrees, Side Salad/Dressings, Side Vegetables, and Desserts. Chefs can enter/edit/delete the recipes. Viewers can view these recipes any time through website. Viewers can also enter their own recipes along with their own record. They can also comment on the recipes of chefs and other people and on shows of the channel. All the users have to register themselves to access the system.

Mr. X wants to open a new cooking channel and has approached you to create a system to store the whole data related to cooking shows and recipes.

Important Note Regarding Assignment No. 02:

 

This Assignment is the continuation of First Assignment. Take same case study already used in Assignment 01.Apply the techniques and methods given in lectures (7-10) regarding ER Diagram and by utilizing the solution of first assignment uploaded on VULMS in the form of DFD in order to finalize the task of second assignment listed below in task description.

Task Description:

 

This Assignment is related to Design phase and in this assignment you will focus only on the tasks given below:

 

 

 

Task:

You will have to make a final comprehensive ER Diagram of the system showing all entities and their attributes identified in Task 2 of Assignment 1.                                                   (20 Marks)

 

Drawing Final ER Data Model:

You can use MS Word or MS Visio for drawing the final ER Diagram.

 

Guidelines:

  1. Use Standard UML notations for entities, attributes, relationships and cardinalities used in handouts.
  2. Use Proper naming conventions for entities, attributes and relations as given in handouts.
  3. Copy/Paste your class diagram in your final MS Word (.doc) file if you are using any drawing tool (MS Paint, MS Visio etc).                                                     

 

 

 

Lectures Covered: This assignment covers Lecture #  7-10

Deadline: Your assignment must be uploaded/submitted at or before July 19, 2016

 

+ 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: 6786

.

+ 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

to jo 11th lecture mae diagram bani hai kaya us jysi bany gi kindly give me an idea
kaya is kisam ki bany gi
Attachments:
kaya is kisam ki bany gi
Attachments:

idea ye hy k ap ne agar vu k lecture sun liye to sir sk ki videos dekhen youtube pe, to clear the concepts, aor sath me handouts se consult karen 

jis se apko

entities identify karna aa jayga,

phir relation aor cardinality check karen among entities,

phir dependency dekhen, apply normalization rules if u know 1nf, 2nf,3nf. but not necessory for this assignment actually, 

end pe apko pure diagram mily ge, 

ap ne jo pic share ki, is se generlization ka concept mily ga apko, super type aor subtype se,

Qaiser tery ander meri ruh agai hy .
Itni mehnat kon kry?
Khair jo b yeh kry wt u mention success is waiting for him/her

what about administrator and channel. i think these two should not be in erd.

acha us diagram mae entities thik thi ya kuch skip karni hai

sk bro check it er diagram is right or not?

Attachments:

what about administrator and channel. i think these two should not be in erd. and you have not decribed relation type and also use crow's feet notation for cardinality

diamond shape may relation ka name bhe likhna hay

if put relation name in diamond that is called "Associative Entity" and we use associative entity only if we hav common attributed which needed in both relations.

RSS

Latest Activity

+ ՏhehαrZααD + liked + !! "AS" !!'s discussion Jis Tarah ..
1 hour ago
Pronoun liked zobialatif's discussion hazrat ali says
1 hour ago
٥ دن updated their profile
2 hours ago
+ !! "AS" !! replied to + !! "AS" !!'s discussion Jis Tarah ..
2 hours ago
Siddiq khan kakar liked + M.Tariq Malik's discussion PAK301 Pakistan Studies Short Notes, PAK301 Solved Subjective Questions, PAK301 Solved MCQs
2 hours ago
Siddiq khan kakar liked + M.Tariq Malik's group PAK301 Pakistan Studies
2 hours ago
+ ! ! JS ! ! + posted a discussion
2 hours ago
Siddiq khan kakar liked Siddiq khan kakar's discussion RIP
2 hours ago
Kashif Iqbal added 2 discussions to the group FIN624 Islamic Mode of Financing
2 hours ago
+ ! ! JS ! ! + liked + Iuuoɔǝut +'s discussion جلوۂ عشق حقیقت تھی حسن مجاز بہانہ تھا
2 hours ago
+ ! ! JS ! ! + liked + !! "AS" !!'s discussion Baat Karna ...
2 hours ago
+ ! ! JS ! ! + liked + !! "AS" !!'s discussion Ghalti...
2 hours ago
+ ! ! JS ! ! + liked + !! "AS" !!'s discussion Yaha Har Cheez ..
2 hours ago
+ ! ! JS ! ! + liked +!!!StRaNGeR!!! +'s discussion ﺁﭖ ﺩﻝ ﺟﻮﺋﯽ ﮐﯽ ﺯﺣﻤﺖ ﻧﮧ ﺍﭨﮭﺎﺋﯿﮟ ، ﺟﺎﺋﯿﮟ
2 hours ago
+ ! ! JS ! ! + liked + !! "AS" !!'s discussion Alfaaz Ki Nisbat..
2 hours ago
+ ! ! JS ! ! + liked + !! "AS" !!'s discussion Jis Tarah ..
2 hours ago
Siddiq khan kakar posted discussions
2 hours ago
+ ! ! JS ! ! + replied to + !! "AS" !!'s discussion Jis Tarah ..
3 hours ago
Zain Arshad replied to + M.Tariq Malik's discussion ENG201 Business and Technical English Writing Assignment No 01 Fall 2019 Solution & Discussion in the group ENG201 Business and Technical English Writing
3 hours ago
Nayyab Anwar updated their profile
3 hours ago

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

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