Here is the whole assignment and what I am supposed to do. I am done with everything except the part where I have to run my tables through the SQL program. I need SQL statements for the tables I made. I do not understand how to work with these SQL programs to make my database.
In the final phase of the Database Design Proposal assignment, you are required to design a working prototype of the proposal. You will be required to utilize SQLite Database. The SQLite database is a small, lightweight database application, suited for learning SQL and database concepts, or to just explore some database-related ideas without requiring a full-blown database management system (DBMS). Refer to "Supplement: SQL Examples for SQLite Database," for the link to the SQLite Database download and examples.
The working prototype should include the following:
1) Provide a brief synopsis (utilizing research from related assignments) analyzing the detailed requirements of your prototype database design.
2) Design a database prototype that includes diagrams, data dictionary, design decisions, limitations, etc. The database should consist of at least four tables, two different user roles, and two reports.
Be sure to run your whole SQL program thru SQLite-CREATEs, INSERTs, & SELECTs-and paste the input text file & the output text file into your Word document like an appendix.
Attachment:- sql.zip