Semester Project Assignment
SELECTING A PROJECT
1.Select a project area / domain that you are familiar with.It can be a business school organization etc.
2.The area should be somewhat bounded but broad enough that you can defineat least10 tables and relationships between those tables.
3.You topic does not necessarily have to be unique (i.e. more than one student may select the same subject area).
WHAT YOU WILL BE ASKED TO DO
4.You will need to develop business rules for you project that define the boundaries of the project and any assumptions that are guiding the design.
5.You will have to develop an ERD that shows your overall database design.
6.You will need to implement this design in MS Access or MySQL.
7.You will need to define aminimumof:
a.5 queries on the data
b.3 forms for entering and retrieving data
c.3 reports that can be generated from the data
8.You will be asked to present your problem area and database design to the class in a power point presentation.