Reference no: EM131065769
The Assignment:
Design a "good" entity-relationship diagram that describes the following objects in an university application: students, instructors, professors, and courses. Students are subdivided into graduate and undergraduate students. Students take a course in a particular semester and receive a grade for their performance. Sometimes students take the same course again in a different semester. There are no limits on how many courses a student can take, and on how many students completed a particular course. Each graduate student has exactly one advisor, who must be a professor, whereas each professor is allowed to be the advisor of at most 20 students. Courses have a unique course number and a course title. Students and professors have a name and a unique ssn; students additionally have a gpa; moreover, graduate students have a GRE-score, and undergraduate students have a single or multiple majors. Professors can be students and take courses, but graduate students cannot be undergraduate students.
Draw an entity-relationship model to represent the library.
Indicate the cardinalities for each relationship type;
assign roles (role names) to each relationship if there are ambiguities
Use sub-types, if helpful to express constraints.
Purposes:
Ensure that you can analyze existing manual system and can draw Entity Relationship Diagrams (ERD) of any proposed system.
Before Starting:
An Entity Relationship Diagram
The entity relationship enables a software engineer to fully to fully specify the data objects that are input and output from a system the attributes that define the properties of these objects, and their relationships
Guidelines to make ERD
The ERD is constructed in an iterative manner. The following approach is taken.
1.During requirement elicitation, customer are asked to list the "things" that the application or business process addresses. These "things" evolve into a list of input and output data objects as well as external entities that produce or consume information.
2. Taking the objects one at a time, the analyst and customer define whether or not a connection exists between the data objects and other objects.
3.Whether a connection exists, the analyst and the customer create one ore more object/relationship pairs.
4. For each object/relationship pair, cardinality and modality are explored.
- . Steps 2 through 4 are continued iteratively until all object/relationships have been defined. It is common to discover omissions as this process continues. New objects and relationships will invariably be added as the number of iterations grows.
- The attributes of each entity are defined.
- An entity relationship diagram is formalized and reviewed.
- Steps 1 through 7 are repeated until data modeling is complete.
Note: Try to solve assignment your self if it is found that your assignment is copied with other student. Then both assignments marked as zero. Don't put assignment related question on MDB. For any further quarries about assignments mail at :
No assignment will be accepted after due date via email.
|
Annual rates charged by these two credit cards
: Two credit cards both state an APR of 10%. First National Bank’s card charges 0.8333% compounded monthly. First United Bank’s card charges 5% compounded semiannually (twice a year). Given these APR’s, what are the effective annual rates charged by th..
|
|
Where they hope to achieve and to be
: External environment analysis is focuses on factors outside the chosen company (not on company), the trend of these factors, their forecast implication and their impact on the company as Opportunity or Threat - and thus, these become the issues wh..
|
|
What is the current stock price
: Marcel Co. is growing quickly. The company just paid a dividend of $2.00. Dividends are expected to grow at a 25% rate for the next three years, with the growth rate falling off to a constant 5% thereafter. If the required return is 7%, what is the c..
|
|
Coupon bonds on the market
: Lycan Inc. has 7.5% coupon bonds on the market that have 18 years left to maturity and a face value of $1,000. The bonds make annual payments. If the yield to maturity on these bonds is 4.25%, what is the current bond price?
|
|
Application or business process addresses
: During requirement elicitation, customer are asked to list the "things" that the application or business process addresses. These "things" evolve into a list of input and output data objects as well as external entities that produce or consume inf..
|
|
Production and estimates the following annual costs
: Golden Manufacturers has performed extensive studies on its costs and production and estimates the following annual costs based on 150,000 units (produced and sold).
|
|
Estimate the cash flows involved in the project
: How would the decision above be affected if the firm's bond rating was reduced and its cost of capital changed to 10 per cent?
|
|
Suppose that put options on stock with strike prices
: Suppose that put options on a stock with strike prices $45 and $55 cost $5 and $9, respectively. Use these options to create a bear spread. At what stock price at maturity will you break even? In other words, at what stock price, will you make $0 pro..
|
|
Referred to as the firm opportunity cost of capital
: The Firm's cost of capital may also be referred to as the firm's opportunity cost of capital. Corporations have two costs of common equity, one for retained earnings and one if the company issues new stock. A security with a reasonably stable price w..
|