Virtual University Desk
Virtual University Of Pakistan Network
CS001 CS101 CS201 CS301 CS302 CS304 CS401 CS402 CS403 CS408 CS410 CS501 CS502 CS504 CS506 CS507 CS508 CS601 CS602 CS604 CS605 CS606 CS607 CS609 CS610 CS614 CS615 CS619 CS701 CS702 CS703 CS704 CS708 CS709 CS710CS712 CS716 CS718 CS720 CS723
CS724
ETH201
HRM611 HRM619 HRMI619HRM620 HRM623 HRM624 HRM625 HRM627 HRM628HRM619 HRMI619HRMI620
ISL201
MCM101 MCM301 MCM304 MCM310 MCM311 MCM401 MCM404 MCM411 MCM431 MCM501 MCM511 MCM514 MCM515 MCM516 MCM517 MCM520MCM531 MCM532 MCM601 MCM604 MCM610 MCM619 MCMI619
MGT101 MGT111 MGT201 MGT211 MGT301 MGT401 MGT402 MGT411 MGT501 MGT502 MGT503 MGT504 MGT510 MGT520 MGT601 MGT602 MGT603 MGT604 MGT610 MGT611 MGT613 MGT619 MGTI619MGT620 MGTI620
MKT501 MKT530MKT610 MKT611 MKT621 MKT624 MKT625 MKT630 MKT619MKTI619MKT620MKTI620
PSY101 PSY401 PSY402 PSY403 PSY404 PSY405 PSY406 PSY407 PSY408 PSY409 PSY502 PSY504 PSY505 PSY510 PSY511 PSY512 PSY513 PSY514 PSY515 PSY610 PSY619 PSY631 PSY632 PSYI619
URD101
 |
 |
 |
 |
 |
 |
 |
 |
| VUPROJECTS |
AIOU PROJECTS |
VUDESK TUBE |
VUDESK APP |
IT INTERNSHIPS | FB Page |
FB Group |
DESK MEMBERS |
APPLY NOW | SIT (STEP IN SECURITY) | Ghrapical Password | Smart ETL Tool | SMS BLOCKER
Assignment No. 02(Graded) SEMESTER Spring 2016 CS403- Database Management System
Assignment No. 02(Graded) |
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:
Objectives: The objectives of this assignment are,
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:
|
-
-
Spring 2016_CS403_2.doc, 168 KB
-
Replies to This Discussion
-
BS(CS)Permalink Reply by Hania Eman on -
idea solution attached
-
-
CS403ASSIGN2.docx, 271 KB
-
-
© 2019 Created by ʭIsmail Shahʭ.
Powered by
| Awards & Titles |
 Chief Admin |
 Senior Admin |
 ADMINS |
 MOTM |
 Gold Members |
 Miss VU |
 MR VU |
/*/ We are user-generated contents site. All product, videos, pictures & others contents on vudesk.net don't seem to be beneath our Copyrights & belong to their respected owners & freely available on public domains. We believe in Our Policy & do according to them. If Any content is offensive in your Copyrights then please email at admin@vudesk.net at contact Page with copyright detail & We will happy to remove it immediately.
| Site Leaderboards | ||
| (-) Top Members This Week | (-) Top Members Today | |
| (-) Top Content This Month | (-) Top Content This Week | (-) Top Content Today |
| (-) Top Photos This Month | (-) Top Photos This Week | (-) Top Photos Today |
| (-) Top Blog Posts This Month | (-) Top Blog Posts This Week | (-) Top Blog Posts Today |
| (-) Top Videos This Month | (-) Top Videos This Week | (-) Top Videos Today |
| (-) Top Discussions This Month | (-) Top Discussions This Week | (-) Top Discussions Today |
