Pt1420 Unit 1 Assignment 1

Words: 644
Pages: 3

Assignment 1 Neha Jaiswal Gw8535
1.8 Answer:
(a) Query to retrieve the list of prerequisite.
(b) Query to list all the students.
(c) Query to retrieve an information (their majors, student number, Class). For example, query for Smith to get his (-- removed HTML --) .
(d) Query grade for student by using relational database by identifying his student number and section identifier.
(d) Insert a new student record in the database of students with required parameters. For example, StudentName = “Bob”, Class= 1 and Major (Computer Science).
(e) Update grade for student by making a master query on relational database by passing his student number and section identifier and updating the grade.

1.9 
Answer:
a) Relational data base has been created by using an id that is common to both. Here, every section consist of Course record that will have to query different tables.
…show more content…
(c) Perquisite contains two courses, one itself and another course as prerequisite to that course.
(d) Grade list has section identifier and grade. Another section identifier list has all attribute information (-- removed HTML --) . Here course number will be used as external key in the course list to retrieve information about course (-- removed HTML --) . We can use RDBMS to fetch these details in one single