Database fundamentals UE Past Papers Questions.

What is the long form of the following terms as applied in database

• DML
• DDL
• SQL

Answer / Solution

Briefly explain with examples

• DML
• DDL

Answer / Solution

Consider the following database schema  and answer the following questions

Professor (SSN, firstname, middlename, lastname, salary, rank)

Project(Pid, SSN, Title, startyear, location, amount, sponseredBy)

Student(regno, SSN, Firstname, middlename, lastname, yearofstudy, pid)

• Write SQL statement to create a database with a name UniversityProjects
• Write SQL statement to create the professor, project and student tables. Then assign primary key for each table.

Answer / Solution