Database App Development
Timeline
-
September 18, 2017Experience start
-
October 3, 2017Conceptual Design
-
October 12, 2017Table Normalization
-
December 5, 2017Database impelementation
-
December 8, 2017Experience end
Timeline
-
September 18, 2017Experience start
-
October 3, 2017Conceptual Design
Meeting between students and organization to confirm: project scope, data entities and entity relationships.
-
October 12, 2017Table Normalization
Convert entity relationship diagram into relational schema. Normalize the relational schema.
-
December 5, 2017Database impelementation
Students implement database design using SQL script. Business rules are implemented using triggers. GUI is created using VB.NET or C# or any language. Testing database prototype. Present and demo the prototype in class during the week of December 4th.
-
December 8, 2017Experience end
Experience scope
Categories
Skills
networking & information systems data optimization data strategy programmingThis Fall, in teams of 4, Upper-Level Student-Consultants will design and implement a new or refurbished database application for your organization.
Learners
Phase 1 Project Plan: Student-consultants will meet with organization representative(s) to devise the project scope and prepare a detailed plan for completion of the project.
Phase 2 Project Execution: Students will work on deliverables outlined in the project plan. The team will periodically communicate with organization representative(s) as needed to complete project tasks.
Phase 3 - Outcome: The final project deliverables include:
- Entity Relational Diagram (database design)
- Normalized relational schema (logical design)
- A working prototype (functional database)
Project timeline
-
September 18, 2017Experience start
-
October 3, 2017Conceptual Design
-
October 12, 2017Table Normalization
-
December 5, 2017Database impelementation
-
December 8, 2017Experience end
Timeline
-
September 18, 2017Experience start
-
October 3, 2017Conceptual Design
Meeting between students and organization to confirm: project scope, data entities and entity relationships.
-
October 12, 2017Table Normalization
Convert entity relationship diagram into relational schema. Normalize the relational schema.
-
December 5, 2017Database impelementation
Students implement database design using SQL script. Business rules are implemented using triggers. GUI is created using VB.NET or C# or any language. Testing database prototype. Present and demo the prototype in class during the week of December 4th.
-
December 8, 2017Experience end
Project Examples
Requirements
Beginning this September, student-consultants in a group of 4 will dedicate 140+ hours over the entire semester developing a custom database application for your organization.
The students will conduct a conceptual database design (Entity Relationship Modeling), logical design (Normalization), and implementation using Oracle 12c.
Project scope may include:
- Examine an organizational data requirement and propose a new database to support operations
OR
- Examine an existing database that doesn't meet organizational requirements and propose appropriate updates and improvements
AND
- Create a custom database application solution that supports your organization's operational needs
Additional company criteria
Companies must answer the following questions to submit a match request to this experience:
Timeline
-
September 18, 2017Experience start
-
October 3, 2017Conceptual Design
-
October 12, 2017Table Normalization
-
December 5, 2017Database impelementation
-
December 8, 2017Experience end
Timeline
-
September 18, 2017Experience start
-
October 3, 2017Conceptual Design
Meeting between students and organization to confirm: project scope, data entities and entity relationships.
-
October 12, 2017Table Normalization
Convert entity relationship diagram into relational schema. Normalize the relational schema.
-
December 5, 2017Database impelementation
Students implement database design using SQL script. Business rules are implemented using triggers. GUI is created using VB.NET or C# or any language. Testing database prototype. Present and demo the prototype in class during the week of December 4th.
-
December 8, 2017Experience end