The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010 Industrial Engineering and Modern Logistics Name:
Fall 20XX, Exam I
SID:
Max time: 2 Hours, Max Score: 100
Q1.
[15]
A furniture manufacturer makes three basic products: table, desk, and chair, using three
different types of wood: teak, ash and o
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
Homework 1 Solution
IELM 3300
FALL 2015
Due Date: 1:30 pm, Oct 2 (Friday), 2015
Q1. (30pts.) Draw the ER diagram for the following description of a database. Make sure your
ER diagram has all specifications, including (a) Key attributes for each entity; (
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
Basic Relational Model
Outline
Relational Data Model Concepts
Relational Model Constraints
Update Operations and Dealing with
Constraint Violation
Relational Model Concepts
Concept: Relation
Represents data as a collection of relations
Table of valu
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
Map a Conceptual Design to a
Logical Design
Outline
A 7step Algorithm to convert ER
diagram into relation schema
We#want#to#create# tables #with#simple#single3valued#a7ributes.#
how would you use excel
spreadsheet to represent all
the information?
Step1:
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 3300: Industrial Data Systems
FALL 2016
Homework 1
Due Date: 5pm, Oct 3, 2016
Q1. (30pts.) Draw the ER diagram for the following description of a database. Make sure your
ER diagram has all specifications, including (a) Key attributes for each entity
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010. Industrial Engineering & Modern Logistics
Spring 2015, Assignment 6. Due Date: May 5 Max score: 10
Q1. EOQ models
[2]
(a) Suppose that the Atlaya online store sells approximately 600 bottles per week of a
Pinot Noir wine at a constant steady ra
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010. Industrial Engineering & Modern Logistics
Spring 2015, Assignment 3. Due: March 13. Max score: 10
Q1. Maximum flow in Networks
[4]
The graph below shows the electrical power flow problem introduced in the lecture notes. Using the
FordFulkerson
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010. Industrial Engineering & Modern Logistics
Spring 2015, Assignment 5. Due Date: April 16 Max score: 10
Q1. Basics of probability
[2+2=4]
(a) Using Microsoft excel, plot three histograms for the possible values of a random variable
X1, X2 and X3,
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010. Industrial Engineering & Modern Logistics
Spring 2015, Assignment 1. Due: Feb 19. Max score: 10
Q1. Reading assignment
[1]*
Look up the description/reviews of the suggested readings books (use google and/or reviews on
Amazon.com) and identify t
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010. Industrial Engineering & Modern Logistics
Spring 2015, Assignment 6. Due Date: May 5 Max score: 10
Q1. EOQ models
[2]
(a) Suppose that the Atlaya online store sells approximately 600 bottles per week of a Pinot
Noir wine at a constant steady ra
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010. Industrial Engineering & Modern Logistics
Spring 2015, Assignment 2. Due: March 3. Max score: 10
Q1. Shortest paths
[2]
Google maps (maps.google.com) is a free facility that can give us possible ways to drive from one
point to another. Typicall
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010. Industrial Engineering & Modern Logistics
Spring 2015, Assignment 4. Due Date: March 22 Max score: 10
Q1. Linear programming basics
[4]
(a) Consider the system of equations. Plot the graph of these two equations to find the
solution.
x + 2y = 6
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010. Industrial Engineering & Modern Logistics
Spring 2015, Assignment 3. Due: March 13. Max score: 10
Q1. Maximum flow in Networks
[4]
The graph below shows the electrical power flow problem introduced in the lecture notes. Using the
FordFulkerson
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010. Industrial Engineering & Modern Logistics
Spring 2015, Assignment 4. Due Date: March 22 Max score: 10
Q1. Linear programming basics
[4]
(a) Consider the system of equations. Plot the graph of these two equations to find the
solution.
x + 2y = 6
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010. Industrial Engineering & Modern Logistics
Spring 2015, Assignment 2. Due: March 3. Max score: 10
Q1. Shortest paths
[2]
Google maps (maps.google.com) is a free facility that can give us possible ways to drive from one
point to another. Typicall
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
IELM 2010. Industrial Engineering & Modern Logistics
Spring 2015, Assignment 1. Due: Feb 19. Max score: 10
Q1. Reading assignment
[1]*
Look up the description/reviews of the suggested readings books (use google and/or reviews on
Amazon.com) and identify t
The Hong Kong University of Science and Technology
IELM 101

Spring 2014
Conceptual Data Modeling
Outline
Phases for designing a database
A motivating example
The EntityRelationship (ER) Model
ER Diagram
Diagrammatic notation of the ER model
Phases for designing a database
Mini World
Requirements
collection and
analy