MIS6211 Data Management SU01

User Generated

Xpzbz0917

Computer Science

MIS6211

South University

MIS

Description

Revisit your OLTP data model and logical database. Address any comments you received from the professor after Week 2 and improve your data model and logical database. Address as many physical design aspects as possible. For completeness, formulate five SQL queries to demonstrate your understanding of that language. Some of your queries must use the INNER JOIN operation construct or the WHERE conditional construct (Note: SQL was covered in a Week 1 activity, in the Week 1 required readings from your text, and in supplemental material).

Revisit your OLAP data model and address any comments you received from the professor in Week 4 to improve your data model.

Produce a plan that addresses the data-quality management function for data governance of your case study.



Datatypes and attributes for the database model of CVS

From the developed EER model, there are four entities of interest to the functionality of the information system and in getting an alignment with the business processes along with the attainment of flexibility and interoperability in the IT environment. The entities are stated with attributes that build onto their features. The entities highlighted in the EER model include Patient, Patient Medical history, Clinical Service support, and Doctor examination and recommendations. The entities are relational and, as such, seem to be affecting one another. An example is dependence on the patient’s medical history, which determines the dosage and prescription a patient must adhere to in their treatment plan. The dosage and prescription are provided due to the medical professionals examining the patient’s health and checking on their medical history. A relational database model could thus be designed to hold the content; the entities can be captured as tables, and the attributes listed as columns. The instances such as the exact name and address of the patients can be captured in the rows thereof in the tables that they are relating to capture the details that are of necessity in managing the patients’ data and affording them required clinical advice and services such as providing them with prescription drugs.

CVS Relational Database Model

Patient’s table

Attributes

Datatype

Name

Short text

Patient ID

Autonumber

Address

Long text

Date of Birth

Long date

Patient medical records

Medical condition

Long text

Prescription

Long text

Dosage

Long text

Doctor in charge

Number

Clinical service support

Health info cross-check

Long text

Medical professionals

Name

Short text

Professional ID

Long text

Place of work

Long text

Specialization

Long text

Technical plan for data architecture management

The Corporation is developing a patient data information system to support the business process. The system is desired to be fully integrated to serve its intended purpose as captured. The information system is to be developed regarding the EAP framework to ensure that it is integrated for use by the Corporation. The provisions, as noted from the FEAF, will be considered in developing the patient data information system. The Zachman framework will be used to break down the needs of the information system and, as such, capture the requirements in terms of actors, resources, and data sources that may be used.

The patient data information system is to be developed in line with several goals that inform its scope and functionality that coincide with supporting the business process (Howard et al., 2020). The goal is to help the Corporation present its customers with a system that allows them to confirm and update their medical profiles. This will entail maintaining patients’ details in a manner that affirms that the system is timely and well-integrated. The patients can be sure that they will be enabled to procure prescription drugs in the specified dosage as the database consults with various sources to have patients provided with medical drugs that are safe for them. The patient data information system will be created with capabilities that allow data capturing in all instances, either by doctors issuing prescriptions after diagnosis on the patients or when patients update their information as appropriate for them, say when they are relocated. The patients, even when relocating, can be sure that the data of their medical records will be maintained as accurate and timely. The data visualization tool will be chosen to ensure that the patients are empowered to interact with what is being presented. The information system will be built with the capabilities of generating reports for analysis needs. 


Week 4 Project

CVS Data Warehouse Creation

In today's business world, data is a valuable asset for organizations to make informed decisions and drive growth. A data storage facility, also known as a database table, is a consolidated repository used for information monitoring and reporting that organizes and optimizes data from numerous sources. Consumer Value Stores (CVS), a retail pharmacy chain, can benefit from creating a data warehouse or data mart from its database to enhance its decision-making capabilities. This essay will discuss the process of creating a data warehouse or data mart from CVS' database and the benefits it can bring to the organization.

A database server or data repository is a crucial part of the data infrastructure since it allows for well-informed decision-making and offers useful information. In the case of CVS, creating a data warehouse or data mart involves transforming the current logical schema of the database from an OLTP (Online Transaction Processing) type of schema to an OLAP (Online Analytical Processing) type of schema.An OLTP (Online Transaction Processing) database is optimized for fast and efficient data entry, modification, and retrieval for transaction processing purposes (Watson, 2016, p. 4). In contrast hand, an OLAP system offers impromptu searches and analytics and is created for a comprehensive study of big information sets. (Online Analytical Processing) database, on the other hand, is designed for multi-dimensional analysis of large data sets and supports ad-hoc queries and reporting. This is typically done by following the dimensional data model architecture.

The dimensional data model is a key component of OLAP schema and is based on the concept of fact tables and dimension tables. Although dimensional records give the information structure and classifications, fact databases only contain operational information, like transactions. For example, a fact table in the CVS data warehouse could contain information about sales, including date, product, store, and sales amount. The dimension tables could include product dimensions, store dimensions, and time dimensions. Product dimensions would include information about the product, such as name, brand, and category, while store dimensions would provide information about the location, such as city, state, and region. Time dimensions would provide information about the date, such as day, week, month, and year.

Incorporating a dimensional data model in the CVS data warehouse would allow for more advanced querying and analysis of the data while maintaining its integrity and consistency. This would be especially beneficial for trend analysis, as well as identifying sales patterns and consumer behavior. For example, the database could be utilized to identify the top-selling goods by time and place or to assess how promotions affect sales. Overall, transforming the logical schema of the database to a dimensional data model is an important step in creating a data warehouse or data mart for CVS (Watson, 2016, p. 4). This type of schema provides a more structured approach to storing and analyzing data, enabling informed decision-making and improved performance.

The creation of a data warehouse or data mart also involves adding a temporal property to the data model to incorporate the notion of time. The dimensional data architecture concepts provide a systematic approach to organizing the data in a manner that is meaningful, flexible, and efficient. Dynamic database technology's main principle is to organize the information in line with the fundamental business operations. This involves identifying the core dimensions that capture the business context and the facts that capture the relevant measurements or KPIs. The resulting data model is typically organized as a star or snowflake schema, where the dimensions form the central hub, and the facts are connected to them via relationships.

For the case of CVS, the core dimensions could include time (to capture the temporal aspect), store, product, and customer. The facts could include sales, inventory levels, and customer demographics. By organizing the data in this manner, it becomes possible to easily answer questions such as: What were the sales for a specific store and product category during a certain time period? What was the average inventory level for a particular product across all stores during a specific month? Who were the customers that made a purchase in a specific store during a certain period, and what were their demographics? To incorporate the notion of time, the time dimension can be modeled in different ways, such as by day, week, month, quarter, or year (Chen, 2019, p. 120). The choice of granularity depends on the business requirements and the level of detail needed to answer specific questions. For example, if the goal is to analyze sales trends at a monthly level, the time dimension can be modeled as month. If, on the other hand, the goal is to analyze daily sales patterns, the time dimension can be modeled as day. Ultimately, incorporating a temporal property into the data model is an important step in creating a data warehouse or data mart for CVS. The dimensional data architecture concepts provide a systematic approach to modeling the data in a manner that supports the business requirements and enables effective analysis.

In conclusion, creating a data warehouse or data mart dataset from your database on a Consumer Value Store (CVS) is a crucial step towards better data-driven decision-making. TThe procedure entails gathering pertinent data from numerous resources, formatting it consistently, transferring it to a single location, and developing a structure that allows effective searching and evaluation. The end result is a single source of truth that provides valuable insights into the performance of CVS, enabling business owners to make informed decisions that drive growth and profitability. The benefits of having a data warehouse or data mart are clear, and the process of creating one is straightforward with the right tools and approach. With the increasing importance of data in today's business landscape, it is imperative that companies invest in a data warehouse to stay competitive and thrive in the future. 

Unformatted Attachment Preview

Explanation & Answer:
3 pages
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

View attached explanation and answer. Let me know if you have any questions.

Strategic Management Problem-Solving Template (SMPT)

MGMT 661
Course Section _______

Student Name:
___________________________________

Student #
____________________________________

Date of Submission:
______________________________

Table of Contents
INSTRUCTIONS .................................................................................................................................................. 3
TABLE 1.1 – ANALYSIS OF MANAGEMENT STRATEGIES FOR BUSINESS ....................................... 4
TABLE 2.1 – ANALYSIS OF VISION STATEMENT OF THE BUSINESS ................................................ 5
TABLE 2.2 – ANALYSIS OF THE MISSION OF THE COMPANY............................................................. 6
TABLE 2.3 - STRATEGIC ANALYSIS – STAKEHOLDER POSITIONS ................................................... 8
TABLE 3 - STRATEGIC ANALYSIS – IMPACT OF CRITICAL ISSUES ON STRATEGIES .............. 10
TABLE 3.1 - CRITICAL ISSUES IN THE CONTEXT OF MANAGEMENT STRATEGIES ................. 11
LIST ANY ISSUES YOU HAVE DETERMINED IN EACH CATEGORY IN TABLE 3.1-3.5. .............. 11
FINANCE ............................................................................................................................................................ 11
TABLE 3.1 - CRITICAL ISSUES IN THE CONTEXT OF MANAGEMENT STRATEGIES ................. 11
HUMAN RESOURCES ..................................................................................................................................... 11
TABLE 3.3 - CRITICAL ISSUES IN THE CONTEXT OF RECOMMENDED MANAGEMENT
STRATEGY - ...................................................................................................................................................... 12
IT/MIS.................................................................................................................................................................. 12
TABLE 3.4 - CRITICAL ISSUES IN THE CONTEXT OF RECOMMENDED MANAGEMENT
STRATEGY - OPERATIONS ........................................................................................................................... 12
TABLE 3.5 - CRITICAL ISSUES IN THE CONTEXT OF RECOMMENDED MANAGEMENT
STRATEGY –...................................................................................................................................................... 13
MARKETING ..................................................................................................................................................... 13
NOT REQUIRED TABLE 3.6 – VERTICAL CAUSAL ANALYSIS ........................................................... 14
TABLE 3.7 – DEVELOPMENT OF WHAT NEED TO BE ADDRESSED STATEMENTS ..................... 15
COMMENTS– OBSERVATIONS AND CONCLUSIONS REGARDING DIAGNOSIS .......................... 16
TABLE 4.1 – EVALUATION OF ALTERNATIVE SOLUTIONS & RECOMMENDATIONS .............. 18
TABLE 4.2 – EVALUATION OF ALTERNATIVE SOLUTIONS & RECOMMENDATION ................. 19
TABLE 4.3 – EVALUATION OF ALTERNATIVE SOLUTIONS & RECOMMENDATION ................. 20
TABLE 5 – RECOMMENDATION DETAIL ................................................................................................. 21
TABLE 5 – RECOMMENDATION DETAIL ................................................................................................. 22
TABLE 6 – SWOT ANALYSIS DATA GATHERING TABLE (STRATEGY) .................................................... 23
TABLE 7 THE FIVE FORCES OF COMPETITION IN THE INDUSTRY .................................................................... 24
PORTER'S FIVE FORCES (FOR THE BUSINESS IDENTIFIED FOR TEAM PROJECT) ........................................ 24
OPTIONAL TABLE 7.` INDUSTRY KEY SUCCESS FACTORS ................................................................................. 25
OPTIONAL TABLE 7.2 INDUSTRY PROSPECTS AND OVERALL ATTRACTIVENESS ............................................ 26
TABLE 7.3 THE BUSINESS ENVIRONMENT, PEST OR PESTLE ........................................................................ 26

Instructions






The required company you should work on for this template is "My Party Album Inc."
The information about this business owner (My Party Album Inc.) have been provided and
uploaded to you as additional materials. However, you are not limited to the provided
information, please do your own research and use information from class lectures.
Respond to all sections.
This assignment is to be completed by each individual student.
Entries should be single-spaced. Use bullet points only if your points are very clear and easy to
understand, otherwise use full sentences. Unclear points could be marked down due to lack of
clarity.

Table 1.1 – Analysis of Management Strategies for Business

Strategy 1: Product differentiation through innovation

Briefly Identify & Describe
the Management Strategy

To emphasize a reliable and competitive application that allows
consumers to upload, store and share pictures of their memories
depending on the presenting needs through product
differentiation. This strategy is adaptive since it focuses
primarily on differentiating the existing product to match the
existing industrial trends. Similarly, this strategy will allow the
firm to increase customer satisfaction since the resulting
product will be an improvement of the existing platform. The
resulting application will integrate strategic features informed
by innovation, refined market connection, and alignment with
consumer demands to ensure competitiveness (Future Market
Insights, 2022).


Benefits/ Advantages



Critical
Success
Factors

Threats/
Risks

Is this your recommended
strategy? If not, what do
you recommend?





The strategy emphasizes customer satisfaction which will
promote engagement and strategic returns.
Ability to reach a large consumer base.
The growth of the need to preserve memories has created a
market gap for the firm and the application which will
support progressive consumer engagement.

The average number of new clients using the platform.
The total number of albums created within a given time.
Positive feedback from the application users and clients
depends on the quality of the services offered (My Party
Album, 2022).
• Continuous and positive impacts on the client experience
when creating, uploading, and sharing memories of their
encounters.
• The average number of engagements across the social
platforms for the firm.
• Increased competition from dominant platforms like Google
Photos, Dropbox, and Google Drive.
• Secondly, the platform must comply with the prevailing data
security regulations in Canada and in the international
platform concerning personal information sharing.
• Changing tastes and preferences of users may undermine the
success trends.
This strategy is recommended because it focuses more on the best
approaches that the firm may use to satisfy its consumers. The
majority of consumers are concerned about creating memories and
not "missing out" on critical events that one may have limited
resources to capture. For example, couples at a wedding may not
have the time to take the necessary pictures and short videos about
their experience. However, inviting people to a party would allow
them to take pictures and short videos, which would be shared

across a common platform. Therefore, this strategy is recommended
because it will ensure the reliability of the platform in creating
memories from collaborative interactions of private participants
(My Party Album, 2022).

Table 2.1 – Analysis of Vision Statement of the Business
Also refer to Chapter 3 lecture material, chapter readings, and videos posted on Moodle.

Description/Analysis

Briefly Identify the Vision
of the Company and the
source. Are Company
Values also provided?
Identify the source.

Benefits/ Advantages of a
Vision statement

If you cannot locate a
Vision, identify the impact
this could have on the
company.

The vision for the company can be defined as the desire to
become the best platform that allows people to capture, curate,
share, and create memories while ensuring that no moments are
missed out. The vision for the company comes from the idea
that many people miss essential moments in events like a
wedding because they cannot be at different places at the same
time. The company bridges this gap by creating an application
that enables users to invite members to a party who would
capture and share memories. The firm has not offered its core
values, but confidentiality, security, reliability, and availability
are some of the attributes that define its services (My Party
Album, 2022).
The vision statement provides a long-term goal that the firm intends
to achieve.
The vision statement creates a sense of direction that must be
accomplished within a given setting to ensure success.
The firm leverages its vision to progressively advance its
application to match the client and market needs.

The vision for the company is not explicitly defined. This
observation may affect the firm since consumers and visitors are
concerned about the direction and the intentions defining a firm. A
vision statement provides the ultimate direction and intentions that a
firm seeks to achieve. Having a vision statement ensures trust from
the target consumers.

Threats/
Risks re lack of Vision

The lack of a vision may present critical threats to the firm. The first
threat is reduced market share since consumers may not have the
ideal connection with the firm.
Secondly, it is possible to reduce competitiveness since consumers
are attracted to companies that have an explicit direction.
Poor strategy development due to the lack of a common direction.
Poor insight into company performance since it is not possible to
assess the short and long-term goals.

The first recommendation is for the firm to create a common vision
What would you
that is listed on its landing page. Also, the firm should create a value
recommend to the business? statement that displays the overall principles that guide its
Provide your rationale to
operations and their implications on the consumers. The rationale
support.
for this recommendation is to give the firm a sense of direction and
a strategic framework for measuring its success. The vision
statement would be used as a reference framework through which
the management may gauge its progress in deploying interventions
and improving its service delivery.
Table 2.2 – Analysis of the Mission of the Company

Des...


Anonymous
Great content here. Definitely a returning customer.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags