Question

Describe the functions provided by a relational database that could be used to record courses taken by university students in order to manage scheduling and preparing transcripts.

Please respond with 200-250 words. Thanks

Answer 1

The functions provided by a relational database that could be used to record courses taken by university students i order to manage scheduling and preparing transcripts are:

• Create Database: Firest we create a new database by following function,

      CREATE DATABASE University;

• Select Database: When we have multiple databases in our SQL Schema, then before starting operation, we would need to select a database where all the operations would be performed.

      USE University;

• Create Table: Then, we create a table to insert records.

CREATE TABLE COURSES(
   ID   INT              NOT NULL,
   NAME VARCHAR (20)     NOT NULL,
   SCHEDULE  DATE        NOT NULL, 
   PRIMARY KEY (ID)
);

• INSERT INTO: INSERT INTO Statement is used to add new rows of data to a table in the database.

INSERT INTO COURSES(ID,NAME,Schedule)
VALUES (1, 'BCA', 'Jan-10-2017' );

INSERT INTO COURSES(ID,NAME,Schedule)
VALUES (1, 'MCA', 'Jan-11-2017' );

INSERT INTO COURSES(ID,NAME,Schedule)
VALUES (1, 'BTech', 'Jan-18-2017' );

INSERT INTO COURSES(ID,NAME,Schedule)
VALUES (1, 'MTech', 'Jan-20-2017' );

INSERT INTO COURSES(ID,NAME,Schedule)
VALUES (1, 'BCA', 'Jan-16-2017' );

INSERT INTO COURSES(ID,NAME,Schedule)
VALUES (1, 'MCA', 'Jan-25-2017' );

• LIKE: The LIKE operator is used to search for a specified pattern in a column.

SELECT * FROM COURSES
WHERE NAME LIKE 'MC%';