CS-06 (2009)

Course Code : CS-06
Course Title : Database Management Systems
Assignment Number : BCA(4)/TMA/09
Maximum Marks : 25
Last Date of Submission : 30th April, 2009/30th October, 2009

There are four questions in this Assignment. Answer all the questions. You may use illustrations and diagrams to enhance explanation.

Q. 1  Explain architecture of Distributed Database systems? Also, explain the reasons for building distributed database systems?

Ans :

Distributed Database Architecture :

A distributed database system allows applications to access data from local and remote databases. In a homogenous distributed database system, each database is an Oracle Database. In a heterogeneous distributed database system, at least one of the databases is not an Oracle Database. Distributed databases use a client/server architecture to process information requests.


    *Homogenous Distributed Database Systems

    *Heterogeneous Distributed Database Systems

    *Client/Server Database Architecture


Homogenous Distributed Database Systems


A homogenous distributed database system is a network of two or more Oracle Databases hat reside on one or more machines. Following Figure illustrates a distributed system that connects three databases: hq, mfg, and sales. An application can simultaneously access or modify the data in several databases in a single distributed environment. For example, a single query from a Manufacturing client on local database mfg can retrieve joined data from the products table on the local database and the dept table on the remote hq database.


For a client application, the location and platform of the databases are transparent. You can also create synonyms for remote objects in the distributed system so that users can access them with the same syntax as local objects. For example, if you are connected to database mfg but want to access data on database hq, creating a synonym on mfg for the remote dept table enables you to issue this query:




In this way, a distributed system gives the appearance of native data access. Users on mfg do not have to know that the data they access resides on remote databases.


Figure Homogeneous Distributed Database

Figure Homogeneous Distributed Database


Heterogeneous Distributed Database Systems


In a heterogeneous distributed database system, at least one of the databases is a non-Oracle Database system. To the application, the heterogeneous distributed database system appears as a single, local, Oracle Database. The local Oracle Database server hides the distribution and heterogeneity of the data.


The Oracle Database server accesses the non-Oracle Database system using Oracle Heterogeneous Services in conjunction with an agent. If you access the non-Oracle Database data store using an Oracle Transparent Gateway, then the agent is a system-specific application. For example, if you include a Sybase database in an Oracle Database distributed system, then you need to obtain a Sybase-specific transparent gateway so that the Oracle Database in the system can communicate with it.


Client/Server Database Architecture


A database server is the Oracle software managing a database, and a client is an application that requests information from a server. Each computer in a network is a node that can host one or more databases. Each node in a distributed database system can act as a client, a server, or both, depending on the situation.


In Following Figure, the host for the hq database is acting as a database server when a statement is issued against its local data (for example, the second statement in each transaction issues a statement against the local dept table), but is acting as a client when it issues a statement against remote data (for example, the first statement in each transaction is issued against the remote table emp in the sales database).


Figure An Oracle Database Distributed Database System

Figure An Oracle Database Distributed Database System

Benefits of Distributed database system.

There are a number of benefits of using a distributed DBMS. These include the following:

    *Capacity and incremental growth
    *Reliability and availability
    *Efficiency and flexibility

Capacity and growth
An advantage of distributed databases is that as the organisation grows, new sites can be added with little or no upheaval to the DBMS. Compare this to the situation in a centralised system, where growth entails upgrading with changes in hardware and software that effect the entire database.

Reliability and availability
An advantage of distributed databases is that even when a portion of a system (i.e. a local site) is down, the overall system remains available. With replicated data, the failure of one site still allows access to the replicated copy of the data from another site. The remaining sites continue to function. The greater accessibility enhances the reliability of the system.

Efficiency and flexibility
An advantage of distributed databases is that data is physically stored close to the anticipated point of use. Hence if usage patterns change then data can be dynamically moved or replicated to where it is most needed.

Distributed database sharing
An advantage of distributed databases is that users at a given site are able to access data stored at other sites and at the same time retain control over the data at their own site.


New City Studio Records company has decided to store information about musicians who perform on its albums (as well as other company data) in a database. The company has wisely chosen to hire you as a database designer.


                • Each musician that records at the company has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone.

                • Each instrument used in songs recorded at the studio has a unique identification number, a name(e.g., guitar, synthesizer, flute) and a musical key (e.g., C, B-flat,E-flat).

                • Each album recorded on the Studio has a title, a copyright date, a format (e.g., CD or MC), and an album identifier.

                • Each song recorded at the Studio has a title and an author.

                • Each musician may play several instruments, and a given instrument may be played by several musicians.

                • Each album has a number of songs on it, but no song may appear on more than one album.

                • Each song is performed by one or more musicians, and a musician may perform a number of songs.

                • Each album has exactly one musician who acts as its producer. A musician may produce several albums, of course.

Draw an ER diagram for the above said schema.

Comments on this page:
Comment posted by sgx38mzk( 6ia48l7jgmai.com ), 07/30/2017 at 4:59pm (UTC):
The serum concentration of Prednisone can be increased when it is combined with Lansoprazole. <a href=https://byprdnsn.info/>cheap prednisone</a>, prednisone high blood pressure headache

Comment posted by mfxc2d( ofbaedgmail.com ), 06/23/2017 at 11:08pm (UTC):
<a href=http://invelevoria.com>invelevoria</a>

Comment posted by JamAdvasse( email1try-rx.com ), 06/16/2017 at 4:06am (UTC):
Amoxicillin Libido <a href=http://clomid.ccrpdc.com/purchase-clomid.php>Purchase Clomid</a> Cialis Viagra Preisvergleich Listino Propecia <a href=http://costofvia.com/internet-order-viagra.php>Internet Order Viagra</a> Cephalexin Dosing In Dogs Mail Order Isotretinoin Aurora <a href=http://genericvia.com/cheap-viagra.php>Cheap Viagra</a> Healthy Man Cialis Ordonnance Tadalis Sx Soft Singapour <a href=http://accutane.ccrpdc.com/buy-eratin.php>Buy Eratin</a> Levitra Generique 5mg Direct Progesterone <a href=http://viagra-100mg.viaforsale.com>Viagra 100mg</a> Generic Levaquin Tavanic Tablet Cialis In Francia <a href=http://levicost.com>cheapest levitra 20mg</a> Cialis 8cpr Riv Order Synthroid Online No Prescription <a href=http://leviplus.com/levitra-where-to-buy.php>Levitra Where To Buy</a> Can Amoxicillin Treat Step Throat Where To Buy Cialis Yahoo <a href=http://buylevitraeufast.com/levitra-trial.php>Levitra Trial</a> Long Term Amoxicillin buy accutane online in canada <a href=http://cytotec.ccrpdc.com/buy-generic-cytotec.php>Buy Generic Cytotec</a> Bystolic Coupons

Comment posted by WilbSwateRef( milotry-rx.com ), 06/15/2017 at 11:32pm (UTC):
buy accutane in mexico <a href=http://cheap-viagra-pill.via100mg.com>Cheap Viagra Pill</a> Want To Buy Macrobid 100mg Free Shipping Forum Viagra 100 Mg <a href=http://cialcheap.com/buy-cheap-cialis-on-line.php>Buy Cheap Cialis On Line</a> Viagra In Farmacia Serve Ricetta Drug Interactions Amoxicillin <a href=http://cheapcial.com/generic-for-cialis.php>Generic For Cialis</a> Pastilla Cialis Efectos need isotretinoin isotret best website overseas <a href=http://leviusa.com>levitra canada</a> Propecia Agente Gemstar Keflex Infusion <a href=http://brandcial.com/cialis-price.php>Cialis Price</a> Buy Viagra Winnipeg Receta Viagra Casera <a href=http://viagra-online-cheap.viasample.com>Viagra Online Cheap</a> Where To Order Finasteride Cialis 20mg 12 St <a href=http://levipill.com/levitra-ordering.php>Levitra Ordering</a> Keflex For Staph Erfahrungen Mit Viagra Nebenwirkungen <a href=http://levipill.com/levitra-ordering.php>Levitra Ordering</a> Cialis Venta Online Cialis Generico Tadacip <a href=http://price-generic-viagra.via100mg.com>Price Generic Viagra</a> Cialis Effetti Gravidanza Cialis Viagra Doctissimo <a href=http://low-price-levitra.levitab.com>Low Price Levitra</a> Zithromax And Robitussin

Comment posted by WilbSwateRef( milotry-rx.com ), 06/12/2017 at 2:03pm (UTC):
Generic Viagra For Sale In The Usa <a href=http://dprixe.com>cheap cialis</a> Robaxin No Prescription Canada Minimum monthly payments apply.Shared Branching is the cooperative spirit in action.. <a href=http://quickloannow24.com>cash loans</a> Cash Advance No Fax Quick Cash Advance No credit.Menu The amount the hard money lenders are able to lend to the borrower is primarily based on the value of the subject property.Online Prescriptions <a href=http://kamagra-online-buy.kamagorder.com>Kamagra Online Buy</a> Propecia Medical Cialis Im Ausland <a href=http://cialbuy.com>cialis</a> Generic Viagra 25 Mg Review Diflucan For Sale Online <a href=http://cheapcial.com/cialis-viagra.php>Cialis Viagra</a> Levitra Vardenafil Preisvergleich Dove Si Compra Il Viagra Senza Ricetta <a href=http://propecia-cheap-price.propecorder.com>Propecia Cheap Price</a> Medicament Pour Avorter Sans Ordonnance Define Zithromax <a href=http://propecia-brand.propecpills.com>Propecia Brand</a> Generic Pills Online Tomar Viagra Durar Mas <a href=http://cial40mg.com/tadalafil-tablets.php>Tadalafil Tablets</a> Amoxicillin Dosage For Tooth Infection Zithromax Powder Online <a href=http://buy-cialis-online.cial5mg.com>Buy Cialis Online</a> Amoxicillin Claw

Comment posted by Chrsacle( emailtry-rx.com ), 06/11/2017 at 4:51pm (UTC):
Johnson And Johnsontretinoin A .05 <a href=http://buylevitraeufast.com/buy-levitra-forum.php>Buy Levitra Forum</a> Buy Norinyl Without Prescription Amoxicilina For Sale On Line Pharmacy <a href=http://leviplus.com/buy-brand-levitra.php>Buy Brand Levitra</a> Cialis Without A Doctors Prescription How Long Is Zithromax Good For <a href=http://cial40mg.com/buy-tadalafil-online.php>Buy Tadalafil Online</a> Can I Take Amoxicillin With Citalopram Canada Cildentifil For Sale <a href=http://order-kamagra-tablets.kamagorder.com>Order Kamagra Tablets</a> Nexium Discounts And Coupons Ou Acheter Du Viagra Forum <a href=http://natural-propecia.propecpills.com>Natural Propecia</a> Cialis 200 Mg In India Viagra 50 Mg Price Walmart <a href=http://dprixe.com>cialis</a> Viamedic Coupon Acheter Viagra Montreal <a href=http://viasamples.com/viagra-cost.php>Viagra Cost</a> Lasix No Prescription Needed Spironolactone By Paypal Payment <a href=http://dprixe.com>cialis viagra levitra kaufen rezeptfrei</a> Levitra Tempi Di Azione

Comment posted by WilbSwateRef( milotry-rx.com ), 06/11/2017 at 9:51am (UTC):
Afin Amoxil <a href=http://generic-propecia-cost.propecpills.com>Generic Propecia Cost</a> Cialis 10 Mg O 20 Mg Real Viagra Online Canada <a href=http://low-price-levitra.levitab.com>Low Price Levitra</a> Amoxicillin And Vitamin Propecia 1 4 <a href=http://cialusa.com>cialis</a> Propecia Where To Order Buy Fluconazole No Perscription <a href=http://priligy-venta-en-usa.prilipills.com>Priligy Venta En Usa</a> 30 Mg Accutane From Canada Online Discount Propecia Without A Prescription <a href=http://staminamen.com/brand-cialis-online.php>Brand Cialis Online</a> Acheter Cialis Occasion Priligy Revenu <a href=http://bestlevi.com/levitra-20mg-online.php>Levitra 20mg Online</a> Viagra Vendo Kamagra Frankfurt <a href=http://bpdrugs.com/tadalafil-20mg.php>Tadalafil 20mg</a> Viagra Express Shipping In New Jersey Comprar Viagra Online Espana <a href=http://dapoxetine-online.prilipills.com>Dapoxetine Online</a> Canadian Drugstore Peces De Colores Priligy <a href=http://levicost.com>only here what is levitra</a> Cheapest Cialis 20mg Amoxicillin Dosage In Children <a href=http://cialbuy.com>buy cialis</a> No Prescription Robaxin Buy Keflex Lyme <a href=http://viasamples.com/buy-viagra-online.php>Buy Viagra Online</a> Baclofene Zentiva Buy Real Viagra And Cialis <a href=http://priligy-cheap.prilipills.com>Priligy Cheap</a> Cheap Generic Cipro Propecia Canadian <a href=http://comprar-propecia.propecpills.com>Comprar Propecia</a> Precose Priligy Online Espana <a href=http://leviplus.com/price-of-levitra.php>Price Of Levitra</a> Stendra Vs Viagra Canadian Discount Pharmacies <a href=http://cheap-cialis-20mg.tadalaf.com>Cheap Cialis 20mg</a> 3g Amoxicillin Oral Dose

Comment posted by JamAdvasse( email1try-rx.com ), 06/03/2017 at 10:58am (UTC):
Propecia Cialis <a href=http://by-cheap-viagra.via100mg.com>By Cheap Viagra</a> Cheapviagrausa Cephalexin Cap 500mg Sinus Infection <a href=http://order-viagra.viapill.com>Order Viagra</a> Cialis Generico Venta Viagra Bestellen Online <a href=http://leviusa.com>brand levitra online</a> Pharmacy Rx One Coupon Amoxicillin And Yeast Infections <a href=http://viacheap.com>buy viagra</a> Cephalexin Kill Coccidia Acquistare Cialis <a href=http://finasteride-propecia.propecorder.com>Finasteride Propecia</a> Amoxicillin Side Effects In Cats Breast Milk Keflex Allergy <a href=http://levitra-generic.buylevi.com>Levitra Generic</a> Keflex Used For Pierced Ear Infection Acheter Cialis Sans Ordonnance En Pharmacie <a href=http://priliorder.com>Buy Priligy</a> Propecia Androgenos Kamagra En Neonatos <a href=http://priligy-dapoxetine-buy.priliorder.com>Priligy Dapoxetine Buy</a> Priligy 30mg Tablets

Comment posted by Chrsacle( emailtry-rx.com ), 05/25/2017 at 6:21am (UTC):
Comprar Levitra Barato <a href=http://cial5mg.xyz/generic-cialis.php>Generic Cialis</a> Furosemida Tabletas Enlina Buy Generic Levitra Overnight <a href=http://viag1.xyz/purchase-viagra-usa.php>Purchase Viagra Usa</a> Buy Doxycycline Vietnam Macrobid 100mg Online <a href=http://zol1.xyz/cheapest-zoloft-online.php>Cheapest Zoloft Online</a> Amoxicillin Wheat Allergy Buy Levitra?20mg <a href=http://cial5mg.xyz/cialis-buy.php>Cialis Buy</a> When Will We Be Able To Buy Alli Again Xenical 600 Mg <a href=http://viag1.xyz/sildenafil-generic.php>Sildenafil Generic</a> Cialis 10mg Efficacite

Add comment to this page:
Your Name:
Your Email address:
Your website URL:
Your message:

You can help this website
by donate or
you can click an

IGNOU Students
Sample Synopsis

Time Table BCA 2009
Projects (Vb n ASPnet) : Download
Synopsis Form

Training Letter

Guide Remuneration Form

Certificates of Originality

Java KeyWords - PDF

Java KeyWords - Wikipedia

Click Here / Click Here

Edit Plus (Use it as Java editor) Download

How to configure EditPlus to compile JAVA codes click here

PC Games (Full, Rip, Compressed)
© 2007 - 2009 HamidRaza - Today, there have been 10 visitors (110 hits) on this page!
=> Do you also want a homepage for free? Then click here! <=