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

  Research a company that had some communication issues

Research a company or 2 that had some communication issues and note what they did to fix them along with what processes they implemented.

  Gerenuk company lowest net relevant cost

Alternatively, the facilities could be rented out at $80,000 per year.  Given all of these alternatives, what is Gerenuk Company's lowest net relevant cost for the parts?

  Key value for quality care

Why patient first is a key value for quality care? Why is important to speak up about unsafe conditions at the hospital?

  Hr department during a major change

How important is the HR department during a major change initiative when people are resisting the change?

  Mintzburg basic parts of the organization

Explain how Mintzburg basic parts of the organization fit together to perform needed functions. If an organization have to give up one of these five parts, such as during to a severe downsizing, which one could it survive the longest without?

  Face of the future

Face of the Future: False Alarm: Part 1 of 2; People like Nadine West-73 and with no plans to stop working-are the reason why dark predictions of a retirement-fueled labor drought are overblown. Ed Frauenheim.

  Should we even be discussing free versus fair trade

Free Trade vs. Fair Trade by Jason Gillikin. Given the concept of comparative advantage, should we even be discussing free versus fair trade?

  Readings and high-quality source of outside research

Support your answers with examples from the readings and high-quality source of outside research.

  Business operationsq1 should host governments play a role

business operationsq1 should host governments play a role in global business operations? why?q2 why must a company be

  Explain the organization with a brief description

Explain the organization, with a brief description. Explain the business problem or opportunity. Analyze why the business problem is important.

  What is the effect on business where the patents are deemed

What are the most persuasive arguments in favor of and against allowing the patentability of higher life forms?

  Comparing two companies in the same industry

Decision Case- Comparing Two Companies in the Same Industry: Kellogg's and General Mills.

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