Term Project Instructions
The class will be divided into groups who will work on the project as a team. Each team will develop a database model using the CA ERwin Data-modeling tool. The database system will consist of creating the data model and then forward engineer the model into scripts that, when ran, will create the database tables.
Teams will select an appropriate business organization e.g., a college/university, a mail order business, an accounting firm, et al.
Below you will see sample SQL DDL script for a University database system, and a Mail Order Company database system. You will also find copies of the table layouts, and a simple ERD for each of these sample companies. Additionally, you will most likely find it necessary to research various business entities, to determine what type of data they store and how it is used in the conduct of their business.
A copy of the Community edition of CA ERwin r8 is on the XenDesktop. It is recommended that you use that for completion of all of your class assignments. If you have your own personal computer, you can install the software yourself and use it there, but be mindful that I will be grading it based on the XenDesktop image of the software; in other words, it must work there to be acceptable.
Each team will prepare a written and oral presentation of their project designed to explain the design of each of the systems to individuals that will be using the system. The written presentation will be written using APA standards and will contain (1) a description of the company for whom you are designing the database; (2) the specific division/section of the company that is requesting the database design; (3) identify the entity types that are required to develop the database; (4) provide the naming conventions that will be used in the design; (5) identify all relationships that will be required between entities; (6) determine and list all constraints that each of the entities will require; (7) normalize the database to, at least, 3NF preferably BCNF; (8) provide a copy of the final ERD developed in ERwin; (9) provide the scripts forward engineered from ERwin; and, finally, (10) some sample data input screens and reports.
We will go over some of these areas while working on the ERwin system. The oral portion will be a verbal presentation of the items 1-10 listed above. You may use Big Blue Button software to prepare and submit your presentation. Each presentation should allow for 10-12 minutes of content, so time it carefully.
This project will enable you to develop a real-world prospective on what database system developers achieve during their day to day assignments.