Database Design (Data and Information Management)
Timeline
-
March 5, 2023Experience start
-
March 9, 2023Project Scope Meeting
-
March 31, 2023Submission of conceptual database design
-
April 10, 2023Conceptual database design
-
April 17, 2023Conceptual database design
-
May 27, 2023Experience end
Timeline
-
March 5, 2023Experience start
-
March 9, 2023Project Scope Meeting
Meeting between students and company to confirm: project scope, communication styles, and important dates.
-
March 31, 2023Submission of conceptual database design
Students submit their conceptual design in the form of an ERD according to crow's foot notation.
-
April 10, 2023Conceptual database design
The teaching team will provide feedback on the conceptual design submissions.
-
April 17, 2023Conceptual database design
Students will revise their conceptual database design, based on the feedback they've received.
-
May 27, 2023Experience end
Experience scope
Categories
Databases Data modellingSkills
database strategyLooking to elevate your organization, and bring it to the next level? Bring on students from Australian Catholic University 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 learn foundational knowledge and practical skills in database design and implementation. They will develop their skills in identifying and modeling organizational information requirements; developing conceptual data models and verifying their structural characteristics with normalization techniques; implementing a database using a Relational Database Management System (RDBMS) and Structured Query Language (SQL). In addition, the course introduces database administration activities and ethical considerations in handling organizational data.
Students
Deliverables are negotiable and will seek to align the needs of the students and the organization.
Some final project deliverables might include:
- Conceptual design: A detailed report including data/information requirement research, logical data model using entity relationship diagram (ERD)
- Physical design: the database schema
- Implemented Database
Project timeline
-
March 5, 2023Experience start
-
March 9, 2023Project Scope Meeting
-
March 31, 2023Submission of conceptual database design
-
April 10, 2023Conceptual database design
-
April 17, 2023Conceptual database design
-
May 27, 2023Experience end
Timeline
-
March 5, 2023Experience start
-
March 9, 2023Project Scope Meeting
Meeting between students and company to confirm: project scope, communication styles, and important dates.
-
March 31, 2023Submission of conceptual database design
Students submit their conceptual design in the form of an ERD according to crow's foot notation.
-
April 10, 2023Conceptual database design
The teaching team will provide feedback on the conceptual design submissions.
-
April 17, 2023Conceptual database design
Students will revise their conceptual database design, based on the feedback they've received.
-
May 27, 2023Experience end
Project Examples
Requirements
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.
Project activities that students can complete may include, but are not limited to:
- identifying and modeling organizational information requirements
- Creating a conceptual database design for a given industry partner
- Creating a database based on the conceptual design to address the organizational information requirements of the industry partner
Additional company criteria
Companies must answer the following questions to submit a match request to this experience:
Additional company criteria
Companies must answer the following questions to submit a match request to this experience:
Timeline
-
March 5, 2023Experience start
-
March 9, 2023Project Scope Meeting
-
March 31, 2023Submission of conceptual database design
-
April 10, 2023Conceptual database design
-
April 17, 2023Conceptual database design
-
May 27, 2023Experience end
Timeline
-
March 5, 2023Experience start
-
March 9, 2023Project Scope Meeting
Meeting between students and company to confirm: project scope, communication styles, and important dates.
-
March 31, 2023Submission of conceptual database design
Students submit their conceptual design in the form of an ERD according to crow's foot notation.
-
April 10, 2023Conceptual database design
The teaching team will provide feedback on the conceptual design submissions.
-
April 17, 2023Conceptual database design
Students will revise their conceptual database design, based on the feedback they've received.
-
May 27, 2023Experience end