Answered step by step
Verified Expert Solution
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).
. . 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started