Home 
About
Blog
What is flat file system? Explain the advantages of using DBMS over flat file system.
How logical data independence is different from physical data independence? Explain three level database architecture.
How primary key is different from super key? Explain composite key and partial key.
What are selection and projection operators in relational algebra? Given a table with schema
Student(Rollno(PK), Fname, Lname, Address, Level, Did(FK)),
Department(Did(PK), Dname, HOD)
Write an RA query to find the name of students who are in 'Bachelor' level living in 'Birgunj' and studies under the department with department head 'Ramesh Sharma'.
How parameters can be passed to a stored procedure? Explain with an example.
How timestamp based algorithm uses timestamp to serialize the execution of concurrent transactions? Explain in detail.
What are different types of indexing used in database? How index can be created using SQL? Write with example.
Attempt any TWO questions
[2x10=20]What are the advantages of normalization? Explain 3NF and BCNF with example.
How ER model can be mapped to the relational data model? Explain with a proper example.
a) What is inner join? Perform inner join to find the customer names who are going on flight to 'South Wales':
Customer (Cid, Name, Address, Age, Email)
Booking(Cid(FK), FlightID(FK), BookedDate)
Flight(FlightID, AirplaneCode, DepartureTime, Destination, Duration)
b) What are unary and ternary relationship? Write with examples.