Which of the following decisions would be part of Physical Database Design?Student data and enrollment data will be stored in two different tablesAn index file will be created on the last name of students in the Student tableThe Social Security number will be chosen as the primary key of the Student tableStudent data and enrollment data will be stored in two different tables at two different locationsReview AnswerNext

Possibility High School maintains a database containing tables related to its students and the subjects offered. Which of the following represents a table within the database?*1 pointa student's namea student's recordall the personal data on studentsthe age of a student

Question 8In the following student table, which attribute could be used as a primary key?Student first nameStudent last nameMobile numberCarl Merlo07445532123MarkNero074565323271 pointStudent last nameMobile numberStudent first name

Which item should be used as a primary key in a student database?*1 pointfirst nameidentification numberlast nameage

Describe the differences between logical and physical database design. Discuss the objectives of logical design, such as minimizing redundancy and improving data integrity, and the considerations involved in physical design, such as storage allocation and indexing.

Read the passage and answer the following questions:A School in Delhi uses database management system to store student details. The school maintains a database ‘school_record’ under which there are two tables.Student Table : Maintains general details about every student enrolled in school.StuLibrary Table : To store details of issued books. BookID is the unique identification number issued to each book. Minimum issue duration of a book is one Day.Identify the SQL Query which displays the data of StuLibrary table in ascending order of StudentID*1 pointSelect * from StuLibrary Order By BookID;Select * from StuLibrary Group By StuID;Select * from StuLibrary Order By StuID ASC;Select * from StuLibrary Order By StuID DESC;The Primary Key for StuLibrary Table is/are*1 pointBookIDBookID, StuIDBookID, Issued_dateIssued_dateWhich of the following SQL Query will fetch ID of those issued books which have not been returned?*1 pointSELECT BookID from StuLibrary where BookID is NULL;SELECT BookID from StuLibrary where StuID is NULL;SELECT BookID from StuLibrary where Issued_date is NULL;SELECT BookID from StuLibrary where Return_date is NULL;The Alternate Key for Student Table will be*1 pointStuNameStuContactStuAadharStuClassBackSubmitClear form