User Account

All Pages

Data for the booking systems of the abc clinic

Assignment Help Business Management
Reference no: EM131998489

Question 1. The Relational model

A database is needed to keep data for the booking systems of the ABC Clinic. Consider the below database schema of one relation including attributes for doctors (doc-), patients (pat-) and appointments (app-).

ABC(doc-firstname, doc-surname, doc-gender, doc-rego, doc-qualification, pat-ID, pat-givename, pat-surname, pat-gender, pat-DOB, pat-addr, pat-phone, app-ID, app-datetime, app-type)

  • A doctor has a unique registration number (doc-rego) and is also described by name, gender and qualification.
  • A patient is identified by a unique patient ID (pat-ID) and has other information.
  • Each appointment by a patient with a doctor is assigned a unique appointment ID (app-ID). An appointment can be of the long or short type.

Answer questions:

  1. Give likely FDs.
  2. Give the candidate keys for the ABC relation. In your working, show how you develop the closure for each candidate key you have discovered..
  3. Is the relation ABC in BCNF or 3NF? Explain your answer.

Reference no: EM131998489

Questions Cloud

Coaching and team development : Choose at least two techniques that you would use to improve a team member's performance and your rationale for them.
Analyze the rationale for the so called trust-busting : Analyze the rationale for the so called "Trust-busting" Standard Oil apart. Examine the main advantages and disadvantages of "Trust-busting".
Metric system for calculation and report : How much storage does the MSU email system require to store student emails? Use the metric system for calculation and report your answer in gigabytes (GB).
Discuss the implications of resistance to the change process : Conclude whether or not Kotter believes that all individuals who are resistant to change can gradually be "won over" in cases of significant change.
Data for the booking systems of the abc clinic : A database is needed to keep data for the booking systems of the ABC Clinic. Consider the below database schema of one relation including attributes
Propose three ways that a mentor can assist employees : Evaluate the following criteria, in order of importance to you, in regard to the workplace: material wealth, success, career satisfaction, and work-life.
What are the modes available for branchcache : What are the modes available for BranchCache? Why would one mode be applicable over another?
What is equivalent annual annuity : How much does the trader gain (or lose) when the futures price quote increases by 15 basis points? what is the equivalent annual annuity?
Execute a short computer program using c programming : Execute a short computer program using C programming that reads integer numbers, entered from a keyboard, until the same number is entered twice in a row

Reviews

Write a Review

Business Management Questions & Answers

  Formation of the overall strategy

Discuss how the creation of the vision, mission, and values statements are critical in the formation of the overall strategy.

  Creation of the faa and icao

What were the driving forces behind the creation of the FAA and ICAO? This question is pertaining to the airline versus FAA safety responsibilities.

  Identify and describe the product or products

1. Identify the name of the company. 2. Identify and describe the product or products. 3. Identify their target audience both here in the USA and in the global markets.

  Upper management wants change within this group

You have just been selected as the supervisor in charge of a very diverse work group of 25. The diversity includes multiple generations (age).

  How does health insurance impact healthcare delivery

1. What is the government's role in healthcare? How does the government impact healthcare organizations?

  Business research report - Business Advertisement Processes

Business Research Report - Topic: BUSINESS ADVERTISEMENT PROCESSES. Describe objectively what happened in the learning process

  Example of a successful innovation

Find an example of a successful innovation and one that was not so successful. (Finding failures is difficult.) What were the reasons given for success? For failure? Which of these reasons relate to poor planning? What does this tell you about th..

  Latest trends in ethics-law

The latest trends in Ethics/Law (short background, current situation, best practices and the future in the Change management field.).

  Failing to get permissionshow the impact of failing to get

failing to get permissionshow the impact of failing to get permission before taking an action with a customer e.g.

  Total cost of ownership

Show three of these components as they relate to a product or organization of your choosing. Describe why you think that these components are relevant to that product or organization.

  Discuss the steps you used to compile the excel analysis

Discuss the steps you used to compile the Excel analysis. Convert the raw data to utilities (scaled on 0 to 1). Show the utility weights in a second table.

  Middle market segment between low-end products

Evaluate the extent to which there are any bases of relatedness among the four products. Identify two countries outside of the U.S. that you feel would be an opportunity for a potential business expansion and explain the basis for your selection.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd