i. Write a SQL command to display the records in ascending order by date of exam.

Question

Consider the following Vendor table and write the queries for the following:

Table Datesheet

Sub_code	Sub_Name	Date of Exam	Days
E001	English	11-03-2021	Monday
H002	Hindi	15-03-2021	Friday
S003	Social Sci.	18-03-2021	Monday
S004	Science	21-03-2021	Thursday

i. Write a SQL command to display the records in ascending order by date of exam. 

ii. Write a query to display the above date sheet. 

iii. Write a query to display the subject name and date of the exam held on ‘Monday’ 

iv. Write a SQL command to display the date of exam and Sub_Name of Science subject.

For visually impaired candidates.

Write a short note on the following: 

i) DBMS 

ii) Database Server 

iii) Data Integrity 

iv) Record

Answer 1

i. Select*from Datesheet order by DateofExam 

ii. Select*from Datesheet 

iii. Select Sub_Name, DateofExam from Datesheet where Days= ‘Monday’ 

iv. Select Sub_Name, Date of Exam from Datesheet where Sub_Name = ‘Science’

For visually impaired candidates.

i) A database management system is a software package with computer programs that controls the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications. A database is an integrated collection of data records, files, and other objects. A DBMS allows different user application programs to concurrently access the same database. Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, Microsoft Access, PostgreSQL, MySQL, FoxPro, and SQLite. 

ii) Database servers are dedicated computers that hold the actual databases and run only the DBMS and related software. Typically databases available on the database servers are accessed through command line or graphic user interface tools referred to as Frontends; database servers are referred to as Back-ends. Such type of data access is referred to as a client server model. 

iii) Data integrity means that the data is accurate and consistent in the database. Data Integrity is very important as there are multiple databases in a DBMS. All of these databases contain data that is visible to multiple users. 

iv) A record is a set of information (made up of fields) stored in your database about one of the items.