- Description
DAT 380 Wk 1 Discussion – ERD Components
Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to classmates or your faculty member.
Due Day 3
Respond to the following in a minimum of 175 words:
Databases are made up of sets of data that have a relationship with one another. An entity relationship diagram, more commonly known as an ERD, may be used to visually show the relationships among data sets. There are several symbols used within an ERD that represent various components.
Throughout the next several weeks, you’ll be reviewing and building these diagrams and will have to identify the appropriate visuals. Select one of the five main components of an ERD. Define the component and describe the symbol used in diagrams for your chosen component. Explain why it’s important for the component to be specified.
Due Day 7
Post 2 replies to classmates or your faculty member. Be constructive and professional.
DAT 380 Wk 2 Discussion – Database System vs. Database Model
Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to classmates or your faculty member.
Due Day 3
Respond to the following in a minimum of 175 words:
Explain the difference between a database system and a database model. Discuss examples of when you would use a hierarchical, network, relational, and NoSQL model.
Due Day 7
Post 2 replies to classmates or your faculty member. Be constructive and professional.
DAT 380 Wk 3 Discussion – Subqueries
Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to classmates or your faculty member.
Due Day 3
Respond to the following in a minimum of 175 words:
Subqueries are queries listed inside another statement or query. They are used to narrow down information in a database. Discuss the differences between a regular subquery and a correlated subquery. Provide an example of one or both subqueries.
Due Day 7
Post 2 replies to classmates or your faculty member. Be constructive and professional.
DAT 380 Wk 4 Discussion – ER Diagrams vs. EER Diagrams
Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to classmates or your faculty member.
Due Day 3
Respond to the following in a minimum of 175 words:
Read the blog article “ER Diagrams vs. EER Diagrams: What’s the Difference?” After reading the article, locate another blog on this topic. In your own words, define EER diagrams and explain how they compare to ER diagrams. Cite your source at the end of your response according to APA guidelines.
Due Day 7
Post 2 replies to classmates or your faculty member. Be constructive and professional.
DAT 380 Wk 5 Discussion – Database Life Cycle Phases
Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to classmates or your faculty member.
Due Day 3
Respond to the following in a minimum of 175 words:
The database life cycle (DBLC) defines the phases for implementing a database. This week focuses on the logical design phase because that’s when you focus on creating an ERD and planning your architecture; however, the other phases are just as important and have a significant impact on the final product. Different DBLC models list different phases, but all are important.
Select another phase of the DBLC from any of the DBLC models. Explain the tasks within that phase and how the logical design phase is affected. Be sure to give a brief synopsis of the model you’re using and cite any resources.
Due Day 7
Post 2 replies to classmates or your faculty member. Be constructive and professional.