Assignment-2-Spring-2020 (1).pdf - 164 APPENDIX B...

This preview shows page 1 - 2 out of 5 pages.

164 APPENDIX B. ASSIGNMENT Assignment 2 Objective 1. Model a database using ER diagram using available tools. 2. Design a database. Refine the model and implement it in PostgreSQL.3. Reverse Engineer the database4. Write business rules for your model. Weight: Refer table on page 179 Team Rules Youmayworkaloneorinagroupoftwostudents; agroupofmorethantwostudentsisnotpermitted. Usetime available during lab hours to work on the assignment. Indicate your team members to the instructor before the end of Week 8. Team members may be assigned by the lab instructor. The lab instructor may change your team member to facilitate progress in the assignment. Team members must be from the same lab section. Submission Each student must upload the assignment individually, even if done in a group. Upload .txp file, .sql files with queries .pdf withERdiagramand .doc withbusinessrulesandmetadata. Youhaveunlimitedattemptstoupload, the last upload will be retained, all previous uploads will be overwritten. Refer page 157 for additional information on submission. YouareencouragedtoconsultwithyourlabinstructortovalidateyourdesignandERModel. Refertotherubric to verify that you have met the requirements. Use file naming conventions as in Assignment 1. Write DDL and DML statements in separate files. Requirements Application Chose an application of your liking, a topic that interests you. Refer section 1.5 on page 3 for examples. You will need sufficient data to populate your database, therefore it is important that you choose an appropriate application. Pencil first, computer next Draw an ER diagram using a clean sheet of paper, a pencil and eraser. Write (business) rules as you plan your database; aim to write at least 12 rules, upto a maximum of 20 rules. Create at least 5 entities, not including associative entities. Verify the ERD and business rules with your lab instructor on week 8, refer rubric. Do not draw the ER diagram using a diagramming tool on your computer and forward engineer. One of the objectives of the assignment is to model a database that resembles to your experience in future work situations. Modelling game situations are discouraged; it is unlikely you will implement these types of databases in

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture