Homework Answers
Rectangle boxes denotes the table and oval circle denotes the attributes of those tables. The rhombus figure depicts the relationship.
1...* is one to many relation and 1..1 is one to one relation.
Primary fields of the table are underlined for each
table.
Add Answer to:
Construct an E-R diagram for a car insurance company whose customers own one or more cars...
3. b) Construct an appropriate conceptual Entity Relationship Diagram (ERD) for the requirements specified below. The Chen notation should be used to create the diagram. An insurance company has cust...
3. b) Construct an appropriate conceptual Entity Relationship Diagram (ERD) for the requirements specified below. The Chen notation should be used to create the diagram. An insurance company has customers and offers products. When a customer takes out insurance they buy a policy. The minimum amount of information on the policy is the type of insurance taken out, the annual premium and the full name of the insured. A so called insured person does not necessarily have to be a...
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....
1. As a deterrent to keep individuals from excessively submitting claims to the insurance policy and...
1. As a deterrent to keep individuals from excessively submitting claims to the insurance policy and for policyholders to follow responsible behavior, particular in the case of auto insurance, insurance companies commonly use a) 100% coverage b)inflation protection. c) risk-based premiums. d) no-fault insurance. e) changing phone numbers. 2. A diversified portfolio consists of two or more assets a) whose rates of return do not have high positive correlation. b) whose rates of return do not have zero correlation. c)...
Can someone who knows how to draw data model on mySQL help me out? Budget car...
Can someone who knows how to draw data model on mySQL help me out? Budget car rental company has offices located across the continental USA. They would like to track the local address ( all pieces address, state, city, zip),and the contact phone number for that office location. They would also like information about employees working at that office including their names, date of birth, start of employment, contract phone number, and roles. Offices typically have more than one employee...
An auto insurance company insures your car for one year against damage due to collision with...
An auto insurance company insures your car for one year against damage due to collision with another vehicle or object. Your policy has an annual deductible of 400. During the year there is a 90% chance that you will not have a collision and a 10% chance that you will have exactly one collision. Assume that the damage from a collision is approximated by an exponential distribution with mean 1600. (a) What is the probability that the insurer will...
A health insurance company knows that there are two types of customers (smokers and non-smokers), each...
A health insurance company knows that there are two types of customers (smokers and non-smokers), each facing different health risks. The probabilities of getting sick and the healthcare costs in the case of illness for the two customer types is given in the table below. Group Healthcare costs Probability of getting sick Smokers $1200 50% Non-smokers $1200 20% Assume that each customer has a monthly income of $1600 and has a utility function given by U(x)=sqrt(x), where x is the...
Please read the following situation and construct an E-R diagram, using the concepts we learnt in...
Please read the following situation and construct an E-R diagram, using the concepts we learnt in class. We should use a computer graphing package, such as MS Powerpoint, to construct the E-R diagram, so it looks professional. Turn in a hard copy of the sketch at the due time. . POP organization: The POP (publish-or-perish) organization publishes several academic journals. They would like us to build them a database system, to help manage their business. As a first step, you...
a) One month's insurance has expired. b) The remaining inventory of supplies is $300. c) The...
a) One month's insurance has expired.
b) The
remaining inventory of supplies is $300.
c) The
estimated depreciation on equipment is $125.
d) The
estimated income taxes are $2700.
Requirements
1.Prepare the closing entries at July 31 in the general
journal
2. Post the closing entries to the general ledger T-accounts and
compute ending balances. Just add to the adjusted balances already
listed.
Requirement #1: During its first month of operation, the Quick Tax Corporation, which specializes in tax preparation,...
Revenues are normally recognized when a company transfers promised goods or services to customers in the...
Revenues are normally recognized when a company transfers promised goods or services to customers in the amount the company expects to be entitled to receive. Expense recognition is guided by an attempt to match the costs associated with the generation of those revenues to the same time period. Assume that the following transactions occurred in January: a. McGraw-Hill Education uses $2,767 worth of electricity and natural gas in its headquarters building for which it has not yet been billed. b....
Zipcar: “It’s Not About Cars—It’s About Urban Life” Imagine a world in which no one owns...
Zipcar: “It’s Not About Cars—It’s About Urban Life” Imagine a world in which no one owns a car. Cars would still exist, but rather than owning cars, people would just share them. Sounds crazy, right? But Scott Griffith, CEO of Zipcar, the world’s largest car-share company, paints a picture of just such an imaginary world. And he has nearly 800,000 passionate customers—or Zipsters, as they are called—who will back him up. Zipcar specializes in renting out cars by the hour...
3. b) Construct an appropriate conceptual Entity Relationship Diagram (ERD) for the requirements specified below. The Chen notation should be used to create the diagram. An insurance company has customers and offers products. When a customer takes out insurance they buy a policy. The minimum amount of information on the policy is the type of insurance taken out, the annual premium and the full name of the insured. A so called insured person does not necessarily have to be a...
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....
a) One month's insurance has expired.
b) The
remaining inventory of supplies is $300.
c) The
estimated depreciation on equipment is $125.
d) The
estimated income taxes are $2700.
Requirements
1.Prepare the closing entries at July 31 in the general
journal
2. Post the closing entries to the general ledger T-accounts and
compute ending balances. Just add to the adjusted balances already
listed.
Requirement #1: During its first month of operation, the Quick Tax Corporation, which specializes in tax preparation,...
Revenues are normally recognized when a company transfers promised goods or services to customers in the amount the company expects to be entitled to receive. Expense recognition is guided by an attempt to match the costs associated with the generation of those revenues to the same time period. Assume that the following transactions occurred in January: a. McGraw-Hill Education uses $2,767 worth of electricity and natural gas in its headquarters building for which it has not yet been billed. b....
Most questions answered within 3 hours.
-
For the reaction 1N2+3H2-----> 2NH3, would the reaction rate
trend be: delta[NH3]/ delta t = -2...
asked 26 minutes ago -
Within your current/past organization, identify a problem/issue
and format a design to address same. You may...
asked 8 minutes ago -
A sock stuck to the side of a clothes-dryer barrel has a
centripetal acceleration of 24...
asked 1 hour ago -
A perfect gas undergoes an isentropic process such that its
volume doubles. If the ratio of...
asked 1 hour ago -
list the elements in groups 3A to 6A in the same order as in the
periodic...
asked 1 hour ago -
Estimating effect size. Peng and Chen (2014)
evaluated effect size estimates for various tests. In their...
asked 1 hour ago -
Write a script in MySQL that creates and calls a stored
procedure name test. This procedure...
asked 1 hour ago -
If we test the following: H0: μ = 17
vs. H1: μ ≠ 17 and the...
asked 2 hours ago -
in the past year TVG had revenues of 3 million, cost
of goods sold of $25...
asked 2 hours ago -
4) In a polypeptide, which bond cannot rotate because of its
partial double bond character?
The...
asked 2 hours ago -
Assume that in the short run L = 1,000 and K = 100. 1. What is...
asked 2 hours ago -
At a given temperature, 2.06 atm of H2 and 3.7 atm of Br2 are
mixed and...
asked 2 hours ago