SECTION C
LONG ANSWER QUESTIONS
Answer ANY TWO Questions. (2x10=20)
1. You have been hired to create a system for an online bookstore. The bookstore
needs to manage information about books, authors, customers, and orders. The
system should allow customers to browse and purchase books, track order history,
and manage inventory. System will store the following details of the book: -
BookID (Uniquely identifies the book), Title,ISBN, Genre, and Price.
A book can be written by multiple authors and an author can write multiple books.
System will keep records of author which have details such as AuthorID (uniquely
identifies author), AuthorName, Bio, and Nationality. System should also keep the
track of the information of the Customers. Details of the customers such as
CustomerID, CustomerName, Address, and Email is captured by the system.
Customer will be able to order multiple books from the bookstore. Admin user should
be able to see the records of the orders which will have details such OrderID (Primary
Key), Date, and TotalAmount.
Design the Entity Relationship Diagram (ERD). Feel free to extend and use your logic.
2. What is normalization, and why is it important in database design? Convert the
below given table in 3NF form.
3. Define what an RDBMS is and explain how it differs from traditional file-
based systems. (Highlight the core principles of relational databases, including tables,
rows, columns, and the concept of relationships)
PRE-TEST EXAMINATION PAPER
Program : BSc.IT
Course : Introduction to Database
Course Code : CT042-3-1
Year/ Semester : I Year / I Semester
Intake : September,2023
Date : 5th February 2024
Time Duration : 1.5 Hours
Set :A
Instruction to candidates
1. This question paper has Three (3) Sections.
2. Answer ALL questions in Section A, Very Short Answer Questions.
3. Answer Five out of Seven questions in Section B, Short Answers Questions.
4. Answer Two out of Three question in Section C, Long Answers Questions.
5. No scripts or answer sheets are to be taken out of the Examination Hall.
6. Mobile phones are strictly prohibited in the Examination Hall.
Do not open this question paper until instructed.
SECTION A
Multiple Choice Questions (10x1=10)
1. In an RDBMS, what is a primary key?
a. A key that is used for encryption
b. A unique identifier for a record in a table
c. A key used to access a database remotely
d. A key that is used for sorting records
2. What is the purpose of the SQL SELECT statement in an RDBMS?
a. To insert data into a table
b. To update data in a table
c. To retrieve data from a table
d. To delete data from a table
3. What is normalization in the context of RDBMS?
a. The process of organizing data to minimize redundancy
b. The process of encrypting data for security
c. The process of sorting data alphabetically
d. The process of backing up data regularly
4. In an RDBMS, what does the term "foreign key" refer to?
a. A key used for sorting records
b. A key that is generated automatically
c. A key that refers to the primary key in another table
d. A key used for encryption
5. What is one of the key advantages of using an RDBMS over a flat file
system?
a. Higher storage space efficiency
b. Improved data security
c. Faster data retrieval and manipulation
d. Simpler data organization
6. What is the purpose of cardinality in an ERD?
a. To define the type of entity
b. To indicate the number of instances of one entity that can be
associated with another entity
c. To specify the data type of an attribute
d. To define the primary key of an entity
7. Which normal form deals with partial dependencies?
a. First Normal Form (1NF)
b. Second Normal Form (2NF)
c. Third Normal Form (3NF)
d. Boyce-Codd Normal Form (BCNF)
8. What does the diamond shape represent in an ERD?
a. Entity c. Relationship
b. Attribute d. Key
9. In an ERD, what does a double oval represent?
a. Weak entity c. Attribute
b. Strong entity d. Relationship
10. Which cardinality notation represents "zero or more" in an ERD relationship?
a. 1 c. 0..n
b. 0..1 d. 1..n
SECTION B
SHORT ANSWER QUESTION
Answer ANY FIVE Questions. (5x4=20)
1. Explain the concept of a primary key in an RDBMS and its significance in
database design.
2. Describe the process of normalization in the context of RDBMS and its role
in improving data integrity.
3. List out the components of RDBMS and explain them briefly.
4. Explain the purpose of the SQL SELECT statement in an RDBMS and how it
is used to retrieve data from tables.
5. What is the difference between a one-to-many and a many-to-many
relationship in a relational database? Provide examples of each.
6. Describe the significance of the crow's foot notation in ERD and provide an
example of how it is used to represent a relationship.
7. Explain the purpose of the SQL JOIN operation and provide examples of
scenarios where different types of joins are applicable.
