Write a SQL statement that inserts these three records to the three tables.

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter6: Creating, Sorting, And Querying A Table
Section: Chapter Questions
Problem 4AYK
icon
Related questions
Question

Write a SQL statement that inserts these three records to the three tables.

Individual FirstName
LastName
Address
Phone
101 Your first name Your last name 123 Main Stree 270-555-1010
Groups
GroupID GroupName
11 Sky Diving
GroupMembership
GroupID IndividualID
11
Individuals
101
Dues
20
Transcribed Image Text:Individual FirstName LastName Address Phone 101 Your first name Your last name 123 Main Stree 270-555-1010 Groups GroupID GroupName 11 Sky Diving GroupMembership GroupID IndividualID 11 Individuals 101 Dues 20
Individuals
IndividualID, int
FirstName, varchar
LastName, varchar
Address, varchar
Phone, varchar
GroupMembership
GroupID, int
IndividualID, int
Groups
GroupID, int
GroupName, varchar
Dues, money
Transcribed Image Text:Individuals IndividualID, int FirstName, varchar LastName, varchar Address, varchar Phone, varchar GroupMembership GroupID, int IndividualID, int Groups GroupID, int GroupName, varchar Dues, money
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Write script to create a stored procedure that accepts an IndividualID value as a input parameter and lists the individual's first name and last name.

Individuals
IndividualID, int
FirstName, varchar
LastName, varchar
Address, varchar
Phone, varchar
GroupMembership
GroupID, int
IndividualID, int
Groups
GroupID, int
GroupName, varchar
Dues, money
Transcribed Image Text:Individuals IndividualID, int FirstName, varchar LastName, varchar Address, varchar Phone, varchar GroupMembership GroupID, int IndividualID, int Groups GroupID, int GroupName, varchar Dues, money
Individual FirstName
LastName
Address
Phone
101 Your first name Your last name 123 Main Stree 270-555-1010
Groups
GroupID GroupName
11 Sky Diving
GroupMembership
GroupID IndividualID
11
Individuals
101
Dues
20
Transcribed Image Text:Individual FirstName LastName Address Phone 101 Your first name Your last name 123 Main Stree 270-555-1010 Groups GroupID GroupName 11 Sky Diving GroupMembership GroupID IndividualID 11 Individuals 101 Dues 20
Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
SQL Query
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning