CourseLover

(12)

$10/per page/Negotiable

About CourseLover

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

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Engineering,Health & Medical,HR Management,Law,Marketing,Math,Physics,Psychology,Programming,Science Hide all
Teaching Since: May 2017
Last Sign in: 283 Weeks Ago, 1 Day Ago
Questions Answered: 27237
Tutorials Posted: 27372

Education

  • MCS,MBA(IT), Pursuing PHD
    Devry University
    Sep-2004 - Aug-2010

Experience

  • Assistant Financial Analyst
    NatSteel Holdings Pte Ltd
    Aug-2007 - Jul-2017

Category > Computer Science Posted 25 Dec 2017 My Price 10.00

INTRODUCTION TO DATABASE (IT244) ASSIGNMENT 1

Hello Dears 

 

please find the attach file and help me . 

 

Best Regards, , , 

1 INTRODUCTION TO DATABASE (IT244) ASSIGNMENT 1 (LAST DATE TO SUBMIT: 20/10/2016) Q.1 What are the drawbacks of using file system over database management system? [1 Marks] Q.2 List three responsibilities of a database-management system. For each responsibility, explain the problems that would arise if the responsibility were not discharged. [1 Marks] Q.3 Explain the distinctions among the terms primary key, candidate key, and super key. [1 Marks] Q.4 Consider the bank database. [0.5+0.5+1=2 Marks] branch(branch name, branch city, assets) customer (customer name, customer street, customer city) loan (loan number, branch name, amount) borrower (customer name, loan number) account (account number, branch name, balance) depositor (customer name, account number) Give an expression in the relational algebra for each of the following queries: a. Find all loan numbers with a loan value greater than $50,000. b. Find the names of all depositors who have an account with a value greater than $9,000. c. Find the names of all depositors who have an account with a value greater than $8,000 at the “Uptown” branch.
Background image of page 1

Answers

CourseLover
(12)
Status NEW Posted 25 Dec 2017 01:12 PM My Price 10.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------s. -----------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-----------

Not Rated(0)