User Account

All Pages

Give the candidate keys for the abc relation

Assignment Help Business Management
Reference no: EM132002553

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: EM132002553

Questions Cloud

Explain the facts of the case leading to the dispute : Explain the facts of the case leading to the dispute.
Assess the readiness of the health care organization : Your essay should assess the readiness of the health care organization or network in addressing the health care needs of citizens in the next decade.
Undergraduate and graduate students : The Michigan State University email system supports 50,138 undergraduate and graduate students. Assume that each student tends to store approximately
Identify the most significant business problem : Identify the most significant business problem the company faced while assessing the various types of organizational communications used to manage the problem.
Give the candidate keys for the abc relation : Give the candidate keys for the ABC relation. In your working, show how you develop the closure for each candidate key you have discovered.
What would some of the restraining forces be : Consider the contributions of change, system, chaos, cognitive, and sociotechnical theories to the evolution of informatics theory.
How the content and assignments met the course objectives : How the content and assignments met the course objective(s)? Provide examples of actual or potential applications of the course week's course concepts.
What must dewey love prove to be successful : What can Anytown argue to the court, or present as evidence at trial, to defend against Love's claim for defamation?
What are the modes available for branchcache : What are the modes available for BranchCache? Why would one mode be applicable over another?

Reviews

Write a Review

Business Management Questions & Answers

  Caselet on michael porter’s value chain management

The assignment in management is a two part assignment dealing 1.Theory of function of management. 2. Operations and Controlling.

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. Due to increase in the preference for light beer drinkers, Chris Prangel wants to introduce light beer version in Mountain Man. An analysis into the la..

  Mountain man brewing company

Mountain Man Brewing, a family owned business where Chris Prangel, the son of the president joins. An analysis into the launch of Mountain Man Light over the present Mountain Man Lager.

  Analysis of the case using the doing ethics technique

Analysis of the case using the Doing Ethics Technique (DET). Analysis of the ethical issue(s) from the perspective of an ICT professional, using the ACS Code of  Conduct and properly relating clauses from the ACS Code of Conduct to the ethical issue.

  Affiliations and partnerships

Affiliations and partnerships are frequently used to reach a larger local audience? Which options stand to avail for the Hotel manager and what problems do these pose.

  Innovation-friendly regulations

What influence (if any) can organizations exercise to encourage ‘innovation-friendly' regulations?

  Effect of regional and corporate cultural issues

Present your findings as a group powerpoint with an audio file. In addition individually write up your own conclusions as to the effects of regional cultural issues on the corporate organisational culture of this multinational company as it conducts ..

  Structure of business plan

This assignment shows a structure of business plan. The task is to write a business plane about a Diet Shop.

  Identify the purposes of different types of organisations

Identify the purposes of different types of organisations.

  Entrepreneur case study for analysis

Entrepreneur Case Study for Analysis. Analyze Robin Wolaner's suitability to be an entrepreneur

  Forecasting and business analysis

This problem requires you to apply your cross-sectional analysis skills to a real cross-sectional data set with the goal of answering a specific research question.

  Educational instructional leadership

Prepare a major handout on the key principles of instructional leadership

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