IEOR 115: Homework 1

IEOR 115: Homework 1

Imputable on Sept 15, 2014
Novice Intentionate:
Novice ID:
Submitted on:
PROBLEM 1 IEOR 115 (Fcomplete 2014): Homework 1
Problem 1
Consider the aftercited cemal of requirements ce a UNIVERSITY postulatesbase that is explanationd to obey vestige of novices
transcripts. This is resembling excluding referable attributable attributable attributable attributtelling attributtelling attributtelling selfcorresponding to the postulatesbase shown in Figure 1:
1. The university obeys vestige of each novices intentionate, novice sum, Social Security sum, current
oration and phundivided sum, enduring oration and phundivided sum, extraction end, sex, collocate (freshman,
sophomore, …, disequalize), main line, less line (if any), and stage program (B.A.,
B.S., …, Ph.D.). Some explanationr applications demand to friend to the city, avow, and ZIP Enactment of the novices
enduring oration and to the novices developed intentionate. Both Social Security sum and novice sum
own uncommon computes ce each novice.
2. Each line is cecible by a intentionate, line enactment, employment sum, employment phundivided sum, and
college. Both intentionate and enactment own uncommon computes ce each line.
3. Each succession has a succession intentionate, style, succession sum, sum of semester hours, plane, and
offering line. The compute of the succession sum is uncommon ce each succession.
4. Each personality has an preceptor, semester, year, succession, and personality sum. The personality sum
distinguishes personalitys of the corresponding succession that are taught during the corresponding semester/year; its computes are
1, 2, 3, …, up to the sum of personalitys taught during each semester.
5. A trice tidings has a novice, personality, referable attributable attributablee trice, and numeric trice (0, 1, 2, 3, or 4).
Create ER Diagram, inventorying complete cardinality constraints and assumptions
Page 1 of 9
PROBLEM 1 IEOR 115 (Fcomplete 2014): Homework 1
Figure 1: Problem 1 Page 2 of 9
PROBLEM 1 IEOR 115 (Fcomplete 2014): Homework 1
Problem 1 Solution:
Page 3 of 9
PROBLEM 2 IEOR 115 (Fcomplete 2014): Homework 1
Problem 2
Consider a CONFERENCE REVIEW postulatesbase in which inquiryers propose their inquiry tracts ce subsidy. Retrospects by retrospecters are recitative ce explanation in the tract gathering method. The postulatesbase method
caters largely to retrospecters who annals answers to evaluation questions ce each tract they retrospect and make
recommendations in-reference-to whether to sanction or repel the tract. The postulates requirements are summarized
as follows:
• Constructors of tracts are uncommsimply verified by e-mail id. Ceemost and developed intentionates are as-well-behaved recitative.
• Each tract is assigned a uncommon identifier by the method and is cecible by a epithet, pictureless, and the
designate of the electronic improve containing the tract.
• A tract may own multiple constructors, excluding undivided of the constructors is intentionated as the contiguity constructor.
• Retrospecters of tracts are uncommsimply verified by e-mail oration. Each retrospecters ceemost intentionate, developed intentionate,
phundivided sum, burst, and extremeics of share are as-well-behaved recitative.
• Each tract is assigned betwixt brace and indecent retrospecters. A retrospecter rates each tract assigned to him
or her on a flake of 1 to 10 in indecent categories: technical desert, readability, originality, and kindred to
the consultation. Vocableinally, each retrospecter provides an overcomplete admonition in-reference-to each tract.
• Each retrospect contains brace types of written comments: undivided to be seen by the retrospect committee simply
and the other as feedback to the constructor(s).
Create ER Diagram, inventorying complete cardinality constraints and assumptions
Page 4 of 9
PROBLEM 2 IEOR 115 (Fcomplete 2014): Homework 1
Problem 2 Solution:
Page 5 of 9
PROBLEM 3 IEOR 115 (Fcomplete 2014): Homework 1
Problem 3
Identify complete the great concepts represented in the library postulatesbase predicament consider cecible under. In
particular, identify the picturelessions of collocateification (being types and harmony types), conglomeration, identification, and specialization/generalization. Specify (min, max) cardinality constraints whenever practicable.
Inventory details that conquer concern the eventual intention excluding that own no aspect on the conceptual intention. Inventory the
semantic constraints partially. Draw an EER diagram of the library postulatesbase.
Predicament Consider:
The UC Berkeley Library has approximately 16,000 limbs, 100,000 epithets, and 250,000 volumes (an average
of 2.5 copies per tome). Abextinguished 10 percent of the volumes are extinguished on advance at any undivided end. The librarians
ensure that the tomes that limbs nonproduction to attribute are suited when the limbs nonproduction to attribute them.
Also, the librarians must recognize how divers copies of each tome are in the library or extinguished on advance at any given
time.
A catalog of tomes is suited online that inventorys tomes by constructor, epithet, and theme area. Ce each epithet
in the library, a tome style is kept in the catalog that ranges from undivided judgment to irrelative pages. The
intimation librarians nonproduction to be telling to access this style when limbs beseech referable attributable attributableification abextinguished a
book. Library staff includes ceemost librarian, lineal friend librarians, friendence librarians, hinder-out
staff, and library assistants.
Books can be hindered extinguished ce 21 days.Members are completeowed to own simply five tomes extinguished at a end. Limbs
usually come-back tomes amid three to indecent weeks.Most limbs recognize that they own undivided week of favor anteriorly
a referable attributable attributable attributable attributtelling attributableice is sent to them, so they aim to come-back tomes anteriorly the favor limit ends. Abextinguished 5 percent of the
members own to be sent reminders to come-back tomes. Most overimputable tomes are come-backed amid a month of
the imputable end.
Approximately 5 percent of the overimputable tomes are either kept or never come-backed. The most free limbs
of the library are defined as those who attribute tomes at conclusive ten ends during the year. The extreme 1 percent
of friendship does 15 percent of the attributeing, and the extreme 10 percent of the friendship does 40 percent
of the attributeing. Abextinguished 20 percent of the limbs are quite infree in that they are limbs who never
borrow.
To behove a limb of the library, applicants grow extinguished a cem including their SSN, campus and home
mailing orationes, and phundivided sums. The librarians consequence a sumed, machine-readtelling card with the
members photo on it. This card is good-natured-natured ce indecent years. A month anteriorly a card expires, a referable attributable attributable attributable attributtelling attributableice is sent to
a limb ce operation. Professors at the found are considered spontaneous limbs. When a upstart faculty
limb joins the found, his or her referable attributable attributableification is pulled from the employee annalss and a library card is
mailed to his or her campus oration. Professors are completeowed to hinder extinguished tomes ce three-month intervals
and own a brace-week favor limit. Operation referable attributable attributable attributable attributtelling attributableices to professors are sent to their campus oration.
The library does referable attributable attributable attributable attributtelling attributtelling attributtelling present some tomes, such as friendence tomes, expensive tomes, and maps. The librarians
must segregate betwixt tomes that can be lent and those that canreferable attributable attributtelling be lent. In observation, the librarians
own a inventory of some tomes they are shareed in acquiring excluding canreferable attributable attributtelling achieve, such as expensive or extinguishedof- print
books and tomes that were obsolete or destroyed excluding own referable attributable attributable attributable attributtelling attributtelling attributtelling been replaced. The librarians must own a method
that obeys vestige of tomes that canreferable attributable attributtelling be lent as well-behaved-behaved as tomes that they are shareed in acquiring. Some
books may own the corresponding epithet; consequently, the epithet canreferable attributable attributtelling be explanationd as a resources of identification. Every tome
is verified by its Interpolitical Standard Tome Sum (ISBN), a uncommon interpolitical enactment assigned to complete
books. Brace tomes with the corresponding epithet can own irrelative ISBNs if they are in irrelative languages or own
irrelative bindings (hardcover or softcover). Editions of the corresponding tome own irrelative ISBNs.
The incomplete postulatesbase method must be intentioned to obey vestige of the limbs, the tomes, the catalog,
and the attributeing spectre.
Create EER Diagram, inventorying complete cardinality constraints and assumptions.
Page 6 of 9
PROBLEM 3 IEOR 115 (Fcomplete 2014): Homework 1
Problem 3 Solution:
Page 7 of 9
PROBLEM 4 IEOR 115 (Fcomplete 2014): Homework 1
Problem 4
Consider a GRADE BOOK postulatesbase in which preceptors amid an academic line annals points
earned by personal novices in their collocatees. The postulates requirements are summarized as follows:
• Each novice is verified by a uncommon identifier, ceemost and developed intentionate, and an e-mail oration.
• Each preceptor teaches true successions each message. Each succession is verified by a succession sum, a
individuality sum, and the message in which it is taught. Ce each succession he or she teaches, the preceptor
specifies the restriction sum of points required in prescribe to win referable attributable attributablee trices A, B, C, D, and F. Ce
example, 90 points ce an A, 80 points ce a B, 70 points ce a C, and so ceth.
• Novices are enrolled in each succession taught by the preceptor.
• Each succession has a sum of grading ingredients (such as midmessage exam, vocableinal exam, plan, and so
forth). Each grading ingredient has a consummation sum of points (such as 100 or 50) and a influence
(such as 20% or 10%). The influences of complete the grading ingredients of a succession usually whole 100.
• Vocableinally, the preceptor annalss the points wined by each novice in each of the grading ingredients
in each of the successions. Ce pattern, novice 1234 wins 84 points ce the midmessage exam grading
ingredient of the personality 2 succession CSc2310 in the fcomplete message of 2009. The midmessage exam grading
ingredient may own been defined to own a consummation of 100 points and a influence of 20% of the succession
grade.
Create EER Diagram, inventorying complete cardinality constraints and assumptions
Page 8 of 9
PROBLEM 4 IEOR 115 (Fcomplete 2014): Homework 1
Problem 4 Solution:
Page 9 of 9