1. What is structured query language and how is it used? 2. What is a primary key? 3. What is a foreign key?
1. What is structured query language and how is it used?
2. What is a primary key?
3. What is a foreign key?
4. Why would you need to join two tables?
5. What is the difference between a one-to-one and a one-to-many relationship? Can you join 2 tables to create a many-to-many relationship?
6. Write a SQL statement which does the following:
a. Creates a new table with 3 fields: Firstname, Lastname, PID. b. Make PID the primary key
c. Why might this table contain a foreign key?
7. Write an SQL statement for the above table that would find all people with the last name “Sweeney” and sort the results alphabetically by last name & first name.
9. What is the difference between DDL and DML?
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
