Data Model Example Intro Data ✓ Solved

Data Model Example Intro Datahttpswwwyoutubecomwatchtime Cont

Data Model Example - Intro Data Datahttpswwwyoutubecomwatchtime Cont Data Model Example - Intro Data Data Model Example - Superstore Data Vet Clinic Data Model - Part 1 Vet Clinic Data Model - Part 2 BA 325: Data Model/Database Resources Data Model Terminology Data Model Figures: Data Modeling Process: One Method: 1. Identify the Entities 2. Identify the Relationships i. Determine the Interactions ii. Establish the details of the Interactions 3. Determine Unique Identifiers 4. Set the Foreign Keys 5. Identify the Attributes Second Method: 1. Identify the Entities 2. Identify the Attributes 3. Identify the Relationships i. Determine the Interactions ii. Establish the details of the Interactions 4. Determine Unique Identifiers 5. Set the Foreign Keys *Cardinalities: It is important to carefully “read” each relationship both ways. So for example, you will ask: Given a single instance of MOVIE, how many DVDs can that MOVIE be related to? And given a single instance of DVD, how many movies will show up on that DVD? Entity Name Identifier Attribute Attribute ... Entity Name Identifier Attribute Attribute ... Foreign key (FK) (1 or many) (exactly 1, or many) (0 or 1) BA 325: Data Modeling Assignment Information Literacy Reminders: These assignments are open-ended by design and are meant to simulate the type of instructions you would get in a work environment. The goal is to get you comfortable working with datasets and interpreting information. In addition, these activities build the “critical thinking muscle” by requiring you to consider the information resource more critically than you may have previously done. When you are performing your analysis in any given assignment, remember to place context all data and link it to the relevant course concepts. Your conclusions in any given assignment should be supported by your observations/analysis and demonstrate your comprehensive understanding of the topic(s). These assignments are submitted via D2L. Instructions: This assignment tests your analytical ability and ability to interpret a situation, and then create a data model for it. Databases are central to the management of information in business firms. Knowing something about how databases work will also help you better understand the nature of information and what it means to "manage" it. Data modeling is a procedure for discovering the structure of the data involved in a business domain, and it’s an indispensable first step in designing useful and effective databases. You will design a data model from the business case given. Your work on the data modeling assignment will be assessed based on how well your data model explains the relationships within the business case, and how well you explain your reasoning for your specific data model. When you upload your assignment to the D2L Assignments folder, you are stating that the work is your own. All assignments will be evaluated through TurnItIn, so any metadata that is not your own will flag an Academic Integrity Review . Also, you may hand draw your data model but it must be legible and clear. Your Deliverable: · Create a data model that represents the given business situation. (50%) · Be sure to include the following (where necessary): Entities, Unique Identifiers, Relationships, Foreign Keys, and Attributes. · Show the relationships between the entities, using the standard notation we have adopted for our course. · A write-up explaining your reasoning for each of the Entities, Unique Identifiers, Relationships, Foreign Keys, and Attributes. (50%) · This does not need to be a long write-up. Simply have a paragraph per entity, and explain your logic on all the things contained within that entity, and how that entity interacts with any other entity(s). · I will be evaluating the write-up on your general understanding of the data modeling terms we have discussed in this course, and how they relate to this specific business case. Note: · I have generally given you the business case information in bullet point form. This is a more realistic situation to interpret. I recommend reading the situation and capturing things yourself in bullet point format. Once you do that, it should be easier to build out your data model. · The BA 325 Data Model_Database Resources document should be very helpful with steps and terminology for this topic. As a reminder, it is found in D2L -> Content -> Week 5 -> Read . · There are a number of Data Modeling videos posted through the term. None of them are identical to this business case, but all data modeling follows similar general steps. The videos are as follows: · Vet Clinic Data Model – Part 1 (D2L -> Content -> Week 5 -> Watch) · Vet Clinic Data Model – Part 2 (D2L -> Content -> Week 5 -> Watch) · W8.2 – Coffee e-Commerce Data Model (D2L -> Content -> Week 8 -> Watch) · Data Model Example – Intro Data (D2L -> Content -> All Information Literacy Assignments -> Data Model Assignment) · Data Model Example – Superstore Data (D2L -> Content -> All Information Literacy Assignments -> Data Model Assignment) Data Model Business Scenario: Geology Tours Overview of the Business: Kilauea Volcano Crater Tours was created to drive tourism back to the Big Island of Hawaii after the 2017 eruptions ended. It was created by state monument officials, and it uses local academic geologists to create (and lead) a series of crater tours. To date, its promotional efforts and most of its sales have been concentrated on the Western United States. Over the past three years the company’s rate of growth has continued to accelerate. Kilauea Volcano Crater Tours now hopes to take advantage of this opportunity by extending the reach of its promotional and sales efforts to other major urban markets through the Midwest and East Coast, including New York, Boston, Dallas-Fort Worth, and Chicago. Such a move places the company at the threshold of unprecedented growth. On the other hand, Jason Momoa, president of Kilauea Volcano Crater Tours, has recently expressed doubts about whether the company's current approach to order processing, tour creation, and customer relationship management can keep up with the anticipated increase in demand. He has also begun to complain about being unable to get the kinds of information about customers' needs and purchasing patterns that he'll need in order to raise an aggressive and well-targeted marketing campaign in these new regional markets. A description of Kilauea Volcano Crater Tours’ business process and the data involved in that process follows. Business Process: For each geologist, the database should keep track of the geologist's name, highest degree held, and current university affiliation. A geologist who participates in the program usually will stay at the volcanic park for a few weeks, and will therefore typically lead many tours during his/her stay. Each tour, however, is led by just one geologist. For each tour, officials want to record the geologist who leads the tour, the date and time-of-day the tour takes place, and a description of the route the tour takes through the crater. (There are no "standard" routes, and the geologist is free to choose where to go on any given tour.) More than one tour may take place in any given day, and it's even conceivable that two tours might leave at the same time. The database must also keep track of the tourists who sign up for these tours. In this case, we only need to record the person who actually does the signing-up; for example, where a father signs up a family of five for a tour, the database will only have a record for the father. For each tourist (defined in this way), the database should keep track of the tourist's name, home state, and the number of people in his/her party. Obviously, the database must also identify which tour the tourist is signing up for. A tour can (and usually does) accommodate more than one tourist and his/her party. Also, there is no restriction on how many times a given tourist can sign up to tour the crater. At the end of each tour, each tourist (again, this is the person of record in the database) is given the opportunity to submit a card giving comments on his/her experience on the tour.

Sample Paper For Above instruction

The given business scenario describes Kilauea Volcano Crater Tours, a tourism company on the Big Island of Hawaii, which offers crater tours led by local geologists. The company aims to expand its markets and improve customer relationship management to support its growth. To accurately represent this business environment, a comprehensive data model is necessary that captures the key entities, their identifiers, relationships, foreign keys, and attributes. This paper will develop a detailed data model and provide a rational explanation for each component, demonstrating understanding of data modeling principles within this context.

Entities and Their Rationales

The primary entities in this scenario are Geologists, Tours, Tourists, and Comments. Each entity encapsulates essential information to facilitate operational tracking and strategic analysis.

Geologists

The Geologists entity records the information about the geologists leading the tours. Its primary attributes include GeologistID (PK), Name, HighestDegree, and UniversityAffiliation. GeologistID serves as a unique identifier to distinguish each geologist, especially when multiple geologists might share the same name or degree level. The Name attribute captures the geologist’s full name, while HighestDegree records educational qualifications, and UniversityAffiliation notes their current academic institution. The entity is linked to Tours via the GeologistID, indicating which geologist leads each tour.

Tours

The Tours entity represents individual crater tours. It includes TourID (PK), GeologistID (FK), Date, Time, and RouteDescription. TourID uniquely identifies each tour for scheduling and tracking. GeologistID as a foreign key links each tour to the geologist responsible for leading it. Date and Time denote when the tour occurs, allowing for scheduling multiple tours per day or overlapping times. RouteDescription contains a narrative of the specific crater route taken, which varies by tour and geologist.

Tourists

Tourists are represented by the Tourists entity, with attributes such as TouristID (PK), Name, HomeState, and PartySize. TouristID uniquely identifies each tourist for tracking and data analysis. Name provides the tourist’s full name, HomeState records their residence, and PartySize indicates the number of individuals in their party, essential for capacity planning.

Signups

A linking entity, Signups, captures which tourists sign up for which tours. Its composite key consists of TourID (FK) and TouristID (FK). This relationship allows multiple tourists (or their parties) to register for multiple tours without duplication issues. Signups ensures the many-to-many relationship between tourists and tours is properly represented.

Comments

Comments gather feedback from tourists about their experiences. The Comments entity includes CommentID (PK), TouristID (FK), TourID (FK), and CommentText. CommentID uniquely identifies each comment, while TouristID and TourID establish which tourist and tour the feedback pertains to. This helps in analyzing customer satisfaction and improving future tours.

Relationships and Cardinalities

The relationships in this data model reflect the operational flow and data dependencies. Each Geologist can lead many Tours, establishing a one-to-many relationship from Geologists to Tours. Each Tour is led by one Geologist, indicating a many-to-one relationship from Tours back to Geologists. Tours can have multiple Tourists simultaneously, and tourists can participate in multiple tours over time, which is modeled through the Signups entity, forming a many-to-many relationship. Comments are associated with one Tour and one Tourist, establishing a one-to-many relationship from Tours and Tourists to Comments, respectively. Correctly reading and implementing these relationships ensures the model accurately reflects real-world interactions and supports data integrity.

Conclusion

In conclusion, the proposed data model encapsulates essential entities, their identifiers, relationships, and attributes, aligning with the business scenario of Kilauea Volcano Crater Tours. This model facilitates operational efficiency, supports strategic decision-making, and provides a clear structure for expanding the business into new markets. The rationalization of each component demonstrates an understanding of data modeling principles applied to tourism management, ensuring a scalable, maintainable, and logically coherent database system.

References

• Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7th ed.). Pearson.