100%(2)2 out of 2 people found this document helpful
This preview shows page 1 - 2 out of 5 pages.
164APPENDIX B. ASSIGNMENTAssignment 2Objective1. 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 179Team RulesYoumayworkaloneorinagroupoftwostudents; agroupofmorethantwostudentsisnotpermitted. Usetimeavailable during lab hours to work on the assignment. Indicate your team members to the instructor before theend of Week 8. Team members may be assigned by the lab instructor. The lab instructor may change your teammember to facilitate progress in the assignment. Team members must be from the same lab section.SubmissionEach student must upload the assignment individually, even if done in a group. Upload.txpfile,.sqlfiles withqueries.pdfwithERdiagramand.docwithbusinessrulesandmetadata. Youhaveunlimitedattemptstoupload,the last upload will be retained, all previous uploads will be overwritten. Refer page 157 for additional informationon submission.YouareencouragedtoconsultwithyourlabinstructortovalidateyourdesignandERModel. Refertotherubricto verify that you have met the requirements. Use file naming conventions as in Assignment 1. WriteDDLandDMLstatements in separate files.RequirementsApplicationChose an application of your liking, a topic that interests you. Refer section 1.5 on page 3 forexamples. You will need sufficient data to populate your database, therefore it is important that you choose anappropriate application.Pencil first, computer nextDraw 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. Createat least 5 entities, not including associative entities. Verify the ERD and business rules with your lab instructoron week 8, refer rubric.Do notdraw the ER diagram using a diagramming tool on your computer and forwardengineer.One of the objectives of the assignment is to model a database that resembles to your experience in future worksituations. Modelling game situations are discouraged; it is unlikely you will implement these types of databases in