Into to Database

1 Write a database for a School name Electronics World, it must support the following requirements. (NO ERD)

Create the script in Notepad and run the script (Database on SQL Plus)

• 3 Entities or Tables
• Each table must have at least 5 attributes or (column names).

• Include PK and FK.

2 Normalize this table in a 1NF. (2 points) Use Visio or any other design tool.

• Book_ID
• Author
• Title
• Retail_Price
• Location_1
• Location_2
• Location_3
• Name
• Zip
• State
• Phone
• Email
• Publish_Date

3- SELECT statements.