IT 240 Introduction to DBs Spring 2020 Page 1 of 2

Erd Modeling using Vertabelo (http://www.vertabelo.com/)

Submit:

· This Word document updated with content for Parts I and II

· Create a zip archive containing a copy of the final SQLite3 database (JRJProject.db) and the various SQL DDL & DML statements for both Parts I and II

Part I

1. Create a Word document to document your work for this activity.

Make certain to copy and paste your results into this document.

2. If you have not already done so, sign up for a free Student Vertabelo account at http://www.vertabelo.com/

Make certain to go to Pricing Academic Student account

3. Use Create a New Document | Physical Model diagramming tool to create all three ER models for the James River Jewelry Project Case Study:

Conceptual

Copy and Paste the model into your Word document; create the DDL SQL for this model, save it, and copy and paste the results here.

Logical

Copy and Paste the model into your Word document; create the DDL SQL for this model, save it, and copy and paste the results here.

Physical

Copy and Paste the model into your Word document; create the DDL SQL for this model, save it, and copy and paste the results here.

3. Use your knowledge of SQL and DML statements (e.g. update etc.) to create an SQLite 3 DB—name it JRJProject.db—populate the database with the data from our exercises.

4. Verify the database works properly by creating queries similar to those that we know works.

5. Summarize your work in this Word document with appropriate screenshots; also create a zip archive containing a copy of the final SQLite3 database and the various SQL DDL & DML statements.

Part II

1. Answer questions A and B for the Writer’s Patrol Correction ticketing database as discussed on pp. 344–345 in the text.

In addition, make certain to also include all three models and the generated SQL code for each:

Conceptual

Copy and Paste the model into your Word document; create the DDL SQL for this model, save it, and copy and paste the results here.

Logical

Copy and Paste the model into your Word document; create the DDL SQL for this model, save it, and copy and paste the results here.

Physical

Copy and Paste the model into your Word document; create the DDL SQL for this model, save it, and copy and paste the results here.