IT 342

Pg. 01		Question One

( Assignment # 2 Deadline: Day 5 /1 1 /2017 @ 23:59 [Total Ma rk for this Assignment is 4 Marks ] ) ( Integrated Enterprise Systems IT342 )

( Instructions: This Assignment must be submitted on Blackboard via the allocated folder. Email submission will not be accepted. You are advised to make your work clear and well-presented , marks may be reduced for poor presentation . You MUST show all your work . Late submission will result in ZERO marks being awarded. The work should be your own, copying from students or other resources will result in ZERO marks . Use Times New Roman font for all your answers . ) ( Student Details: Name: ### CRN : ### ID: ### Mark : ### )

College of Computing and Informatics

( 2 0 Marks ) ( Learning Outcome(s): Convert a conceptual business process level REA model into a logical relational model. )Question One

Convert the Conceptual Model into Relational Model. Enter some example data into the relations. Your job is to decide whether to establish the relationship by posting a Foreign Key into the other table or create a separate table for the relationship. Give reason for your answer.

Answer:

( 10 Marks ) ( Learning Outcome(s): Create a SQL statement to retrieve requested information from a relational database. )Question Two

Consider the relations:

STUDENT

Student#	Std-Name	Address
1	Khan	Madina
2	Muhammad	Yanbu
3	Ahmad	Riyadh

COURSE

Student#	Course	Course-Name
1	IT342	Enterprise Systems
2	IT407	Professional Issues
2	IT445	DSS

Write a query using the Right Outer Join to retrieve the record from the two relations. Also, construct the table displaying the output of your query.

Answer:

( 10 Marks ) ( Learning Outcome(s): Describe and prepare data flow diagrams depicting the flow of data through an enterprise system. )Question Three

Draw Context Level DFD from the given Level 0 DFD.

Answer: