Team Activity - DB Creation and Practice
Working as a Team
This activity is designed to be completed as a team. There are two main purposes for this:
- Develop as a Professional: One of the course outcomes for this course is for you to develop your professionalism and ability to work as an effective team member. This is also a major outcome of the complete program, and it is a skill that employers consistently list as one of the most important traits they are looking for.
- Teach one Another: One of the core principles of the BYU-Idaho learning model is to love, serve, and teach one another. By working together, you will learn this material better as you share your new understanding and learn from your teammates.
Instructions
Complete each of the following activities to setup the database on your server:
You should walk through the steps of these activities together as a group, but each person should individually complete the work on their own server. Make sure to help one another if anyone gets stuck.
Discussion Questions
There are several places in this activity that ask you to discuss questions as a team. The Lead Student should ask the question and then you should discuss the question together. Please note that you will need to respond to each of these questions in a quiz at the end of this activity.
Prepare for the meeting
Prepare for the team meeting by doing the following prior to the meeting:
- Complete your personal learning activities.
- Verify with your team when you will be meeting and who will be the lead student.
Begin with Prayer
Review the Learning Activities
Discuss:
- What was the hardest part of the learning activity?
Create a Database Type
- Complete: Create a database type
Take time to help each other
Remember that each person will complete these steps for their own server. But do not proceed to the next step until each person has successfully completed the task.
Discuss:
- Why would you want to use an enum (Enumeration type) in a database instead of simply using a VarChar (similar to a string) data type?
- Why should you copy the SQL pgAdmin generates and save it to a file?
Create the Tables
- Complete: Create the database tables
Discuss:
- What is the purpose of the line foreign key constraint in the Classification and Inventory relationship?
- What client type will be assigned to a new client entry if one is not specified?
Add the Data
- Complete: Add the data to the database tables
Discuss:
- Why do you not provide the classification id when inserting new data into the classification table?
- Should you commit the inventory-data file to your GitHub repository? Why or why not?
Conclude
As you finish your team meeting, make sure to determine the person that will be the lead student for the next meeting.
Submission
At the end of your team activity, each person needs to individually do the following:
- Make sure your database is working as described in these activities.
- Return to Canvas to take the team activity quiz.
Up Next
- Project: Complete your Database
Other Links:
- Return to: Week Overview | Course Home