Create an er diagram that will facilitate development of cms

Assignment Help Database Management System

Reference no: EM13759710

Part A Deliverable:

For this phase, you are required to create an ER Diagram that will facilitate the development of CMS's company-wide database.It should be created using ER Assistant and include entities and attributes, relationships, and accompanying notes.You should take a screen shot of your ERD while it is displayed in ER Assistant and paste the screen shot into a Word document.Make sure that the ERD fits on a single sheet and is legible.Accompanying notes should be included on a separate sheet of the document.Name this Word document CMS Project.

Part B Deliverable:

Using ER Assistant, modify your original ERD to accommodate the requirement to allow more than one instance of a given contact type per contract.Also, include new entities and relationships to support benefit tracking in all countries.Depending on your initial design, you may or may not have to modify your ERD to accommodate the new contract types (License and Maintenance).You will also have to account for the introduction of products in the business model.

Attachment:- cms project.docx

Reference no: EM13759710

Questions Cloud

Net income for the current fiscal year : What is the net income for the current fiscal year? Is it up or down from the prior year? Why would this information be important to investors?

Write a program with a windows-style interface : write a program with a Windows-style interface to carry out the task. A form contains two text boxes and one large label between them with no preset caption. When the first text box receives the focus, the label reads "Enter your full name.

Phases included in the it governance deployment plan : Discuss the phases included in the IT Governance deployment plan. Who are the stakeholders that need to be involved and in which phases should they be involved?

What strategies would you use to work with sally-anne : What strategies would you use to work with Sally-Anne to ensure effective partnering with families in support of infant/toddler mental health?

Create an er diagram that will facilitate development of cms : For this phase, you are required to create an ER Diagram that will facilitate the development of CMS's company-wide database.It should be created using ER Assistant and include entities and attributes, relationships, and accompanying notes

What is the issue concerned with : 1. What is the issue concerned with? 2. Why is this issue of current interest to employees and managers? 3. What rights are employees demanding? 4. What, if any, laws or court cases affect this right? 5. Generally, how are employers responding to thi..

Equipment at that plant is outdated and inefficient : Shokun Steel Co. owns many steel plants. One of its plants is much older that the others. Equipment at that plant is outdated and inefficient, and the costs of productions at that plant are now two times higher than at any of Shokuns other plants.

What are your academic strengths and weaknesses : Compose a SWOT analysis regarding your position as a student. What are your academic strengths and weaknesses? What opportunities and threats present themselves during the course of your schooling? Submit at least a full one page report as an attache..

Interviewing process as conducted at many small businesses : What do you think are the most serious weaknesses in the interviewing process as conducted at many small businesses? How could these be remedied? Are on-line testing and games to screen potential candidates fair in your estimation? Why or why not?

User Account

All Pages