SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 210 Weeks Ago, 5 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 14 Dec 2017 My Price 10.00

advised to make your work clear and well-presented

Hi, I need your help to solve an assignment for Database. Due date 29 APRIL.

 

    

    

    

 

INTRODUCTION TO DATABASE

IT244

 

 

Instructions:

·       This Assignment must be submitted on Blackboard via the allocated folder.

·       Email submission will not be accepted.

·       You are advised to make your work clear and well-presented, marks may be reduced for poor presentation.

·       You MUST show all your work.

·       Late submission will result in ZERO marks being awarded.

·       Identical copy from students or other resources will result in ZERO marks for all involved students.

 

    

 

 

 

Name:###

 

CRN:###

 

ID:###

 

 

 

 

 

2 Marks

Learning Outcome(s):

To understand the concept of the normalization process(1NF, 2NF, 3NF, and BCNF).

.

 

 

 

 

 

 

 

Question One

 

A. Consider the following relation R with all functional dependences F and normalize it into 2NF, 3NF, and BCNF.

 

R= {Patient_No,Patient_Name,App_No,Time,Doctor}

F= {Patient_No à Patient_Name

Patient_No,App_NoàTime, Doctor 

Time àApp_No }

 

 

 

 

 

 

 

 

 

B. Explain why the following relation R is in 3NF but not in BCNF.

 R={a,b,c,d}

F= {a,bàc,d

a,dà b}



 

2 Marks

Learning Outcome(s): To understand relation algebra expressions, To write relational algebra, and to analyze it

 

 

 

 

 

Question Two

author(author_id, first_name, last_name)

author_pub(author_id, pub_id, author_position)

book(book_id, book_title, month, year, editor)

pub(pub_id, title, book_id)

·         author_id in author_pub is a foreign key referencing author.

·         pub_id in author_pub is a foreign key referencing pub

·         book_id in pub is a foreign key referencing book

·         editor in book is a foreign key referencing author(author_id)

·         Primary keys are underlined

 

 

 

1.      How many tuples will be returned by the following relational algebra query?

Π book_title(book)

 

 

 

2.      What question does the following expression answer?


 

Π author_id (author) –  Π editor(book)

 

 

 

3.      Write a relational algebra expression that returns the names of all authors who are book editors.

 

 

 

 

4.      How many tuples are returned by the following relational algebra expression?


author ⨝author_id=editorbook


 

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 14 Dec 2017 11:12 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)