Part 4 Write and run three different queries that pull data from the Person tabl
ID: 3714925 • Letter: P
Question
Part 4
Write and run three different queries that pull data from the Person table and use ORDER BY to sort the rows in three different ways. Include the queries and the corresponding results in a text file. Use screen shots to document this part of the assignment.
Normalizing Data for Data Entry Assume the following table structure MariaDB [ (none) ]> describe test.members; I Fielcd | Type | Null I Key I Default l Extra I I int (11) I varchar (30) I YESI IDNumber I NO I PRI | NULL LastName | FirstName Ivarchar (30) YES | Emai.1 | MemberSince date NULL NULL NULL NULL I varchar (50) IYES I YES I 5 r?ws in set (0.01 sec) You should create this table using the following SQL: CREATE TABLE members ( IDNumber LastName FirstName Email MemberSince DATE INT PRIMARY KEY VARCHAR (30), VARCHAR (30), VARCHAR (50), You should clean up and normalize the following data found in various sources. After normalizing the data, write and run SQL INSERT statements to enter the rows into the database table that you created above. In a brief paper, describe the process for normalizing the data and why you made the changes that you did.Explanation / Answer
There is no need to normalize the given details in general. Only if a particular user has multiple names or multiple email Ids is allowed, then they are to be grouped in separate tables with IDNumber as the foreign key.
--------------------------------------
Example Queries from members table:
-------------------------------------