Comprehension Passage
Case study based question
An Educational Institute in Delhi make use of DBMS to store details of students. The institute maintains a database named 'school - record' under which there are two tables.
1. Student table : maintains general details of every student enrolled in the school
2. Stulibrary Table: To store the details of issued books.
* BookID is the unique identification number of each book.
* Minimum issue duration of a book is one day.
|
Student |
|
|
Field |
Type |
|
StuID |
Numeric |
|
StuName |
Varchar(20) |
|
StuAddress |
Varchar(50) |
|
StuFatherName |
Varchar(20) |
|
StuContact |
Numeric |
|
StuAadhar |
Numeric |
|
StuClass |
Varchar(5) |
|
StuSection |
Varchar(1) |
|
Stulibrary |
|
|
Field |
Type |
|
BookID |
Numeric |
|
StuID |
Numeric |
|
Issued_date |
Date |
|
Return_date |
Date |
The primary key of Stulibrary table is / are:
1
BookID
2
BookID, StuID
3
BookID, Issued date
4
Issued_date