Access Database

Question 1

Part 1 – Using SQL to Build the Physical Data Model

• Write SQL statements to create tables in an MS Access database that represents your physical data model developed and added below.
• Specify data types and field lengths, establish primary keys and foreign keys, and implement other constraints you identified.
• Via “Database Tools” create table relationships
  

Part 2 – Review the SQL exercise word document attached. To complete this assignment.

Question 2

Web Storage API is used to store and retrieve data. There are additional technologies, such as Web SQL Database, Indexed Database, and File Access, which can also be used to store data. Research Web SQL Database, Indexed Database, and File Access, and write a 3-page paper explaining how each can be used. In your paper, provide examples of data models for each technology.