country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

ISYS1055 Database Concepts For Decomposition And Functional Dependency

tag 0 Download3 Pages / 502 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
  • Course Code: ISYS1055
  • University: RMIT University
  • Country: Australia

Questions:

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

Answer:

Answer to Question 1:

The candidate key for the doctor table is Rego. The candidate key for Patient Table is ID. The appointment table has candidate key, ID.

The tables are already in third normal form. All the attributes in the database are atomic. Each of the tables has primary key. There is no non-functional dependency or transitive dependency.

Answer to Question 2:

Functional Dependency:

The given custID has been presented as dependent on the orderID. In real life database application, the custID does not depend on the OrderID. The given relation is partially true not entirely. Based on the custID, the system will identify the orders. In terms of data insertion this relation may seem valid. However, in terms of data retrieval, the custID-> orderID is more effective.

Transaction is not in 3NF:

The transaction is not in 3NF as the itemNo is a multivalued attribute. The table is not even in the first normal form.  

Decomposition:

Transaction(TransactionID, custID, orderID, discount, amount_due)

OrderedItem(itemNo, orderID, quantity)

The primary key is visualized through the underlined texts and foreign key through italics. 

 

Answer to Question 3:

deptname, Count(acnum) AS ‘Total number of academics’ From DEPARTMENT Inner Join ACADEMIC On DEPARTMENT.deptnum= ACADEMIC.deptnum Where deptname Like ‘Computer%’ OR deptname Like ‘Computing %’ AND deptname Like ‘%Science’ ORDER BY deptname ASC.

Select F.fieldnum, id, title From FIELD F Where Exists (Select ACNUM FROM INTEREST I WHERE fieldnum=F.fieldnum);

SELECT P.panum, P.title, Count(ACNUM) From paper P Inner Join author A ON P.panum = A.panum Group By P.panum HAVING Count(ACNUM)>2;  

SELECT CONCAT(A.FAMNAME, ', ', A.GIVENAME) As 'Academic Name', Count(AU.PANUM) From ACADEMIC A Left Join author AU ON A.ACNUM = AU.ACNUM Group By A.FAMNAME;  

Select COunt(A.ACNUM) From ACADEMIC A WHERE A.ACNUM Not In (Select I.ACNUM FROM INTEREST I);

Select I.fieldnum, id, title From FIELD F Inner Join INTEREST I ON F.fieldnum=I.fieldnum Group By F.FIELDNUM Having COUNT(I.fieldnum)<20;

SELECT P.panum, P.title FROM paper P Where Exists (Select A.ACNUM From Author A, ACADEMIC AC  Where PANUM=P.Panum AND A.ACNUM=AC.ACNUM AND deptnum = 100 AND P.Title Like '%Data%');

Select MAX(Interested) From (Select FIELDNUM, Count(FIELDNUM) AS Interested From Interest Group By FIELDNUM) AS I;

select acnum from interest I where upper(I.descrip) like '%D%';

The subquery returns all queries the Interest with two values.

The whole query returns name of the academic present in the interest table. 

 

Bibliography:

Lubcke, A., Saake, G. and Neumann, T., 2017. Automated query interface for hybrid relational architectures (Doctoral dissertation, Otto-von-Guericke-Universität Magdeburg, Fakultät für Informatik).

Parreiras, F.S., Pinto, V.A., Soares, M.A.C. and Falci, D.H.M., 2017. Semantic middleware for industrial sensors. Ciência da Informação, 46(1).

Download Sample

Get 100% money back after download, simply upload your unique content* of similar no. of pages or more. We verify your content and once successfully verified 100% value credited to your wallet within 7 days.

Upload Unique Document

Document Under Evaluation

Get Credits into Your Wallet

*The content must not be available online or in our existing Database to qualify as unique.

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Database Concepts For Decomposition And Functional Dependency. Retrieved from https://myassignmenthelp.com/free-samples/isys1055-database-concepts-for-decomposition-and-functional-dependency.

"Database Concepts For Decomposition And Functional Dependency." My Assignment Help, 2020, https://myassignmenthelp.com/free-samples/isys1055-database-concepts-for-decomposition-and-functional-dependency.

My Assignment Help (2020) Database Concepts For Decomposition And Functional Dependency [Online]. Available from: https://myassignmenthelp.com/free-samples/isys1055-database-concepts-for-decomposition-and-functional-dependency
[Accessed 07 August 2020].

My Assignment Help. 'Database Concepts For Decomposition And Functional Dependency' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/isys1055-database-concepts-for-decomposition-and-functional-dependency> accessed 07 August 2020.

My Assignment Help. Database Concepts For Decomposition And Functional Dependency [Internet]. My Assignment Help. 2020 [cited 07 August 2020]. Available from: https://myassignmenthelp.com/free-samples/isys1055-database-concepts-for-decomposition-and-functional-dependency.


Stuck with a research paper for days? Well, if you can’t figure out how to do a research paper on a certain research paper topic, get the necessary assistance from MyAssignmenthelp.com, the no.1 academic paper writing service on the internet. Here, we have professional researchers who will brainstorm to get unique ideas for your paper while you enjoy yourself. We are considered amongst the top writing services who know how to write a thesis for a research paper like the back of their hand. Our in-house academic writers will make sure you receive a plagiarism-free research paper on time.

Latest Management Samples

GSP177E Fundamentals Of Investing1

Download : 0 | Pages : 7

Answer: Introduction: The assessment mainly aims in formulating adequate portfolio, which could help in producing return to MS B, who is ultra-high net worth individual investing in Singapore. In addition, the portfolio could help in supporting the financial requirement of MS B, where it might generate high rate of return from investment. The portfolio mainly focuses on developing high return from investment, which reduces the negative impact...

Read More arrow

MGT5MPT Management Practice And Theory 3

Download : 0 | Pages : 9
  • Course Code: MGT5MPT
  • University: La Trobe University
  • Country: Australia

Answer: Introduction  The organizational theory is defined as the set of the interrelated definitions and concepts, which helps in explaining groups, subgroups or the individual behavior, which interacts with each other for performing the activities, which are intended towards common goal accomplishment. The theory seeks for suggesting the best way for structuring or managing the organization by providing approaches for the organizationa...

Read More arrow Tags: Australia 9 Management Theory and Practice Other 

BUS8450 Sustainable Operations I

Download : 0 | Pages : 8
  • Course Code: BUS8450
  • University: Conestoga College
  • Country: Canada

Answer: Introduction The report is prepared on the title ‘Sustainable operations’. The first section provides information about the company background of ‘Cober’ organization. The next part focuses on the current sustainable practices adopted by the organization. The third section emphasizes on the impacts and issues of the sustainable practices. The report also provides information about the possible risks and opportu...

Read More arrow Tags: Canada 42 Sustainable Operations Other 

PACC6008 Individual Assignment

Download : 0 | Pages : 4
  • Course Code: PACC6008
  • University: The University Of Newcastle
  • Country: Australia

Answer: Answer 1: Population Web institute is interested in checking about the Education qualification division and wage division among people of the said region.  It can be said that their is a connection between the two variables and it can be tested here. For Wages: Given is the data set for wages. A descriptive statiscal analysis report of the given variable is given below:   Table 1: Descriptive analysis of wages. ...

Read More arrow

HIM 213 Health Information Systems Management

Download : 0 | Pages : 3
  • Course Code: HIM 213
  • University: American University Of Sharjah
  • Country: United Arab Emirates

Answer: a. What is the first step Sherry should take? What questions should she ask Dr. Ross?  The first step of Sherry should be to monitor the workforce and check whether the paper-based system had been effective or not. If not, then why and how replacing with the electronic medical record system could resolve the issues and favor the data collection procedures. She must clarify with Dr. Ross about how effective the electronic medical re...

Read More arrow
Next
watch

Save Time & improve Grade

Just share Requriment and get customize Solution.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

1,379,740

Orders

4.9/5

Overall Rating

5,085

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1758 Order Completed

99% Response Time

William Martinez

MS in Biology

Washington, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

234 Order Completed

100% Response Time

Samantha Ji

PhD in Chemistry with Specialization in Organic

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2632 Order Completed

100% Response Time

Albert Ambrosio

MSc in Nursing

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1265 Order Completed

97% Response Time

James Cook

Masters in Management

Wellington, New Zealand

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

Awesome work. Awesome response time. Very thorough & clear. Love the results I get with MAH!

flag

User Id: 383727 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

Work was done in a timely manner took it through grammarly checked for plagiarism very well satisfied

flag

User Id: 463334 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

Great work for the short notice given. Thank you for never disappointing and helping out.

flag

User Id: 194216 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating

I received a full point on the assignment. Thank you for all the help with the assignment.

flag

User Id: 411395 - 31 Jul 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?