(Solved):   database sql The relational schema shown below is part of a student database. The primar ...

 

database

sql

The relational schema shown below is part of a student database. The primary and foreign keys are highlighted in bold. Student (studno, studName, address, mobileno) Course (courseNo, courseName, credithour, level) Registration (studNo, courseNo, regDate, semester, session) Project (projNo, projName, courseNo) Assignment (projNo, studNo, startDate, dueDate, hoursSpent) Write SQL queries based on the student database given above: 1. Create tables \& constraints for the student database. 2. Insert some data into the tables to check that the tables created are correct. No limit on how many rows you want to add. Insert Syntax: insert into table_name values (col1_value, col2_value, ..., coln_value); 3. List all the students' details, alphabetically by name.