Limited-time offer! Save up to 50% Off | Solutions starting at $6 each  

Student. 1 OCTOBER, 2016. job1 assignment solution. Stu

Added on - 25 Sep 2019

Trusted by +2 million users,
1000+ happy students everyday
Showing pages 1 to 3 of 6 pages
Student1 OCTOBER, 2016JOB1 ASSIGNMENT SOLUTION
CONTENTSRELATIONAL MODEL..................................................................................................2INTEGRITY CONSTRAINTS........................................................................................3PREDICATE LOGIC OF SCHEMA..............................................................................3QUERIES......................................................................................................................4SQL...........................................................................................................................4RELATIONAL CALCULUS........................................................................................4VIEWS..........................................................................................................................4ACTIVE RULES............................................................................................................51|Page
RELATIONAL MODELPredicate schema is:Student (number, name, degree)Course (code, cname)Term (name, student_number, Course_code)The relational schema is:STUDENTNUMBERNAMEDEGREECOURSECODECNAMETERMNameSTUDENT_NUMBERCOURSE_CODEIn the above diagram we can see that through the ER diagram, 3 tables have beendesigned in the relational model. In the first table student, number is a primary key toidentify each record uniquely. In the second table course, code is the primary key toidentify each record. And the third table ‘term’ has been designed to model the‘taking’ relation between the tables. The term table has term name student numberand course code to identify which student has which course in each term. This2|Page
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document