Reference no: EM131065762
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.
a) Draw an entity-relationship model to represent the library.
b) Indicate the cardinalities for each relationship type;
c) Assign roles (role names) to each relationship if there are ambiguities
d) 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.
|
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..
|
|
Explain the difference in production
: The Animè Sushi Bar collects data on how many dragon rolls and sashimi are made per hour. Dragon rolls take longer to make than sashimi. What might explain the difference in production between Week 1 and Week 2?
|
|
Custom halloween company
: The Custom Halloween Company purchases a new sewing machine to replace an older machine with limited capabilities. The first week the new machine is used production nearly doubles. Which economic principle does this illustrate?
|
|
Analyze existing manual system
: Ensure that you can analyze existing manual system and can draw Entity Relationship Diagrams (ERD) of any proposed system.
|
|
How does this affect the amount you could capture
: In Argentina, if you do not reach an agreement with the government distributors, you can set up a less efficient Internet-baseddistribution system that would generate $20 million in value to you. How does this affect the amount you could capture?
|
|
What amount do you need to save per month to reach your goal
: You need $1,000,000 at age 65, you are 25 now and feel comfortable earning 7.4% per year, how much do you need to save each month to get there if you have nothing saved yet.? Round to the nearest dollar.
|
|
Determine the probability distribution missing value
: Determine the probability distribution's missing value. The probability that a tutor will see 0, 1, 2, 3, 4, 5, 6, 7 or 8 students on a given day
|
|
Create an argument in agreement or disagreement
: Create an argument in agreement or disagreement that the creation of the PCAOB has been effective with improving the reliability of audited financial statement for the public users of the information. Provide support for your position.
|