Assignment: Integrated Enterprise Systems
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.
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.
Question 3
Draw Context Level DFD from the given Level 0 DFD.
