Objectives:

You are required to develop a fully functional enterprise database so that customers are interested in buying or at least testing your product. Your plan, analysis, and design for the database project should be based on the Database concepts covered in the course and using MySQL. Project Requirements: You are required to create an Employee Record Database project in MySQL.

Your Database MUST have the following: 1.

Create new Database and apply Entity relationship (E-R) diagrams (Chapter 2) and Enhanced E-R diagrams to relations (Chapter 3) for the topic you choose using the traditional EER notation a. Sample DDL (Figure out a data scheme useful to your chosen business. It should include at least 5 tables, each with at least 6 data fields and insert statements) 2. Create tables with entity and relational integrity constraints (Chapter 4) a. Populate your database with at least 20 entries in 1 table, and 12 in the second. b. Create validation rules for your tables, including at least one of each of the following: Required field A default value 2 Range of allowed values Collection of allowed values Specific format (e.g. phone number or ZIP code) c. Use normalization to decompose anomalous relations to well-structured relations 3. Queries: (Figure out at least 10 saved queries that might be useful for the databases users, and create them in your database) a. 4 simple queries (based on chapter 5) b. 3 intermediate queries (based on chapter 5) c. 3 advanced queries (based on chapter 6) 4. Create a view for data entry for at least 5 of the tables. 5. Show the database is maintainable by inserting a new field into one of the data tables, deleting a record, and creating a referential relationship between the two tables. Note: You are welcome to add additional tables or fields, use different names, or create different saved queries, forms, or reports feel free to do so, as long as you cover all the objectives given above.