Database Design and Implementation
Timeline
-
March 23, 2023Experience start
-
April 1, 2023Timeline 1 - Database normalization and logical design
-
April 15, 2023Timeline 2 - Data migration
-
April 18, 2023Sprint 3. Problem solving (2)
-
April 24, 2023Timeline 3 - Data integrity, backup and disaster recovery, and security
-
May 6, 2023Timeline 4 - Testing and Delivery
-
May 7, 2023Experience end
Timeline
-
March 23, 2023Experience start
-
April 1, 2023Timeline 1 - Database normalization and logical design
Analyze the client spreadsheet table, identify functional dependencies, transform it to Boyce–Codd normal form (BCNF), and create database logical design.
-
April 15, 2023Timeline 2 - Data migration
The goals of this timeline 2 are to create tables and import the company data.
-
April 18, 2023Sprint 3. Problem solving (2)
As for the project of designing a new database, this sprint aims to refine ER diagram and the relational schema and normalize your database design.
-
April 24, 2023Timeline 3 - Data integrity, backup and disaster recovery, and security
The goals of this timeline is to practice the considerations of data integrity, backup and disaster recovery, and security in database designs.
-
May 6, 2023Timeline 4 - Testing and Delivery
Write necessary SQL queries, views, and stored programs, test your database design, and optimize database performance. Fill your solution in the section of the timeline 4 in the project report same as in the timeline 1. Make a live presentation.
-
May 7, 2023Experience end
Categories
Information technology Databases Data modelling Data scienceSkills
data management communication data modelingLooking to elevate your organization, and bring it to the next level? Bring on students from the University of North Carolina at Charlotte to be your student consultants, in a project-based experience. Students will work on one main project over the course of the semester, connecting with you as needed with virtual communication tools.
Students in this program/course will explore the modeling, programming, and implementation of database systems. The course mainly focuses on relational database systems. Topics include (1) modeling: conceptual data modeling, ER diagram, relational data model, schema design, normalization, and refinement; (2) programming: relational algebra and calculus, SQL, constraints, triggers, views; (3) implementation: data storage, indexing, query execution, query optimization, and transaction management.
Deliverables are negotiable and will seek to align the needs of the students and the organization.
Some final project deliverables might include:
- A report detailing the problem recommended solutions and a concrete action plan including code/SQL/scheme to put the solution into place.
- All source code used throughout the project, in the form of an online repository (github, etc.) or a compressed folder (zip, tar). Please ensure we have sufficient privileges to view any online source code.
Project timeline
-
March 23, 2023Experience start
-
April 1, 2023Timeline 1 - Database normalization and logical design
-
April 15, 2023Timeline 2 - Data migration
-
April 18, 2023Sprint 3. Problem solving (2)
-
April 24, 2023Timeline 3 - Data integrity, backup and disaster recovery, and security
-
May 6, 2023Timeline 4 - Testing and Delivery
-
May 7, 2023Experience end
Timeline
-
March 23, 2023Experience start
-
April 1, 2023Timeline 1 - Database normalization and logical design
Analyze the client spreadsheet table, identify functional dependencies, transform it to Boyce–Codd normal form (BCNF), and create database logical design.
-
April 15, 2023Timeline 2 - Data migration
The goals of this timeline 2 are to create tables and import the company data.
-
April 18, 2023Sprint 3. Problem solving (2)
As for the project of designing a new database, this sprint aims to refine ER diagram and the relational schema and normalize your database design.
-
April 24, 2023Timeline 3 - Data integrity, backup and disaster recovery, and security
The goals of this timeline is to practice the considerations of data integrity, backup and disaster recovery, and security in database designs.
-
May 6, 2023Timeline 4 - Testing and Delivery
Write necessary SQL queries, views, and stored programs, test your database design, and optimize database performance. Fill your solution in the section of the timeline 4 in the project report same as in the timeline 1. Make a live presentation.
-
May 7, 2023Experience end
Project Examples
Students in groups of 3-5 will work with your company to identify your needs and provide actionable recommendations, based on their in-depth research and analysis.
Activities that students can complete may include, but are not limited to:
- Applying conceptual data modeling techniques such as the Entity-Relationship model to define database designs for application systems
- Applying logical data modeling techniques such as the Relational model to implement database designs for application systems
- Applying normalization theory to refine database design to avoid redundancy, update anomalies, insert anomalies, and delete anomalies
- Applying indexing techniques to improve the efficiency of retrieval of records from a data file
- Utilizing SQL and a common Database Management System to implement a well-designed database system
Project examples:
1) Design a new database: Based on the business requirements you provide, including user stories and constraints, students will propose a correct, concurrent, efficient, and secure database for you.
The solutions provided by students can be launched directly into your database management systems and integrated into your organization's infrastructure.
2) Analyze and tune databases: Based on the data you provide, including information on specific problems, slow queries, or clumsy tables, students will propose specific improvements for your data storage and querying.
The solutions provided by students will be mocked up with example data and can be implemented directly into your existing database.
Topics include, but are not limited to:
- Finding an improved data storage solution.
- Decreasing query execution time.
- Improving and normalizing table schema.
3) Critical query and reporting: Based on table structures and the business query or reporting requirements you provide, students will propose efficient query reporting for you.
The solutions provided by students can be executed directly on your database management systems.
Companies must answer the following questions to submit a match request to this experience:
Be available for a meeting with the instructor to initiate your relationship and confirm your scope is an appropriate fit for the course, and sign the appropriate University paperwork confirming the relationship.
Provide a dedicated contact person who is available for weekly drop-ins to address students’ questions as well as periodic messages over the duration of the project.
Provide feedback to student teams on the reports of each project timeline.
Provide business requirements document(s), user stories document(s), and necessary data for the project.
How is your project relevant to the course?
Provide an opportunity for students to present their work and receive feedback on the presentation.
Complete a short report assessing the students' participation in the project.
Timeline
-
March 23, 2023Experience start
-
April 1, 2023Timeline 1 - Database normalization and logical design
-
April 15, 2023Timeline 2 - Data migration
-
April 18, 2023Sprint 3. Problem solving (2)
-
April 24, 2023Timeline 3 - Data integrity, backup and disaster recovery, and security
-
May 6, 2023Timeline 4 - Testing and Delivery
-
May 7, 2023Experience end
Timeline
-
March 23, 2023Experience start
-
April 1, 2023Timeline 1 - Database normalization and logical design
Analyze the client spreadsheet table, identify functional dependencies, transform it to Boyce–Codd normal form (BCNF), and create database logical design.
-
April 15, 2023Timeline 2 - Data migration
The goals of this timeline 2 are to create tables and import the company data.
-
April 18, 2023Sprint 3. Problem solving (2)
As for the project of designing a new database, this sprint aims to refine ER diagram and the relational schema and normalize your database design.
-
April 24, 2023Timeline 3 - Data integrity, backup and disaster recovery, and security
The goals of this timeline is to practice the considerations of data integrity, backup and disaster recovery, and security in database designs.
-
May 6, 2023Timeline 4 - Testing and Delivery
Write necessary SQL queries, views, and stored programs, test your database design, and optimize database performance. Fill your solution in the section of the timeline 4 in the project report same as in the timeline 1. Make a live presentation.
-
May 7, 2023Experience end