Category: Uncategorized

Database management systems

An automotive service center or dealer wants to improve its services by using database management systems (DBMS) and data mining. What tables are needed in such a database and how could it help improve their services?

Explain the value of utilizing the entity relationship model

The entity-relationship model (or ER model) is a way of graphically representing the logical relationships of entities (or objects) in order to create a database. This is also referred to as the data model.

Employing a data model permits the designer to present data visually. These models focus on representing the data in terms of a user’s viewpoint. During our discussion, let’s also consider not only the importance and advantages of data modeling but also do some web research regarding modeling tools.

Explain the value of utilizing the entity relationship model (ER Model) and the entity relationship diagram (ERD) for relational databases. Is this an advantage or disadvantage? Why?

….In other words why would anyone want to do data modeling?

What are the advantages of data modeling?

Personnel Management

– Minimum 10 references.

– Citation must be APA format.

– Evidence cited is recent. Evidence cited is from reliable sources (NOT from wiki,wordpress, slideshare, baidu, doc.stock, uk essay.

Personnel Management report not more than 5 years minimum 2000 words max 2200 words 

Choose any existing company of your choice operating in Singapore. *select supervisory upwards position* Preferably Accounting, Service line, Nurse, Marketing or Air steward. ** Job street **

Point 1 Introduction select a Singapore company. Must describe the company business, size, sales, brand, etc.. (Company background)

– Why is there a job vacancy . Example, replacement of resigned employee, business expansion and new department.

Point 2 Job Analysis 

– Job Descriptopn i.e what is the job about (tasks, duties, responsibilities)

– Job Specification : who is the person performing the job. (Knowledge, skills, abilities, other)

Point 3 Job Desgin * select any 2 job design dimensions *

– Design for motivation (recognition, training, sponsorship, insurance)

– Design for safety (WSHA: workplace safety and health act : MOM) buddy system, self defense,  safe working environment (washing, personal protective equipments)

Point 4 Recruiting 

– Internal (present employees) and external recruiting (external applicants)

* Identify two internal (bulleting board, intranet) and external recruiting (electronic job portals, employment agencies) platforms*

Point 5 Selection (at least 2 selection platforms inclusive of interview)

Stages of selection process

step 1 – Screening Applications and Resumes

step 2 – Testing & reviewing Work Samples

step 3 – Interviewing candidates

step 4 – Checking references & background

Step 5 – Making a selection

Point 6 Conclusion (Placement)

Eg. Its important for the company to possess sound placement strategies for new hire given the newness of the company and these stressors can be minimised via buddy system i.e shadowing and mentoring by senior member of the department

Orientation, training, etc of new hire

The Color Purple

Watch The Color Purple Write a 4-5-page paper using APA format throughout: Write a brief summary of the film Examine the culture depicted in the film using two of the six components of Giger and Davidhizars Transcultural Assessment Model Communication, Space, Social Organization, Time, Environmental Control, Biological Variations. Why did you choose these two components? Explore any perceived challenges with caring for this group in comparison to YOUR beliefs How does it affect you as a nurse caring for this patient. Conclusion

Leading Healthcare Organizaation

a minimum of 1,200 words (total assignment) or 300 words per question. three scholarly sources/references, the textbook will count as a source. APA style with in text citations are a must. Will have to be sure one of the sources is a journal article as well. You must cite the source any time that information is used that is not your own thought/idea; this includes paraphrased information. At minimum, an in-text citation should be used at the end of each summary paragraph.

Here is the textbook citation generated correctly for use..

Burns, L. R., Bradley, E. H., & Weiner, B. J. (2011). Shortell and Kaluzny’s Healthcare Management: Organizational Design and Behavior (6th ed.). Cengage Learning.

Please separate or number each question so I won’t have to filter through.

 

1. In a narrative format, discuss the key facts and critical issues presented in the case.
2. What social and cultural barriers may have made it difficult for the doctors to communicate with Jesica’s family? What might have the doctors done to increase the chances that Jesica’s family understood the true nature of the problems in this terrible circumstance?
3. How would you organize the complex set of steps required in this transplant process to ensure that misunderstandings do not occur in handoffs between professionals?
4. If you were the Duke Medical Center CEO, what general communication strategy would you put in place to manage the stakeholders in this case? In particular, how would your messages to each group differ from the others?

Cisneros & Imagery

Images represent much more than the literal–they also suggest figurative meanings as well.   Images can describe setting and characters, creating mood and tone for understanding their significance.

Focusing on your favorite chapter, choose one image to analyze from Cisneros’ novel and write a persuasive critical reading response exploring its significance as it relates either to setting, character development, and/or major themes in the story.  Your response must contain a thesis statement—i .e., an original claim—and utilize evidence from the text, referencing page numbers so we can follow your argument. 

Text Book Sandra Cisnero. The house on Mango Street.

Information Technology Project Management

PART 1.

Perform a financial analysis for a project using the format provided in Figure 4-5 in the text. Assume the project costs and benefits for this project are spread over four years as follows: Estimated costs are $200,000 in Year 1 and $30,000 each year in Years 2, 3, and 4. Estimated benefits are $0 in Year 1 and $100,000 each year in Years 2, 3, and 4. Use a 9% discount rate, and round the discount factors to two decimal places. Create a spreadsheet to calculate and clearly display the NPV, ROI, and year in which payback occurs. Based on the financial analysis, please write a few lines on the spreadsheet explaining whether you would recommend investing in this project. (Tip: Use the spreadsheet format given, such that Year 0 is year 1 described above. So your spreadsheet should include columns for years 0, 1, 2, and 3.)

 

PART 2.

Develop an imaginary project charter for a web development project. Assume you are going to develop a website from scratch for a small retail business of your choosing. Assume the web site will include a home page with links to information about products and services. It will also include a bulletin board, chat room, and provide information about the company and how to contact people in the company. Assume you are a self-employed software developer and your client is the owner and founder of the business. The owner wants a copy of the charter to circulate among her employees so they can be made aware of the project and prepare to support it. You may use Table 4-1 in the text as a template for creating headings and organizing information in the charter.

Explain the benefits of normalization

Question 1: Describe two ways redundancy infiltrates a database. Hint: Think about the difference between text boxes as data inputs and drop-down selection lists – one better controls the quality of data you enter! Another hint is to reflect on lookup tables. Note: Please do not state by “not normalizing the database”. Be more specific and creative!

Question 2: Explain one characteristic of a database that has data redundancy. Note: Redundancy in our context is not a good thing!

Question 3: Briefly explain the benefits of normalization and why we should implement it when designing databases

Question 4: Provide an example of a table or database that is in first normal form and explain how you would bring it to 3NF.
Solve these questions in details and provide examples to support your rationale.

Discuss the serious data redundancy problems

1. Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure.

2. Looking at the EMP_NAME and EMP_PHONE contents in Figure, what change(s) would you recommend?

3. Identify the various data sources in the file you examined in Problem 5.

4. Given your answer to Problem 7, what new files should you create to help eliminate the data redundancies found in the file shown in Figure  ?

Describe discretionary access control

Part -1:

Case: Training Case

You were hired as a database security expert to train the database administration team. At the first training session,you ask the trainees to perform the following tasks using Oracle Enterprise Manager or SQL*Plus. Describe what you expect your trainees to produce.

• Create a user named CH0306 with the password CH0306.
• Modify the user options using SQL*Plus to change the default tablespace and temporary tablespace to TOOLS and TEMP respectively.
• Lock the account.
• Using SQL*Plus change the user password to DBSEC. (Optional)
• View the account using the data dictionary.(You can provide a screenshot)
• View user quotas using the data dictionary.

At the second training session,you ask the students to outline a list of the best three practices of user administration.List what you expect your students to produce.

Case – Training Case (Modified)

You were hired as a database security expert to train the database administration team.At the first training session,you ask the trainees to perform the following tasks using Microsoft SQL Server Management Studio. Describe what you expect your trainees to produce. (You can use the following help)

• Create a login named CH0306 with the password CH0306.
• Create a database user of the same name for the login created above.
• Change the user password to DBSEC. (Optional)
• View the account using the data dictionary. (You can provide a screenshot)

Part -2:

Please describe DAC (Discretionary Access Control), MAC (Mandatory Access Control), and RBAC (Role-Based Access Control) ?