Database impact on the workplace

at
Categories
Tags

 

A small surgery center needs your help to create a database. The office manager has identified the following
types of data (entities): patients, doctors, procedures and appointments using the following business rules:
Patients can have many doctors and many doctors can see many patients.
Patients can have many procedures and many procedures are done on patients.
Doctors can have multiple appointments. (hint: these are many to many relationships, so associative tables
need to be added).
Requirements
Please identify the attributes and primary keys needed for each of the entities.
Identify the data types you would use for each of the attributes.
Determine the relationships between the entities and find the one-to-many and many-to-many relationships.
Create an ER diagram using Visio include the associative tables based on your analysis.
Identify all foreign keys needed in the database design.
Create the database and relationships in Access and populate the tables using the spreadsheets (unless your
Professor wants you to type the data into the tables).
Write a 3-5-page APA paper discussing the following topics:
Discuss Database impact on the workplace,
Discuss database benefits when businesses use querie,
Forms, and reports.
Discuss at least two security concerns should be discussed with a proposed solution to mitigate the security
issues

Sample Solution

higher prices while subjectively missing the exotic appeal of Hublot, concentrating on the horology/internals instead. The largest competitor for Hublot’s target customer segment is likely Rolex due to their substantial brand recognition despite Rolex’s different value proposition with more restrained and less exclusive designs. There is some competition through other luxury Swiss watchmakers, though they are either very niche or target different customer segments. Hublot’s target customer segment being young would indicate smartwatches are a potential competitor to Hublot. Indeed, Hublot released a luxury smartwatch in 2018. However, Hublot and the wider Swiss watch industry do not necessarily see smartwatches as a threat but rather an opportunity. They hope smartwatches will get young people wearing wristwatches again (Lelarge & Biver, 2015).

60% of watch consumers use online and digital channels to research prices or find product information (Deloitte, 2017).

Diagram showing competition comparison

9.3. How?

What is the business model?

Guidance: How do they make money? Important costs, sales approaches, relationships etc… The ‘Business Model Canvas’ is a very helpful guide (google the term and lots of great advice on it will come up). Not all of it is relevant to every organisation but it’s a great place to start if you’re stuck.

c.a. Value Proposition

Hublot’s value proposition include their exclusivity and avant-garde, unique, and flashy design. The expensive and exotic materials also bring value to Hublot customers. Moreover, customers mention they feel they are joining a community when buying a Hublot watch (Ap, 2018). This is due to the exclusivity of Hublot watches but also the possibility of joining an online community called Hublotista. On this website, customers are invited to exclusive events (often with Hublot sponsored celebrities attending), invited to service their watches after a few years, given early announcements about new limited releases, and easy contact with Hublot representatives.

d.b. Sales Channels

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.
Hi, how can I help?