Data Normalization Relationship (Relation in 1st, 2nd, and 3rd form)

1NF, 2NF, 3NF

Use the following tables to develop a SQL query for this database which reproduces closely the relation from the table 5.

1. ARFactor

Grade	AR Factor
1st	100%
2nd	90%
3rd	85%

2. Student

StuID	Student	Grade	AR Factor
101	John	3rd	85%
102	Doe	2nd	90%
103	Jane	3rd	85%
104	Smith	1st	100%

3. ARTest

StuID	BookID	Test Points	AR Points
101	1002	18	153.0
101	1001	85	72.3
101	1003	65	221.0
102	1004	9	81.0
102	1005	90	162.0
103	1001	72	61.2
104	1005	85	170.0
104	1001	95	95.0

4. Book

BookID	Book Title	Book Points
1002	Crime and Punishment	1000
1001	Bunny's Adventure	100
1003	Harry Potter	400
1004	Paradise Lost	1000
1005	Sweet Summer Fun	200

5. Develop a SQL query for the database which reproduces closely the 1NF

ARTest

StuID	BookID	Student	Grade	AR Factor	Book Title	Book Points	Test Points	AR Points
101	1002	John	3rd	85%	Crime and Punishment	1000	18	153.0
101	1001	John	3rd	85%	Bunny's Adventure	100	85	72.3
101	1003	John	3rd	85%	Harry Potter	400	65	221.0
102	1004	Doe	2nd	90%	Paradise Lost	1000	9	81.0
102	1005	Doe	2nd	90%	Sweet Summer Fun	200	90	162.0
103	1001	Jane	3rd	85%	Bunny's Adventure	100	72	61.2
104	1005	Smith	1st	100%	Sweet Summer Fun	200	85	170.0
104	1001	Smith	1st	100%	Bunny's Adventure	100	95	95.0