IEOR 115: Homework 1

IEOR 115: Homework 1

Ascribable on Sept 15, 2014
Learner Spectry:
Learner ID:
Submitted on:
PROBLEM 1 IEOR 115 (Fintegral 2014): Homework 1
Problem 1
Consider the aftercited be of requirements control a UNIVERSITY basisbase that is portraitured to tend trail of learners
transcripts. This is resembling excluding referable attributconducive attributconducive attributconducive particular to the basisbase shown in Figure 1:
1. The university tends trail of each learners spectry, learner estimate, Social Security estimate, current
oration and phsingle estimate, beaming oration and phsingle estimate, nobility epoch, sex, ruleatize (freshman,
sophomore, …, furrow), superior function, younger function (if any), and step program (B.A.,
B.S., …, Ph.D.). Some portraiturer applications deficiency to connect to the city, specify, and ZIP Mode of the learners
beaming oration and to the learners developed spectry. Both Social Security estimate and learner estimate
confirm worthy prizes control each learner.
2. Each function is feeling by a spectry, function mode, function estimate, function phsingle estimate, and
college. Both specfathom and mode confirm worthy prizes control each function.
3. Each regulate has a regulate spectry, cognomen, regulate estimate, estimate of semester hours, flatten, and
offering function. The prize of the regulate estimate is worthy control each regulate.
4. Each minority has an pedagogue, semester, year, regulate, and minority estimate. The minority estimate
distinguishes minoritys of the corresponding regulate that are taught during the corresponding semester/year; its prizes are
1, 2, 3, …, up to the estimate of minoritys taught during each semester.
5. A trice innovatings has a learner, minority, message trice, and numeric trice (0, 1, 2, 3, or 4).
Create ER Diagram, registering integral cardinality constraints and assumptions
Page 1 of 9
PROBLEM 1 IEOR 115 (Fintegral 2014): Homework 1
Figure 1: Problem 1 Page 2 of 9
PROBLEM 1 IEOR 115 (Fintegral 2014): Homework 1
Problem 1 Solution:
Page 3 of 9
PROBLEM 2 IEOR 115 (Fintegral 2014): Homework 1
Problem 2
Consider a CONFERENCE REVIEW basisbase in which explorationers yield their exploration tracts control motive. Revisals by revisalers are chroniclesed control portraiture in the tract adoption passage. The basisbase rule
caters primarily to revisalers who chronicles answers to evaluation questions control each tract they revisal and make
recommendations concerning whether to confirm or decline the tract. The basis requirements are summarized
as follows:
• Composers of tracts are worthyly verified by e-mail id. Main and developed spectrys are as-courteous chroniclesed.
• Each tract is assigned a worthy identifier by the rule and is feeling by a style, unembodied, and the
specfathom of the electronic finish containing the tract.
• A tract may confirm multiple composers, excluding single of the composers is indicated as the continuity composer.
• Revisalers of tracts are worthyly verified by e-mail oration. Each revisalers main spectry, developed spectry,
phsingle estimate, burst, and headics of profit are as-courteous chroniclesed.
• Each tract is assigned among span and indecent revisalers. A revisaler rates each tract assigned to him
or her on a layer of 1 to 10 in indecent categories: technical worthiness, readability, originality, and association to
the parley. Decisively, each revisaler provides an overintegral advice concerning each tract.
• Each revisal contains span types of written comments: single to be seen by the revisal committee solely
and the other as feedback to the composer(s).
Create ER Diagram, registering integral cardinality constraints and assumptions
Page 4 of 9
PROBLEM 2 IEOR 115 (Fintegral 2014): Homework 1
Problem 2 Solution:
Page 5 of 9
PROBLEM 3 IEOR 115 (Fintegral 2014): Homework 1
Problem 3
Authenticate integral the main concepts represented in the library basisbase plight consider feeling underneath. In
particular, authenticate the unembodiedions of ruleatizeification (being types and entiretyiance types), incorporation, identification, and specialization/generalization. Specify (min, max) cardinality constraints whenever practicable.
Register details that entiretyure influence the eventual cunning excluding that confirm no passage on the conceptual cunning. Register the
semantic constraints partially. Draw an EER diagram of the library basisbase.
Plight Consider:
The UC Berkeley Library has closely 16,000 portions, 100,000 styles, and 250,000 volumes (an average
of 2.5 copies per size). Abextinguished 10 percent of the volumes are extinguished on advance at any single season. The librarians
ensure that the sizes that portions omission to hypothecate are advantageous when the portions omission to hypothecate them.
Also, the librarians must apprehend how multifarious copies of each size are in the library or extinguished on advance at any given
time.
A catalog of sizes is advantageous online that registers sizes by composer, style, and headic area. Control each style
in the library, a size cognomen is kept in the catalog that ranges from single phrase to divergent pages. The
regard librarians omission to be conducive to bearing this cognomen when portions beg comprehendledge abextinguished a
book. Library staff includes main librarian, functional consort librarians, connectence librarians, bridle-out
staff, and library assistants.
Books can be bridleed extinguished control 21 days.Members are integralowed to confirm solely five sizes extinguished at a season. Portions
usually restore sizes amid three to indecent weeks.Most portions apprehend that they confirm single week of excellence antecedently
a referable attributconducive attributableice is sent to them, so they fathom to restore sizes antecedently the excellence end ends. Abextinguished 5 percent of the
members confirm to be sent reminders to restore sizes. Most overascribable sizes are restoreed amid a month of
the ascribable epoch.
Closely 5 percent of the overascribable sizes are either kept or never restoreed. The most free portions
of the library are defined as those who hypothecate sizes at meanest ten seasons during the year. The head 1 percent
of partnership does 15 percent of the hypothecateing, and the head 10 percent of the partnership does 40 percent
of the hypothecateing. Abextinguished 20 percent of the portions are wholly infree in that they are portions who never
borrow.
To beseem a portion of the library, applicants content extinguished a controlm including their SSN, campus and home
mailing orationes, and phsingle estimates. The librarians consequence a estimateed, machine-readconducive card with the
members photo on it. This card is amiable control indecent years. A month antecedently a card expires, a referable attributconducive attributableice is sent to
a portion control renewal. Professors at the establish are considered unreflective portions. When a innovating faculty
portion joins the establish, his or her comprehendledge is pulled from the employee chronicless and a library card is
mailed to his or her campus oration. Professors are integralowed to bridle extinguished sizes control three-month intervals
and confirm a span-week excellence end. Renewal referable attributconducive attributableices to professors are sent to their campus oration.
The library does referable attributconducive attributconducive attributconducive present some sizes, such as connectence sizes, worthy sizes, and maps. The librarians
must disseminate among sizes that can be lent and those that canreferable attributconducive be lent. In attention, the librarians
confirm a register of some sizes they are profited in acquiring excluding canreferable attributconducive entiretyure, such as worthy or extinguishedof- print
books and sizes that were obsolete or destroyed excluding confirm referable attributconducive attributconducive attributconducive been replaced. The librarians must confirm a rule
that tends trail of sizes that canreferable attributconducive be lent as courteous as sizes that they are profited in acquiring. Some
books may confirm the corresponding style; consequently, the style canreferable attributconducive be portraitured as a media of identification. Every size
is verified by its Interpolitical Standard Size Estimate (ISBN), a worthy interpolitical mode assigned to integral
books. Span sizes with the corresponding style can confirm divergent ISBNs if they are in divergent languages or confirm
divergent bindings (hardcover or softcover). Editions of the corresponding size confirm divergent ISBNs.
The planned basisbase rule must be cunninged to tend trail of the portions, the sizes, the catalog,
and the hypothecateing activity.
Create EER Diagram, registering integral cardinality constraints and assumptions.
Page 6 of 9
PROBLEM 3 IEOR 115 (Fintegral 2014): Homework 1
Problem 3 Solution:
Page 7 of 9
PROBLEM 4 IEOR 115 (Fintegral 2014): Homework 1
Problem 4
Consider a GRADE BOOK basisbase in which pedagogues amid an academic function chronicles points
earned by special learners in their ruleatizees. The basis requirements are summarized as follows:
• Each learner is verified by a worthy identifier, main and developed spectry, and an e-mail oration.
• Each pedagogue teaches unfailing regulates each account. Each regulate is verified by a regulate estimate, a
minority estimate, and the account in which it is taught. Control each regulate he or she teaches, the pedagogue
specifies the minimum estimate of points required in regulate to merit message trices A, B, C, D, and F. Control
example, 90 points control an A, 80 points control a B, 70 points control a C, and so controlth.
• Learners are enrolled in each regulate taught by the pedagogue.
• Each regulate has a estimate of grading constituents (such as midaccount exam, decisive exam, contrivance, and so
forth). Each grading constituent has a ultimatum estimate of points (such as 100 or 50) and a impressiveness
(such as 20% or 10%). The impressivenesss of integral the grading constituents of a regulate usually entirety 100.
• Decisively, the pedagogue chronicless the points merited by each learner in each of the grading constituents
in each of the regulates. Control stance, learner 1234 merits 84 points control the midaccount exam grading
constituent of the minority 2 regulate CSc2310 in the fintegral account of 2009. The midaccount exam grading
constituent may confirm been defined to confirm a ultimatum of 100 points and a impressiveness of 20% of the regulate
grade.
Create EER Diagram, registering integral cardinality constraints and assumptions
Page 8 of 9
PROBLEM 4 IEOR 115 (Fintegral 2014): Homework 1
Problem 4 Solution:
Page 9 of 9