Given the following entities: Student, Class, Instructor,and student grade. List the business rules for each entity....
Given the following entities: Student, Class, Instructor,and student grade.
List the business rules for each entity.
include relationship type (example: 1:1, 1:M, M:N) for each entity.
Include Cardinality:
example:
the cardinality of X is (1, 1)
the cardinality of Y is (0, N)
Homework Answers
Add Answer to:
Given the following entities: Student, Class, Instructor,and
student grade.
List the business rules for each entity....
Consider this Entity-Relationship model, drawn for the following business rules. • A route is uniquely identified...
Consider this Entity-Relationship model, drawn for the following business rules. • A route is uniquely identified by a route number • A bus is uniquely identified by bus registration number • A route can have one or more busses assigned to it at any given time • A bus is assigned to only one route at any given time. • Not all busses are assigned to routes (some may undergo servicing or kept on reserve). Bus Route 0..1 RegNo {PK}...
Assume two entities ORDER and PRODUCT and the following business rules: An ORDER can contain one...
Assume two entities ORDER and PRODUCT and the following business rules: An ORDER can contain one or more PRODUCTs. A PROUDCT can be in zero or more ORDERs. How would you convert this model into an ERM that displays only 1:M relationships? Be specific and complete. Draw the resulting ERM. 2. What is the difference between entity integrity and referential integrity? Given an example of each. 3. Suppose you have an EMPLOYEE table which has one row per employee. The...
6- (15%) Assume that X= The final grade of a student in Stochastic Modeling class and...
6- (15%) Assume that X= The final grade of a student in Stochastic Modeling class and Y= The final grade of a student in Structural Analysis class. The joint probability of the grades earned by a student is P(X,Y) which is as follows. Structural Analysis Grades Stochastic Modeling Grades: 95, 80, 90, 0.2, 0.4, 75, 0.3, 0.1 How the grades of Stochastic and Structural Analysis classes are related to each other? (Positive, Negative or no relationship?) *Hint: No need for...
Q1.a) Based on the business rules, you are expected to construct an Entity-Relationship (ER) diagram. The...
Q1.a) Based on the business rules, you are expected to construct
an Entity-Relationship (ER) diagram. The ER diagram should include
entities, attributes (if there are less than three specified in the
business statements, please add some extra attributes), identifiers
and corresponding data types, the relationships among entities with
cardinality and associative entities.
.b) Extend Q1.a) to apply generalization/specialization
technique to construct an Enhanced-ER (EER) diagram. The EER
diagram should specify the complete (total) and disjoint
(mutuallyexclusive) constraints on the
generalization/specialization....
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The...
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The final grade of a student in Structural Analysis class The joint probability of the grades earned by a student is P(X,Y) which is as follows. Stochastic Modeling Grades 90 75 Structural Analysis Grades 95 0.2 0.3 80 0.4 0.1 How the grades of Stochastic and Structural Analysis classes are related to each other? (Positive, Negative or no relationship?) *Hint: No need for the final...
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The...
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The final grade of a student in Structural Analysis class The joint probability of the grades earned by a student is P(X,Y) which is as follows. Stochastic Modeling Grades Structural Analysis Grades 95 0.2 0.3 90 75 80 0.4 0.1 How the grades of Stochastic and Structural Analysis classes are related to each other? (Positive. Negative or no relationship?) *Hint: No need for the final...
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The...
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The final grade of a student in Structural Analysis class The joint probability of the grades earned by a student is P(X,Y) which is as follows. Stochastic Modeling Grades Structural Analysis Grades 95 0.2 0.3 90 75 80 0.4 0.1 How the grades of Stochastic and Structural Analysis classes are related to each other? (Positive. Negative or no relationship?) *Hint: No need for the final...
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The...
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The final grade of a student in Structural Analysis class The joint probability of the grades earned by a student is P(X,Y) which is as follows. Stochastic Modeling Grades Structural Analysis Grades 95 0.2 0.3 90 75 80 0.4 0.1 How the grades of Stochastic and Structural Analysis classes are related to each other? (Positive, Negative or no relationship?) *Hint: No need for the final...
New to DB's Please help! You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of...
New to DB's Please help!
You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of a Software Consulting Company to manage their employees and their assigned work (projects) in the company First Step to Design and Create a Database is Creating an E-R Diagram by Identifying Entities, Attributes and Relationships between any two Entities to Create a Company Database Scheme. 1. Create an E-R Diagram for the Company database from the raw data files...
The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will...
The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company’s training program. The HEG administrator gives you the description (see below) of the training group’s operating environment. (Hint: Some of the following sentences identify the volume of data rather than cardinalities. Can you tell me which ones?) The HEG has 12 instructors and can handle up to 30 trainees per class. HEG offers five Advanced Technology...
Consider this Entity-Relationship model, drawn for the following business rules. • A route is uniquely identified by a route number • A bus is uniquely identified by bus registration number • A route can have one or more busses assigned to it at any given time • A bus is assigned to only one route at any given time. • Not all busses are assigned to routes (some may undergo servicing or kept on reserve). Bus Route 0..1 RegNo {PK}...
Q1.a) Based on the business rules, you are expected to construct
an Entity-Relationship (ER) diagram. The ER diagram should include
entities, attributes (if there are less than three specified in the
business statements, please add some extra attributes), identifiers
and corresponding data types, the relationships among entities with
cardinality and associative entities.
.b) Extend Q1.a) to apply generalization/specialization
technique to construct an Enhanced-ER (EER) diagram. The EER
diagram should specify the complete (total) and disjoint
(mutuallyexclusive) constraints on the
generalization/specialization....
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The final grade of a student in Structural Analysis class The joint probability of the grades earned by a student is P(X,Y) which is as follows. Stochastic Modeling Grades 90 75 Structural Analysis Grades 95 0.2 0.3 80 0.4 0.1 How the grades of Stochastic and Structural Analysis classes are related to each other? (Positive, Negative or no relationship?) *Hint: No need for the final...
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The final grade of a student in Structural Analysis class The joint probability of the grades earned by a student is P(X,Y) which is as follows. Stochastic Modeling Grades Structural Analysis Grades 95 0.2 0.3 90 75 80 0.4 0.1 How the grades of Stochastic and Structural Analysis classes are related to each other? (Positive. Negative or no relationship?) *Hint: No need for the final...
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The final grade of a student in Structural Analysis class The joint probability of the grades earned by a student is P(X,Y) which is as follows. Stochastic Modeling Grades Structural Analysis Grades 95 0.2 0.3 90 75 80 0.4 0.1 How the grades of Stochastic and Structural Analysis classes are related to each other? (Positive. Negative or no relationship?) *Hint: No need for the final...
6- (15%) Assume that X=The final grade of a student in Stochastic Modeling class and Y=The final grade of a student in Structural Analysis class The joint probability of the grades earned by a student is P(X,Y) which is as follows. Stochastic Modeling Grades Structural Analysis Grades 95 0.2 0.3 90 75 80 0.4 0.1 How the grades of Stochastic and Structural Analysis classes are related to each other? (Positive, Negative or no relationship?) *Hint: No need for the final...
New to DB's Please help!
You are designing and creating a database named COMPANY for an HR (Human Resource) Dept of a Software Consulting Company to manage their employees and their assigned work (projects) in the company First Step to Design and Create a Database is Creating an E-R Diagram by Identifying Entities, Attributes and Relationships between any two Entities to Create a Company Database Scheme. 1. Create an E-R Diagram for the Company database from the raw data files...
Most questions answered within 3 hours.
-
The rise of online shopping and Amazon, in particular, has
created major dilemmas for large food/CPG...
asked 16 seconds from now -
Assuming that the wave speed varies little when sound waves are
traveling through a material that...
asked 26 seconds ago -
Is oxygen difluoride polar or nonpolar?
nonpolar
polar
ionic
none of the above
asked 11 minutes ago -
Starting from rest, a car accelerates at a constant rate of 2.6
m/s2 for a time...
asked 7 minutes ago -
A pharmaceutical company wants to answer the question whether
time for a drug in pill form...
asked 10 minutes ago -
) Assume that in the market for widgets, demand is highly
elastic compared to supply. If...
asked 21 minutes ago -
Why is a personal interview the most important step in the sales
selection process? What are...
asked 31 minutes ago -
In Python rOverlap (x1, y1, w1, h1, x2, y2, w2, h2) A rectangle
is axis-aligned if...
asked 31 minutes ago -
If we observe in a protein solution that DNA is causing a
mixture 260/280 ratio ~0.9,...
asked 41 minutes ago -
Explain the steps involved in making cDNA from mRNA, and how you
would create a cDNA...
asked 42 minutes ago -
A beta (β) particle is described by which of the following?
Select the correct answer below:...
asked 44 minutes ago -
A new machine costs $150,000, lasts 10 years, has an annual
O&M cost of $50,000, and...
asked 48 minutes ago