1. WellDone, Inc.: Well Done (WD) is a regional contractor of real estate development work, such as landscaping, building renovation, and house construction. To manage its growing business and data, WD has recently created a relational database using MySQL. You are helping WD to develop this database. After interviewing the stakeholders and analyzing the current databases, you identified these requirements: A. Each customer is identified by CustomerID, and has the attributes LastName, FirstName, PhoneNo, and BudgetAmt. B. Each contract is identified by ContractNum, and has the attributes Title, and Terms. C. Each customer is associated with one-to-many contracts; each contract is associated with exactly one customer. D. Each invoice is identified by InvoiceNum, and has the attributes InvoiceDate, Invoiceltem, and InvoiceAmt. E. Each contract is paid by zero-to-many invoices; each invoice is used to pay exactly one contract. Write MySQL statements to create the tables to store data for the aforementioned situation. Ensure that the statements are in proper order and meet the stated requirements (use suitable data types as needed). Execute these statements in your personal database in the MySQL server. 2. Write a MySQL statement to add a new attribute named "Email" to the table that stores customer data. 3. Write a MySQL statement to modify the name of the attribute "Title" to "Contract Title" in the table that stores contract data. 4. Write MySQL statements to insert at least three records per table. You may make up the data in a
1. WellDone, Inc.: Well Done (WD) is a regional contractor of real estate development work, such as landscaping, building renovation, and house construction. To manage its growing business and data, WD has recently created a relational database using MySQL. You are helping WD to develop this database. After interviewing the stakeholders and analyzing the current databases, you identified these requirements: A. Each customer is identified by CustomerID, and has the attributes LastName, FirstName, PhoneNo, and BudgetAmt. B. Each contract is identified by ContractNum, and has the attributes Title, and Terms. C. Each customer is associated with one-to-many contracts; each contract is associated with exactly one customer. D. Each invoice is identified by InvoiceNum, and has the attributes InvoiceDate, Invoiceltem, and InvoiceAmt. E. Each contract is paid by zero-to-many invoices; each invoice is used to pay exactly one contract. Write MySQL statements to create the tables to store data for the aforementioned situation. Ensure that the statements are in proper order and meet the stated requirements (use suitable data types as needed). Execute these statements in your personal database in the MySQL server. 2. Write a MySQL statement to add a new attribute named "Email" to the table that stores customer data. 3. Write a MySQL statement to modify the name of the attribute "Title" to "Contract Title" in the table that stores contract data. 4. Write MySQL statements to insert at least three records per table. You may make up the data in a
Fundamentals of Information Systems
9th Edition
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter3: Database Systems And Big Data
Section: Chapter Questions
Problem 4PSE
Related questions
Question
100%
Could someone help me write this MySQL code?
Transcribed Image Text:1. Well Done, Inc.: WellDone (WD) is a regional contractor of real estate development work, such as
landscaping, building renovation, and house construction. To manage its growing business and
data, WD has recently created a relational database using MySQL. You are helping WD to
develop this database. After interviewing the stakeholders and analyzing the current databases,
you identified these requirements:
A. Each customer is identified by CustomerID, and has the attributes LastName, FirstName,
PhoneNo, and BudgetAmt.
B. Each contract is identified by Contract Num, and has the attributes Title, and Terms.
C. Each customer is associated with one-to-many contracts; each contract is associated with
exactly one customer.
D. Each invoice is identified by InvoiceNum, and has the attributes InvoiceDate, Invoiceltem, and
InvoiceAmt.
E. Each contract is paid by zero-to-many invoices; each invoice is used to pay exactly one
contract.
Write MySQL statements to create the tables to store data for the aforementioned situation.
Ensure that the statements are in proper order and meet the stated requirements (use suitable
data types as needed). Execute these statements in your personal database in the MySQL server.
2. Write a MySQL statement to add a new attribute named "Email" to the table that stores
customer data.
3. Write a MySQL statement to modify the name of the attribute "Title" to "ContractTitle" in the
table that stores contract data.
4. Write MySQL statements to insert at least three records per table. You may make up the data in a
reasonable manner.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning