Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

. . 3. You have been hired by the government of Lukewarm Kingdom to design database for managing data from municipal wastewater treatment stations (WTS).

image text in transcribed

. . 3. You have been hired by the government of Lukewarm Kingdom to design database for managing data from municipal wastewater treatment stations (WTS). You are asked to develop a database system capable of storing the information about wastewater treatment stations, staffs that inspect the running of these stations as well as station managers. A WTS can either be run by the government or a company. Each WTS is associated with a district of the city and has an address. A company can run multiple WTSs. Each company has its own address. WTSs that are owned by the government are run at the city level. Thus, they are managed by the corresponding city government. Each city government is associated with a contact address. A WTS Inspector has a list of WTSs that he will visit each month. a Each inspector has his ID card and is registered with a unique phone number. Some information is not specified directly, you may add them if necessary. . . . . i. ji. Draw the E/R diagram for this database. Write down the SQL script necessary to create the database. Minor syntax errors are tolerated

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Database Programming With Visual C# .NET

Authors: Ying Bai

1st Edition

0470467274, 978-0470467275

More Books

Students also viewed these Databases questions

Question

i am getting an error for object "Range Failed" '

Answered: 1 week ago