Assignment 2 - Originating Facility Terminating Facility...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Originating Facility Terminating Facility OCH TCH Area OFC STN State Start Time End Time Trunk_Channels PortID Channel State Trunk_Routes Port_ID Area Office Routes N N Service_Subscribers LineId ServiceCode N N Subscribers PortID Name Address Email Subscribe To 1 1 Forward To 1 1 Connect To 1 N Club Stats ID Points Earned Match Result Goals Fouls Yellow/Red Cards Ball Possession Match Match Number Location Date Result Referee SIN Name Address Experience(Years) Play 1 20 Match Played In 1 1 Employees Employs 1 N Has 1 N Match Stats Generates 1 1 Officiated By 1 5 Results In 1 1 Points Table Position Number Games Played Goals For Goals Against Goal Difference Points 1 N Name: Sanat Dixit Student Number: 100775970 Part 1 Practice Questions Problem 1A Foreign Keys and E-R Diagram Table SERVICE_SUBSCRIBERS attribute LINEID references Table LINES attribute STATIONCODE Table SERVICE_SUBSCRIBERS attribute SERVICECODE references Table SERVICES attribute SCODE Table CALL_FORWARD_NUMBERS attribute PORTID references Table SUBSCRIBERS attribute PORTID Table SUBSCRIBERS attribute PORTID references TABLE LINES attribute PORTID Table CALLS attribute ORIGINATING_FACILITY references Table FACILITIES attribute PORTID Table CALLS attribute TERMINATING_FACILITY references Table FACILITIES attribute PORTID Table CALLS attribute OCH references Table TRUNK_CHANNELS attribute CHANNEL Table CALLS attribute TCH references Table TRUNK_CHANNELS attribute CHANNEL E-R Diagram Problem 1B: Relational Algebra Queries 1) A Name, Area Code, Office Code, Station Code (SUBSCRIBERS (SUBSCRIBERS.PortID = LINES.PortID) LINES) 2) B Name, Address, Email (SUBSCRIBERS (PortID = LineID) AND (ServiceCode = CW) SERVICE_SUBSCRIBERS) 3) C PortID, Foriegn_Switch(TRUNKS ((TRUNKS.PortID = TRUNK_CHANNELS.PortID) AND (State = Busy)) TRUNK_CHANNELS) 4) TEMP Call_ID, Name (CALLS (CALLS.Originating Facility = SUBSCRIBERS.PortID) SUBSCRIBERS) TEMP2 Call_ID, Name (CALLS (CALLS. Terminating Facility = SUBSCRIBERS.PortID) SUBSCRIBERS) D(Originator, Terminator) TEMP.Name, TEMP2.Name (TEMP (TEMP.Call_ID = TEMP2.Call_ID) TEMP2) 5) TEMP PortID (CALL_FORWARD_NUMBERS (PortID = LineID) AND ((ServiceCode CFD ) OR (ServiceCode CFB ) OR (ServiceCode CFN )) SERVICE_SUBSCRIBERS) E (TEMP (TEMP.PortID = Lines.PortID) LINES) 6) F Area Code, Office Code, Station Code (CALLS (Call_ID = 101) AND (Terminating Facility = PortID) CALL_FORWARD_NUMBERS) 7) IDLE (CALLS (Call_ID = 202) AND (OFC = Office Code = 235) AND (STN = Station Code = 7667) AND (State = Idle) LINES) BUSY (CALLS (Call_ID = 202) AND (OFC = Office Code = 235) AND (STN = Station Code = 7667)...
View Full Document

Page1 / 12

Assignment 2 - Originating Facility Terminating Facility...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online