Question: 1. Create a relational schema in ERD-Plus. 2. The Entity-Relation diagram below is a conceptual model of an apartment rental company. 3. Map the given

1. Create a relational schema in ERD-Plus.

2. The Entity-Relation diagram below is a conceptual model of an apartment rental company.

3. Map the given E-R diagram to a Relational model using ERD-Plus.

4. Use all standard conventions.

5. Establish associations between the tables by inserting appropriate “Foreign Keys.”

Name Contact Person Speciality Service-ID Zip CONTRACTOR WorksOn ServiceCompleted StreetAdd SERVICE ServiceDateOrder

6. Make sure that the relational model meets all the criteria of a valid Relational Model.

Name Contact Person Speciality Service-ID Zip CONTRACTOR WorksOn ServiceCompleted StreetAdd SERVICE ServiceDateOrder ed City Phone Email ActualCost CurrentCost Appliance-ID Assigned Scope EstimatedCost Condition Type APPLIANCE FittedWith Bathrooms WarrantyDate Unit-id Model PurchaseCost Purchase Date F UNIT At Bedrooms Number Area TenantEmail TenantID NumOccupants TenantCrimRecor d BidgCity BldgArea Houses BldgName TenantCredit BUILDING Leased TenantFname TENANT ||+ BldgFloors TenantPhone TenantLname BldgSteetAdd BldgZip Condition (WalkthroughEnd) ContractSecurity Contract-ID CONTRACT Signs Contract-Date ContractEndDate ContractRent (WalkthroughBeg)

Step by Step Solution

★★★★★

3.48 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

ER diagram The ER model is to represent the structure of data by using entities and attributes and their relations ER diagram considers entities in the realworld and relating with them It is a graphic... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Alhamra Technology's capital structure is as follows [in %]: Debt 30; Preferred stock 20; Common equity 50; The before tax cost of debt is 8 percent and tax rate is 50%; the cost of preferred stock...

Create a relational schema for the Branch view of Dream Home based on the conceptual data model produced in Exercise 15.13 and compare your schema with the relations listed in Figure 16.5. Justify...

The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...

create a relational schema in ERD-Plus. 2. The Entity-Relation diagram below is a conceptual model of an apartment rental company. 3. Map the given E-R diagram to a Relational model using ERD-Plus....

1 . This assignment requires you to create a relational schema in ERD - Plus. 2 . The Entity - Relation diagram shown in Fig 1 is a conceptual model of an Investment business process. 3 . Map the...

1. Suppose the current price of a stock is $100 and every 6 months it may increase by 30% with a probability of 60% or decrease by 20% with a probability of 40%. The stock does not pay dividends over...

pls answer Task 2 only thnx The problem scenario You are asked to design a database for a company that operates driving schools at several cities in UK. It is to store information about the driving...

Book (ISBN, title, author, edition, year) BookCopy (copyNo, ISBN, available) Borrower (borrowerNo, borrowerName, borrowerAddress) BookLoan (copyNo, dateOut, dateDue, borrowerNo) where Book contains...

Question 2c pls The proble You are asked to design a database for a company that operates driving schools at several cities in UK. It is to store information about the driving schools, clients,...

The problem scenario You are asked to design a database for a company that operates driving schools at several cities in UK. It is to store information about the driving schools, clients,...

Explain why communication is essential in an organization. Explain the ways that effective communication improves employee trust and engagement. Focus on comparing/contrasting two types of channels...

Claims from a portfolio are believed to have a Pareto (a,A) distribution. In Year 0, a=6 and 2=1,000. An excess of loss reinsurance arrangement is in force, with a retention limit of 500. Inflation...

Part B: Three masses, x, y, and z, are to rotate in the same plane at the same angular velocity. Their masses and radii from the centre of rotation are: 9 kg at 400 mm radius, 10 kg at 350mm, and at...

Submit a case analysis a Public Sector Human Resource Management Issue. On hiring process challenges include the following: History and background of the Public Service Human Resource Management...

Write an asset acquisition request The first part of the request is a short financial report on the caf's assets. Summarise the assets' worth and condition You are then required to develop a plan for...

An information-technology based company wants to forecast the units of computer required for next month. So, it summoned a weekly committee to estimate the orders for the previous twelve months and...

A company provides services on account during the current year totaling $420,000 By the end of the year. $330,000 of this amount had been received. In addition, $65,000 was received on account from...

What can scientists learn by comparing the fossilized skeletons of extinct primates with the bones of modern species?

Question 5: Process optimisation The Internet enabled cycling machines are imported from the China. Within the freeport at Jebel Ali you organize FOUR different suppliers to handle the simple...

Use the company that you selected for Problem 1. Identify examples of its learning and growth efforts and explain how those might affect its business process performance?

Do you think that your accounting education has prepared you for all roles of an accountant in business (see Table 2.1)? Which roles do you feel best prepared for? Which roles do you feel least...

Internal auditors are often tasked with testing vulnerabilities. How would you suggest testing for system intrusion, logical access control, natural disasters, and intentional destruction of...

A technology store holds a contest to attract shoppers. Once an hour, someone at checkout is chosen at random to play in the contest. Here's how it works: An ace and four other cards are shuffled and...

You are three spaces from a win in Parcheesi. On each turn, you will roll two dice. To win, you must roll a total of 3 or roll a 3 on one of the dice. How many turns might you expect this to take?

Many states run lotteries, giving away millions of dollars if you match a certain set of winning numbers. How are those numbers determined? Do you think this method guarantees randomness? Explain.