Fall 2011 Database Project Guidelines as of October 13th

Fall 2011 Database Project Guidelines as of October 13th -...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
CIS 3365 Fall 2011 Database Project Guidelines Due November 10 th , 2011 Introduction This course requires a database design and implementation project that will be  completed in two parts.  For Part 1, you will work with a team to analyze, design  and load a SQL Server 2008 database using your Systems Analysis and Design  project from ITEC 3343.  For Part 2, you will each individually create multiple  SQL scripts and also create the interface for a particular user view of this  implemented database. SQL Server 2008 Database Requirements Your group will take the Final Normalized ERD and divide the tables equally  among each of the team members.   Sequence of activities: 1) Each team member will develop the initial Create Table SQL scripts for  their own tables.    2) After success completion, the CREATE TABLE scripts are shared with the  rest of the team. 3) Your database is loaded with some test data and then the database  relationships are established by all of the team members developing the  appropriate ALTER TABLE scripts which are executed against the  database. 4) Tables are loaded with the rest of the test data.  This database MUST be  loaded with enough data to demonstrate all functionality within your  application.  Your core tables must have at least 200 or more rows of  “realistic” data.  Be especially careful that the loaded data  adequately reflects the functionality of your database design.  This  will especially be apparent with the data placed in your associative  tables. 1 of 7
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
CIS 3365 Fall 2011 a. The project team has to develop queries which address all of the  organization’s mandatory requirements as reflected in your  Project’s Problems and Requirements List  that was used in the  Systems Analysis class (ITEC 3343).  The project team also has to  develop reports/queries which illustrate the achievement of the  overall project objective(s).  These reports/queries have to be  divided among the team members resulting in each team member  developing six (6) Queries against a Join of 4 or more Tables. 
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/21/2011 for the course CIS 3365 taught by Professor Detillier during the Spring '11 term at University of Houston.

Page1 / 7

Fall 2011 Database Project Guidelines as of October 13th -...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online