CSC265 Database Management System
Database Management System: most repeated questions
Questions that have come up in more than one paper, matched by what they ask rather than exact wording. Most repeated first.
- 4×Asked in 2082, 2080, 2079, Model questionDefine Normalization. Explain 1NF, 2NF and 3NF with a suitable example.Answer coming10
See the wording in each paper
- Define Normalization. Explain 1NF, 2NF and 3NF with a suitable example.TU Board 2082
- Define normalization. Why normalization is important in database design? Explain 1NF, 2NF and 3NF with suitable example.TU Board 2080
- What is normalization? Why normalization is required? Explain 1NF, 2NF, and 3NF with example.TU Board 2079
- What are the benefits of using normalization? Discuss 1NF, 2NF, and 3NF with suitable example.Model question
- 3×Asked in 2081, 2080, Model questionWhat are desirable properties of transactions? Explain conflict serializability with example.Answer coming10
See the wording in each paper
- 2×Asked in 2080Consider a banking database with three labels and primary key underlined as given below: Customer (CustomerID , CustomerName, Address, Phone, Email) Borrows (CustomerID, LoanNumber ) Loan ( LoanNumber , LoanType, Amount ) Write both relational algebra and…Answer coming10
See the wording in each paper
- Consider a banking database with three labels and primary key underlined as given below: Customer (CustomerID , CustomerName, Address, Phone, Email) Borrows (CustomerID, LoanNumber ) Loan (…TU Board 2080 (new course)
- Consider a banking database with three tables and primary keys underlined as given below: Customer(CustomerID, CustomerName, Address, Phone, Email) Owns(CustomerID, AccountNumber)…TU Board 2080
- 2×Asked in 2078, 2076Define schedule and serializability. How can you test the serializability?Answer coming
See the wording in each paper
- 2×Asked in 2081, 2080Define specialization. Explain disjoint constraint with example.Answer coming5
See the wording in each paper
- Define specialization. Explain disjoint constraint with example.TU Board 2081
- What is specialization? What are different constraints on specialization?TU Board 2080 (new course)
- 2×Asked in 2079, 2078Retrieve the TName, and No of priod of teachers who teach in "ABC" school using Relational Algebra. TEACHER (TID, TName, TAddress, TQualification) SCHOOL (SID, SName, SAddress, SPhone) SCHOOL TEACHER (SID, TID, No of Period).Answer coming5
See the wording in each paper
- Retrieve the TName, and No of priod of teachers who teach in "ABC" school using Relational Algebra. TEACHER (TID, TName, TAddress, TQualification) SCHOOL (SID, SName, SAddress, SPhone) SCHOOL…TU Board 2079
- Retrive the TName, SName, SPhone for "ABC" school using SQL from given relation as below.TU Board 2078
- 2×Asked in 2081, 2080What are informal design guidelines for relational schemas.Answer coming5
See the wording in each paper
- 2×Asked in 2080Why database recovery is essential? Explain recovery technique based on immediate update.Answer coming5
See the wording in each paper