Entity- Relationship (ER) Model

For this assignment, you will tackle the comprehensive task of conducting the data modeling and database design for the information systems of an organization operating in a domain of your choice. In parallel, you will also create a data governance plan for your organization. You will apply the data management notions in this course to a selected case study for your organization.
You will first define the scope of your organization, describe its data management needs, and explain how the data support your organization’s critical mission. Next, you will create a detailed data model for a critical information system in your organization. You will start with requirements, then generate logical data modeling decisions which will culminate in an entity-relationship diagram for your organization’s data.
As a next step, you will use your data model to create a logical database architecture for your organization’s IS. You will then discuss a plan for transforming your logical database architecture to a physical architecture.
As a last step in your data modeling experience in this course, you will think in terms of creating a temporal database for a data warehouse or a data mart, which are data architecture notions that you will learn about in Week 4. Starting from your logical database, you will create what is referred to as a dimensional logical database well suited for use in a data warehouse or data mart.
In parallel with your data modeling tasks, you will examine and assess the data management practices in your organization, focusing on key management functions.
You will be completing this project in five weeks. In each week, you will work on a component of your report.
Background of Enterprise Data: Selecting Your Case Study
This week, your task for the project is to research in the South University Online Library and the Internet to identify a case study of your choice with a pertinent IT/IS capability with significant data needs, either as an essential asset in support of your case study’s business mission or as an integral part of your case study’s critical mission.
Some examples could be:
• Healthcare organizations, such as
o Healthcare insurance company
o Major hospital
o Medical laboratory
• Academic institutions, such as
o University or professional institute
• Commerce and transportation center or services, such as
o Major airport or maritime port
• Transportation carriers, such as
o an airline company
o a railroad company
• Network service providers, such as
o Telecommunications service carrier/provider
o Internet and voice digital service provider or Cloud service provider
• Media organizations, such as
o Television network
o Multimedia service operator
• Manufacturing firms, such as
o Computer products manufacturer
o Car manufacturer
o Hardware manufacturer
• Major retailers, such as
o Food retailer
o Home maintenance retailer
o Clothing outlet
• Entertainment complexes, such as
o Hotel
o Vacation resort
o Large recreation and entertainment complex
• Financial institutions, such as
o Banking system
o Credit card service
o Investment trading service
The above are examples to guide you with your research, but you are not limited to these areas. It is important that you arrive at your own case study, based on your personal interests, and one that is well suited to explore from a data management perspective for this course. Some criteria that you should consider in arriving at your case study are listed below:
1. Your case study may be based on an actual company, or organization, using facts from research, or it may be fictional. In either case, you will have to make a number of assumptions about your case study’s organizational system (principles, policies and frameworks, processes, organizational structures, culture, ethics and behavior, information, services, infrastructure and applications, people, skills, and competencies) to complement the facts from your research.
2. Your case study must require a nontrivial underlying data management capability as an essential part of its operation. The data management must be reasonably complex. One way to determine whether a data management capability is reasonably complex is to think in terms of entities and relationships for your case study’s model. A reasonable data complexity is at least ten entities and ten relationships. You may have to make assumptions to complement your facts.
3. In your research, you may want to think in terms of use cases to define your data needs. Think of use cases as transactions that different end users will invoke when interacting with your case study’s database(s).
4. Finally, you must submit your area of study to the professor via e-mail and have your professor’s approval that you may go ahead with your selection.

Week 1 Tasks
Once you have selected your study area and case and have received approval from your professor, you may proceed to the next steps described below. Create a report that focuses on the data used to support the operation of your organization in your case study and answer the following questions.
• Conduct a brief, preliminary review of your case study’s organization. This review should include business mission and general purpose of data in support of mission-critical information systems.
• Produce detailed data requirements to address the data needs of your organization. The following are criteria that you can use to organize your requirements: adaptability, business and organizational policies, change control demands, compatibility, completeness, consistency, currency, ease of use, evolution, extensibility, functional features, maintainability/manageability, performance, reliability, scalability, security, standards, support, testability, and ubiquity. You will produce requirements in at least five of the above criteria.
• Develop a detailed data model as an EER diagram for your case study. Your model will include entity types with attributes, primary keys, and foreign keys as needed, and pertinent relationships with cardinality and integrity constraints as needed. Your data model will also come with a brief description for each entity type, attribute and relationship. Make sure to satisfy yourself that your data model is reasonably complex as explained in the guidelines under Background of Enterprise Data: Selecting your Case Study above.

Don't use plagiarized sources. Get Your Custom Essay on
Entity- Relationship (ER) Model
Just from $13/Page
Order Essay

Submission Details:
• Create your report in approximately 5-7 pages in a Microsoft Word document and name your document SU_MIS6211_W1_A3_LastName_FirstInitial.doc.
• Cite any sources you use using correct APA format on a separate page.

Grab 16% Discount On This Paper
Pages (550 words)
Approximate price: -

Why Choose Us

Quality Papers

ACME Homework provides the best top-grade academic writing services in compliance with our customers’ instructions. Have your paper written by a certified professional online college homework help writer to produce only high-quality essays with zero plagiarism.

Professional Academic Writers

You can now choose from a pool of online college homework help writers. Choose your writer and have them write the best content for you. ACME Homework has, over the years, secured a team of the most reliable, experienced, and qualified writers. You can, therefore, trust that your assignment is in good hands.

Affordable Prices

We know that students have very limited budgets. And for that, we always strive to provide only the best, most affordable online college homework help services to our customers. Our goal is to provide top-quality assignment help services to all customers at the lowest, most affordable prices.

On-Time delivery

At Acmehomework.com, we pay strict attention to deadlines. We recommend you to check out clients’ reviews for assurance that we will complete your assignments within the set deadlines. You can, therefore, trust that your paper will be done within and before the set deadline. Until now, we have not missed a single deadline.

100% Originality

Our Acmehomework.com homework helper experts write only 100% original and plagiarism-free content for all of our clients. We also have a Quality Assurance Department team that goes through all work submitted by our writers multiple times. You can, therefore, rest assured that any signs of plagiarized or unoriginal content will be rejected before it reaches your portal.

Customer Support 24/7

Acmehomework.com expert writers are always available 24/7 for customers who need assistance with using our website. You don’t have to check your watch the next time you want to have your assignment written. Our customer support is always available round the clock and ready to listen to your queries. Feel free to contact us via the Chat window or support email: support@acmehomework.com.

Try it now!

Grab 16% Discount On This Paper

We'll send you the first draft for approval by at
Total price:

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

For years now, Acmehomework.com has stood as a leader in providing its customers with the best online college homework help service in the industry. And all you have to do is provide us with the details of your order. Leave everything else to us. We’ve always got you covered.


Essay Writing Services

Since we launched, Acmehomework.com deserved the best online “college homework help status” thanks to our essay ordering, writing, and delivery process. We deliver nothing but excellence in our results. Our essay writing services include impeccable grammar, zero-plagiarism, proper structure, and conformance to guidelines.


Admission and Business Papers

Our top-quality online college homework help services guarantee that you will be accepted into your desired university. You just need to fill out your admission and business papers, and our team of online homework help workers will handle the rest. We will help you achieve and secure the best positions in your admissions forms.


Editing and Proofreading

At Acmehomework.com, we have a skilled writing and editing team that’s dedicated to creating, editing, and restructuring for all types of papers. Our online college homework help editing and proofreading team will check, paraphrase, and correct any grammar mistakes on your paper before submitting the final document to you.


Technical Papers

At Acmehomework.com, we pride ourselves in having writers in almost all fields, even the most technical ones. You never have to worry about your paper being too technical for our certified online college homework help writers to handle. ACME Homework’s team of writers can handle even the most complex writers. We will match your paper to the most competent writer that we believe will handle your paper the best way possible.

                                                                                     Place Order