F.Y.B.B.A.(C.A.)/B.C.A. SEMESTER I - SOLVED PRACTICAL SLIP 7(C-PROGRAMMING AND DBMS)@aishashaikh2717

F.Y.B.B.A.(C.A.)/B.C.A. SEMESTER I - SOLVED PRACTICAL SLIP 7(C-PROGRAMMING AND DBMS)@aishashaikh2717
Q1. Write a C program to accept the x and y coordinates of two points and compute the distance between the two points. [15 Marks]
Q2. Write a program to calculate Multiplication of two matrices of order m*n. [25 Marks]
Q3. Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints. [15 Marks]
Room (roomno, desc, rate)
Guest (gno, gname, no_of_days)
The relationship between Room and Guest is One to One.
Constraint: Primary key, no of days should be greater than 0.
Consider the above tables and execute the following queries:
1. Update the rate of room to 5000 whose type is “AC”.
2. Display the name of guest who is staying 2 days in roomno 101.
Q4. Consider the above tables and execute the following queries: [25 Marks]
1. Display room details according to its rates in ascending order.
2. Display the roomno in which “Mr. Advait” is staying for 7 days.
3. Find no. of AC rooms.
4. Find names of guest with maximum room charges.
5. Display guest wise halt days.

Видео F.Y.B.B.A.(C.A.)/B.C.A. SEMESTER I - SOLVED PRACTICAL SLIP 7(C-PROGRAMMING AND DBMS)@aishashaikh2717 канала Aisha Shaikh