Project
Your programming project will be to build a substantial database applicationfor a real-world scenario of your choosing. You will design a schema for the database, and youwill create an actual database using a relational database management system. You will populate thedatabase with sample data, write interactive queries and modifications on the database, create programsthat manipulate the database, and develop user-friendly tools for interacting with the database.You areresponsible for:
First, write the project proposal by June 8, 2013
This proposal should include:
A narrative description of the field chosen for the application being created. This should also include a description of the problem and addressing the weaknesses to be solved by the database.
Identification of the information needs – what information is needed to help solve the problem.
Initial list of entities (tables) that have been identified. This should come naturally from the above discussions.
Roles and Responsibilities of each member for the project. List the names of each group member and what their primary role will be (e.g., systems analyst, application developer, documentation writer).
The following is due June 18, 2013
Systems Analysis The next step is for the students to take the requirements from the “users” and draw an
http://cisnet.baruch.cuny.edu/holowczak/classes/3400/week3.htmlEntity Relationship diagram. The E-R Diagram should then be submitted to the instructor for approval before proceeding. Students may use a specific
http://cisnet.baruch.cuny.edu/holowczak/classes/3400/resource.htmlER modeling tool.
Note: The “Relationship View” in MS Access is not an ER modeling tool.
Logical and Physical Modeling Given the ER diagram and sets of attributes for each entity, the next step is to convert the ER model into a
http://cisnet.baruch.cuny.edu/holowczak/classes/3400/week4.htmlrelational model and go through the process of…