Define atomicity and aggregation, Database Management System

Assignment Help:

 

Atomicity: Either all functions are laid out or none are. Users could not have to think about the effect of incomplete operations. DBMS ensures this by undoing the functions of incomplete operations.

 Aggregation: A concept which is needed to model a relationship between relationships and a collection of entities. It is used when we require express a relationship among relationships.

Name the three major groups of files on disk that devolve a database in Oracle There are three major groups of files on disk that devolve a database.

  • Database files
  • Control files
  • Redo logs

 The most important of these are the database folders where the actual data insides. The control files and the redo logs support the properties of the architecture itself. All three groups of files must be open, present, and available to Oracle for any data on the database to be utilized. Without these files, you cannot operate the database, and the database administrator has to answer some or the entire database needs a backup, if there is one.

 


Related Discussions:- Define atomicity and aggregation

Project, I have a small project that contains 3 deliverable s. I have done ...

I have a small project that contains 3 deliverable s. I have done the first one and I would like you to help me with second one

What is indexed sequential file organization, What is indexed sequential fi...

What is indexed sequential file organization? What are the applications of this organization?  Ans: An index file can be employed to effectively overcome the problem of storing

What is relationship instance, What is relationship instance ? Relation...

What is relationship instance ? Relationship Instance - A relationship is a relation between two or more entities. An instance of relationship set is a set of relationships.

Proposed information analysis, Add generation capabilities and/or tailor th...

Add generation capabilities and/or tailor the built-in functionality of generator. This enables you to produce "all" the test data for the MySQL tables you produced in the previous

Write the motivations led to development of oo-dbms, Write the motivations ...

Write the motivations led to development of OO-DBMS? 1.  Programmer frustration with RDBMSs. 2.  Requirement for special features.

Define weak and strong entity sets, Define weak and strong entity sets?  ...

Define weak and strong entity sets?  Weak entity  set:  entity  set  that  do not  have  key  attribute  of  their  own are  known as weak entity sets.  Strong entity set

Database, why are older data models are being replaced by new data models

why are older data models are being replaced by new data models

Entity-relationship diagram, 1. Item based services will be charged fixed p...

1. Item based services will be charged fixed prices, and time-based will be charged variably depending on time. Such as per hour. Item-based: Fixed, pedicure, waxing, threading, fa

Write a qbe query to display names of cs department, Consider a table stude...

Consider a table student (std_id, std_name, date_of_birth, percent_marks, dept_name). Write a QBE query to display names of Computer Science department students who have scored mo

Database models, why are older data models are being replaced by new data m...

why are older data models are being replaced by new data models

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd