Using the ECCS database structure, write the SQL code for the following: 1.Inser
ID: 3713538 • Letter: U
Question
Using the ECCS database structure, write the SQL code for the following:
1.Insert the following information into tblContacts, using your initials and today’s date: CoID = 5298, Mary, Smith, Operator, 7015551212, CoID = 9875, Jaden, Montgomery, 555555555, Operator, Main Contact
2.Update all tblCompanies.EBy that have initials of RT to RM.
3.A new temporary table was created by the name of tmptblPeople. Please remove the table from the database.
ECCS Database structure:
ECCS Database
tblCompanies
CoID
AutoNumber
CoName
Short Text
CoAdd
Short Text
City
Short Text
St
Short Text
Zip
Short Text
CoPhone
Short Text
CoTollFree
Short Text
CoFax
Short Text
CoEmail
Hyperlink
CoComment
Short Text
EDate
Date/Time
EBy
Short Text
MDate
Date/Time
MBy
Short Text
tblContacts
ContactID
AutoNumber
CoID
Number
FName
Short Text
LName
Short Text
SSN
Short Text
Title
Short Text
MContact
Yes/No
DPhone
Short Text
DCell
Short Text
DEmail
Hyperlink
CEBy
Short Text
CEDate
Date/Time
CMBy
Short Text
CMDate
Date/Time
tblEntries
EID
AutoNumber
ContactID
Number
Drug
Date/Time
OSHA
Date/Time
MSHA
Date/Time
ReInstate
Date/Time
EEBy
Short Text
EEDate
Date/Time
EMBy
Short Text
EMDate
Date/Time
tblStats
SID
AutoNumber
CompID
Number
SYear
Short Text
Injuries
Number
DaysLost
Number
Deaths
Number
OSHAIncidents
Number
ESBy
Short Text
ESDate
Date/Time
ESMBy
Short Text
ESMDate
Date/Time
tblCompanies
CoID
AutoNumber
CoName
Short Text
CoAdd
Short Text
City
Short Text
St
Short Text
Zip
Short Text
CoPhone
Short Text
CoTollFree
Short Text
CoFax
Short Text
CoEmail
Hyperlink
CoComment
Short Text
EDate
Date/Time
EBy
Short Text
MDate
Date/Time
MBy
Short Text
Explanation / Answer
1. INSERT INTO tblContacts(CoID, FName, LName, SSN, Title, MContact, DPhone, DCell, DEmail, CEBy, CEDate, CMBy, CMDate)
VALUES(5298, "Mary", "Smith", "45848", "Operator", "Yes", "945685423", "45", "mary@g.com", "RT", GetDate(), "RT", GetDate());
INSERT INTO tblContacts(CoID, FName, LName, SSN, Title, MContact, DPhone, DCell, DEmail, CEBy, CEDate, CMBy, CMDate)
VALUES(9875, "Jaden", "Montgomery", "45848", "Operator", "Yes", "555555555", "45", "mary@g.com", "RT", GetDate(), "RT", GetDate());
2. UPDATE tblCompanies
SET EBy = "RM"
WHERE EBy = "RT";
3. DROP TABLE tmptblPeople;
**Comment for any further queries.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.