logo

Job1 Assignment Solution - Relational Model, Integrity Constraints, Queries, SQL, Views, Active Rules

6 Pages778 Words332 Views
   

Added on  2019-09-26

About This Document

This article provides a solution to Job1 Assignment covering topics like Relational Model, Integrity Constraints, Queries, SQL, Views, Active Rules. It includes Predicate Logic of Schema, Relational Calculus, and more.

Job1 Assignment Solution - Relational Model, Integrity Constraints, Queries, SQL, Views, Active Rules

   Added on 2019-09-26

ShareRelated Documents
Student 1 OCTOBER, 2016JOB1 ASSIGNMENT SOLUTION
Job1 Assignment Solution - Relational Model, Integrity Constraints, Queries, SQL, Views, Active Rules_1
CONTENTSRELATIONAL MODEL..................................................................................................2INTEGRITY CONSTRAINTS........................................................................................3PREDICATE LOGIC OF SCHEMA..............................................................................3QUERIES......................................................................................................................4SQL...........................................................................................................................4RELATIONAL CALCULUS........................................................................................4VIEWS..........................................................................................................................4ACTIVE RULES............................................................................................................51 | Page
Job1 Assignment Solution - Relational Model, Integrity Constraints, Queries, SQL, Views, Active Rules_2
RELATIONAL MODELPredicate schema is:Student (number, name, degree)Course (code, cname)Term (name, student_number, Course_code)The relational schema is:STUDENTNUMBERNAMEDEGREECOURSECODECNAMETERMName STUDENT_NUMBERCOURSE_CODEIn the above diagram we can see that through the ER diagram, 3 tables have been designed 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 to identify 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 number and course code to identify which student has which course in each term. This 2 | Page
Job1 Assignment Solution - Relational Model, Integrity Constraints, Queries, SQL, Views, Active Rules_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Relational Model | Purpose Of Normalization | Assignment
|6
|1075
|249

Answers To Question Number - 1
|9
|1687
|27

Fundamentals On Database Question and Answer 2022
|6
|616
|26

Collection of Logically Related Data - Desklib
|6
|563
|99

Assignment on DBMS Architecture
|6
|1843
|16

Course Title and Code:.
|5
|645
|1