Group D: Terry Irie Natalie Kaczynski Kevin Kain Hannah Spiegel Nandini Jain Item 1 Create a document and report a.What Database system your group used (MySQL or Microsoft Access) b.Who created the...

See document


Group D: Terry Irie Natalie Kaczynski Kevin Kain Hannah Spiegel Nandini Jain Item 1 Create a document and report a.What Database system your group used (MySQL or Microsoft Access) b.Who created the tables in the database? c.Who entered data into tables Item 2 d.Show the statement for creating the tables e.Show the statement that inserted data into the tables F. Copy and paste d. and e. into your document Item 3 g.Create a query that shows all data in the tables i.e: select * from tablename; h.Create a query using Column Aliases i.Use a Natural Join (you are free to choose the tables) j.Use Join Using syntax (tablename JOIN tablename USING ) (you are free to choose the tables. k.Use JOIN ON syntax (You are free to choose any of Proj. tables; page 260) l.Create a query statement to use ODER BY clause. m. Use a query statement to use WHERE clause to retrieve a specific record. n.Create a query statement to use WHERE clause. o.Create tow query statements to use Logical operators: AND, OR p.Create a query statement to use Logical operators: AND, OR combined (look figure 7.30) q.Create a query statement to use LIKE special operator r.Create a query to use GROUP By (page 285) s.Create a query to use GROUP By and ORDER BY Item 4 Subqueries T. Create a query statement to use WHERE subqueries (you are free to use any of your project tables 292, 293). u. Create a query statement to use DISTINCT and WHERE column_name IN subqueries (...) page 293—IN Subqueries Item 5. Copy and Paste the query statements and the retrieved data (similar to figures in the book).