Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Question:
A DBMS built for Online Transaction Processing (OLTP) is generally regarded as unsuitable for data warehousing. Each system is designed with a different set of requirements.
(i) Give example of how OLTP systems differ from data warehousing systems.
(ii) Illustrtae any problems that are associated with developing and managing a data warehouse.
(iii) Explain what is meant by Metadata and what are the purposes of a Metadata in data warehouse architecture.
(iv) Show how data marts differ from data warehouses and identify any two reasons for implementing a data mart.
What is persistency? Persistency ensures which data is stored and that after the object is no longer available (program stops running) the data will be available to other users
State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record
What is serialization? Where it is used and why? Serialization is a basic term used for mechanisms which enable objects and object structures to be converted into portable for
i have assignments I don''t have time to finish because of work and other assignments, can you help with this? All are from the book Darabase design, application development and a
Describe Dynamic Model. The dynamic model specifies allowable sequences of changes to the objects from an object model. It contains event trace diagrams describing scenarios. A
For each 1: n relationship type R involving two entities E1 and E2, we recognize the entity type (say E1) at the n-side of the relationship type R and contain primary key of the en
what is primary key
2NF Normal Form : A relation schema process R is in 2NF if it is in 1NF and each non-prime attribute A in R is fully functionally related on primary key. Second normal form (2N
Lost Updates : Suppose the two transactions T3 and T4 run simultaneously and they happen to be interleaved in the following way (suppose the initial value of X as 10000):
Explain the Weak Entity Set An Entity set which does not have sufficient attribute to make a primay key is known as weak entity set. For instance, dependents of an employee in
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd