cs403 Assignment # 2 2016

	Assignment No. 02(Graded) SEMESTER Spring 2016 CS403- Database Management System		Total Marks: 20 Due Date:19/07/2016
*Instructions:* *bjectives:* 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.

Lectures Covered: This assignment covers Lecture # 7-10

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

Assignment CS403 Doc File download click here

cs302 Solved Quiz

estion # 1 of 10 ( Start time: 03:03:55 PM ) Total Marks: 1 Divide-by-32 counter can be acheived by using Select correct option: Flip-Flop and DIV 10 Flip-Flop and DIV 16 Flip-Flop and DIV 32 DIV 16 and DIV 32 Question # 2 of 10 ( Start time: 03:05:20 PM ) Total Marks: 1 The counter states or the range of numbers of a counter is determined by the formula. (“n” represents the total number of flip-flops) Select correct option: (n raise to power 2) (n raise to power 2 and then minus 1) (2 raise to power n) (2 raise to power n and then minus 1) Question # 3 of 10 ( Start time: 03:06:36 PM ) Total Marks: 1 A 4- bit UP/DOWN counter is in DOWN mode and in the 1010 state. on the next clock pulse, to what state does the counter go? Select correct option: 1001 1011 0011 1100 Question # 4 of 10 ( Start time: 03:07:37 PM ) Total Marks: 1 A 4-bit binary UP/DOWN counter is in the binary state zero. the next state in the DOWN mode is

Mth621 Final term paper sept 2020

Mth 621 paper Practise queation ma sa 80% aya : 3nu quizes ma sa sary mcqs ay Objective bi 30 aur subjective bi 30 k tha total 60 marks k paper tha Subjective total chap3 aur chap 4 ma say tha Subjective almost practise question ma sa tha Mcqs 80% quizes ma sa thay G therorem bi aik 2 to zehn ma ni a rhy 621 theorem on bounded set theorem on reman integral mean value theirem limit chain rule integaration 621 k saare mcq old quizes m se aye #Mth621 Mcqs were based on concepts and 6,7 was from mcqs file of quizz. 1-Define Removeavle continuity? 2 marks 2-Deifine chain rule for composition of functions? 2 marks 3-Define Second mean theorem of Integration? 4- Find uniform continuity of 2x? 5- A theorem was from Monotonic Function? 5 marks 6-evaluate lim->0 ln sinx/ln x?? 7- and Rest two was from the last 5th chp of about integration on closed interval. Mcqs zyada quiz mai sy thy evaluate lim->0 ln sinx/ln x?? Find uniform continuity of 2x? generalized mean value the

UniVERSITY VIRTUAL CAMPUSES & Contact #

UniVERSITY VIRTUAL CAMPUSES VU OWN CAMPUSES Sr # Province City Code Details 1 BALOCHISTAN PISHIN VPSN01 Virtual University Campus, Pishin Killi Malik Abdul Razzaq, Pishin Phone: 0826-442275 Fax: - Email: vpsn01@vu.edu.pk , vpsn01@vu.edu.pk 2 CAPITAL ISLAMABAD VIBD01 Virtual University Campus, Islamabad 9-E, Rizwan Plaza, Blue Area, Islamabad. Phone: 051-9213476 Fax: NA Email: vibd01@vu.edu.pk , vibd01@vu.edu.pk 3 KHYBER-PAKHTUNKHWA PESHAWAR VPSW01 Virtual University Campus, Peshawar 8-Jamrud Road, P.O. Tehkal Bala, Adjacent Toyota Froniter Motors, Peshawar. Phone: 091-5701071, 5705994 Fax: 091-5711381 Email: vpsw01@vu.edu.pk , vpsw01@vu.edu.pk 4 PUNJAB D.G. KHAN VDGK01 Virtual University Campus, D.G. khan Sakhi Sarwar Road, Old D.D.A. Building, Near Pul Dat, D.G. Khan. Phone: 064-2000919, 2472813 Fax: - Email: vdgk01@vu.edu.pk , vdgk01@vu.edu.pk

Virtual university Of Pakistan

Search This Blog