Practical Slip 13 - 2019 Pattern

 C Language:

Q1) Write a C program to accept the value of n and display sum of all odd numbers

up to n.

Q2) Write a program to accept a decimal number and convert it to binary, octal and

hexadecimal number.

DBMS:

Q3) Consider the following entities and their relationships. Create a RDB in 3 NF with appropriate data types and Constraints.

Driver (driver_id, driver_name, address)

Car (license_no, model, year)

Relation between Driver and Car is Many to Many with date and time as

descriptive attribute.

Constraint: Primary key, driver_name should not be null.

Consider the above tables and execute the following queries:

1. Display the name of driver whose license no is “DPU123”.

2. Delete the details of car whose model is “swift”.

Q4) Consider the above tables and execute the following queries:

1. Display details of all persons who are driving ‘Alto’ car.

2. Update model of car to “SUV300” whose manufactured year is 2019.

3. Display car details manufactured before year 2000.

4. In which day ‘Mr. Ram’ drives maximum number of cars.

5. Display total number of drivers who drives car in each year.