CIS111 Database Development Project 1 For this project you will be architecting a database for Book Store sales. The items to be automated are the bookstore inventory, retails sales, which...

jh


CIS111 Database Development Project 1 For this project you will be architecting a database for Book Store sales. The items to be automated are the bookstore inventory, retails sales, which include online and in the store. The bookstore gets their books from a supplier. How to submit your assignment: 1. This assignment will be submitted in report format. 2. The submission must have the following: a. A cover sheet with your name, and your database name. b. The project requirements below. 3. Please see the due date for this project in Moodle. You cannot start on project 2 until this project has been graded and you have received above a 60%. 4. No hand drawn documents will be accepted. 5. When completing the ERD with the Oracle Data Modeler software, do not submit the dmd file. You need to submit a PDF export of the drawing. The project requirements: 1. Determine the entities (tables) that will be needed. The sheets are available in Moodle. 2. For each table, list all of the data elements that will be needed. Make sure all data elements are broken down to its smallest component, but not more than 3rd normal form. 3. The data dictionary that outlines ALL of your data elements. A blank excel spreadsheet is available on Moodle. 4. Create an entity relationship diagram for your database. No hand drawn diagrams will be accepted. There are several software programs that can assist. You can use Microsoft Visio, Oracle Data Modeler, or Erwin Data Modeler. DO NOT use Microsoft SQL server for project 1, as your project will not be accepted. 5. Identify primary/foreign keys for the tables. Company Information: The company has the following characteristics (please see attached sheets): a. Has a minimum of 10 unique customers. b. The bookstore has 4 locations, in two different states. Select two cities within each state. c. The company has 4 employees, 1 supervisor, 1 branch manager, per store. The project contents, drawing and documentation are due Per Moodle announcements. You cannot start project 2 without submitting project 1, and receiving above a 60%. You can submit multiple times for review.