View the step-by-step solution to:

Question

This question was created from HW3.pdf https://www.coursehero.com/file/30851775/HW3pdf/

30851775-398009.jpeg
30851775-398009.jpeg

Part 2 - Modifying the CONMAN Database
Before you can start
Run the createCONTACT_INFO.sql and insertContact_Info.sql scripts in MySQL to create the
CONMAN database, the CONTACT_INFO table, with President Destler's record inserted.
Create a script called 'yourlastname_hw3p2.sql' that will include comments stating the task
number with the statement(s) for that task following.
Task 1 - Add new data into CONTACT_INFO
Create the statements needed to add the data in Appendix A to the CONTACT_INFO table AND
a record for yourself. This will result in a total of five records in the CONTACT INFO table
(President Destler's, the three from Appendix A, and your record).
Task 2 - Add an attribute to the CONTACT INFO table
Create a statement that will add an attribute called 'nickname' to the CONTACT_INFO table.
The attribute should be a variable length string capable of holding up to 20 characters. This
attribute does not have to have a value. When a value isn't specified 'To Be Determined' should
be used. You may NOT drop the table and recreate it with this new attribute, you must add
the attribute to the existing table.
Task 3 - Add constraints to the CONTACT INFO table
Create the statements to modify the firstname, middleinitial and lastname attributes so that a
value is required to be entered when new records are added. You may NOT drop the table and
recreate it with a primary key, you must add this constraint to the existing table.
Task 4 - Update an existing record
You will create a statement that will modify the existing record for President Destler to add a
nickname of 'Bill' for him. You may NOT delete the record and re-insert it with the new
attribute value, you must add the value to the existing record.
Task 5 - Delete records
Create a single statement that will delete the record of any contact that is associated with the
Concor International, Inc.' company.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 MYSQL tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors