CS403 Assignment No 2 Solution Spring 2018
Here, I am providing you "Solution of CS-403 Assignment No 2 Database Management Due date 29-05-2018
Note: Please don't make exact copy of this document and make Changes in this assignment, write it in your own words always correct any errors if you found. I am not responsible for zero Marking.
Update: If you want to source file in docx format then just visit the link given below to download Solution file of CS403
How to Download the File : Watch video below to see the steps to download file
Instructions
Steps 1: Click at link given above
2: Enter Captcha Code
3: Wait for 8 Seconds
4: Click at Link Generated below the captcha box
5: That's it. You have downloaded
Note: We guarantee you that our site is 100% Malware and virus free so please Please Disabled your Ad-blocker to Download the file from our site..
|
If you still facing any problem then please let me know about your problem regarding downloading file and leave a comment below because your feed back is very important to us to make our website more reliable and useful.
CS403 Assignment No. 2 Solution explanation is given below;
Question 1: Map all entities into Relations with Primary,
Foreign key constrains where possible.
Answer
SERVICES (Service ID, Service Title, Service Description,
Service Charges)
CATEGORY (Category ID, category Name, Initial rates)
EVENT (Event ID, Date, Time Slot, Category ID, Customer ID,
Venue ID, Menu ID)
EVENT_SERVICES (Event ID, Service ID)
CUSTOMER (Customer ID, Customer Name, Email, Address)
VENUE (Venue ID, City, Capacity, Description, Location)
MENUE (Menu ID, Event ID, NO. of Services, Quantity)
FOODITEMS (Item ID,
Item Name, Description)
MENUE_FOODITEMS (Menu ID, Item ID)
- Consider the below populated relations.
Perform the cross product on SERVICES and EVENT relations by providing the
resultant relation.
Resultant relation of cross product on SERVICES and EVENT
Service
Id
|
Service
Title
|
Service
Description
|
Service
Charges
|
EventId
|
Date
|
timeSlot
|
01
|
Food
and beverage
|
Class
B
|
200$
|
Cx01
|
12.5.2018
|
11:00 am
|
02
|
Food
and beverages
|
Class
A
|
300$
|
Cx01
|
12.5.2018
|
11:00 am
|
03
|
Room
upgrades
|
Economic
|
150$
|
Cx01
|
12.5.2018
|
11:00 am
|
01
|
Food
and beverage
|
Class
B
|
200$
|
Bs03
|
25.5.2018
|
12:00 pm
|
02
|
Food
and beverages
|
Class
A
|
300$
|
Bs03
|
25.5.2018
|
12:00 pm
|
03
|
Room
upgrades
|
Economic
|
150$
|
Bs03
|
25.5.2018
|
12:00 pm
|
2.
Apply
projection operation on SERVICES relation and provide resultant relation. I-I
service ID , service Charges (SERVICES)
SELECT service Id, service Charges FROM Services;
Service Id
|
Service Charges
|
01
|
200$
|
02
|
300$
|
03
|
150$
|
3.
Take
Union of SERVICES and EVENT relations and provide output.
The given tables are not union compatible because:
1.
degree
of SERVICES is 4 and degree of EVENT is 3
2.
The
domains of corresponding attributes in both the relations in not same.
NOTE: IF YOU
FOUND ANY MISTAKE THEN CORRECT IT PLEASE DON’T MAKE EXACT COPY OF THIS
SOLUTION, MAKE CHANGES TO AVOID ZERO MARKING. IM NOT RESPONSIBLE FOR IT.
0 Comments