IE 6700 Data Management for Analytics
Final Examination
(120 minutes)
Points
Problem 1 25
Problem 2 25
Problem 3 30
Problem 4 20
Total 100
Instructions:
• This exam is a close-book, close-note exam. Books and notes are NOT allowed.
• A two-page (two sheets of standard A4 paper, both sides) cheat sheet is allowed.
• Electronics of any kind (smartphones, laptop computers, tablets, calculators, etc.) is NOT
allowed.
• Write your answer neatly, clearly, and legibly with good organization.
• Keep your exam sheet and answers to yourself. Peeking, copying, and sharing are strictly
prohibited.
• Write your name on the exam sheet.
• Trips to restrooms must be short and unaccompanied by smartphones, laptop computers, and
tablets.
• Upon completion, please sign the following honor code, organize your answer and the
signed honor code.
Please Sign the Honor Code: On my honor, I pledge to uphold the values of honesty, integrity, and respect that
are expected of me as a Northeastern student.
Student Name: _________________________________________
Signature: _________________________________________
1
, IE 6700 Data Management for Analytics
Problem 1. The following diagram is an ER model for a course administration with minimal and maximum
cardinalities specified.
a. [20 points] Map this ER model to a relational model presentation. Clearly indicate the primary-
foreign key relationships and specify NOT NULL or NULL ALLOWED declarations wherever
necessary
2
Final Examination
(120 minutes)
Points
Problem 1 25
Problem 2 25
Problem 3 30
Problem 4 20
Total 100
Instructions:
• This exam is a close-book, close-note exam. Books and notes are NOT allowed.
• A two-page (two sheets of standard A4 paper, both sides) cheat sheet is allowed.
• Electronics of any kind (smartphones, laptop computers, tablets, calculators, etc.) is NOT
allowed.
• Write your answer neatly, clearly, and legibly with good organization.
• Keep your exam sheet and answers to yourself. Peeking, copying, and sharing are strictly
prohibited.
• Write your name on the exam sheet.
• Trips to restrooms must be short and unaccompanied by smartphones, laptop computers, and
tablets.
• Upon completion, please sign the following honor code, organize your answer and the
signed honor code.
Please Sign the Honor Code: On my honor, I pledge to uphold the values of honesty, integrity, and respect that
are expected of me as a Northeastern student.
Student Name: _________________________________________
Signature: _________________________________________
1
, IE 6700 Data Management for Analytics
Problem 1. The following diagram is an ER model for a course administration with minimal and maximum
cardinalities specified.
a. [20 points] Map this ER model to a relational model presentation. Clearly indicate the primary-
foreign key relationships and specify NOT NULL or NULL ALLOWED declarations wherever
necessary
2
