Start Discovering Solved Questions and Your Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
redo logsany database must have minimum two redo logs these are the rules for the database the redo logs record all modifies to the system
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
partial key it is a group of attributes that can uniquely identify small entities and that are related to same base entity it is sometime named
the domain that you will model in this assignment is that of courses and students at a university. so as not to make the task too large and
relational model the relational model uses a collection of tables to represent both data and the relationships among those data. each table has
q. why would you choose a database system instead of simply storing data in operating system file? define at a base concept in details.sol.
what do you mean by dbms? what is its need and what are its goals. explain? or explain data base management
q. explain data aggregation and discuss different design constraints.sol. aggregation one limitation of the e-r model is that it
what are the advantages and disadvantages of using a database system.sol. advantages of database system dbms 1 data redundancy and inconsistency
q. explain the terms key constraints participation constraints and mapping caradinalities in er model. participation constraints the
q. describe how an er schema can be represented by relation schemas and constraints arising from er design can be mapped to constraints on a relation
q. what is relational algebra and calculus? explain the relational algebra operators - selection and predicate set operation joins and
q. define a weak entity set and its identifying relationship. list the necessary conditions for a meaningful identifying relationship set of a
q. with the help of a suitable diagram gives module wise explanation of system architecture of dbms.sol. a database management is a collection of
Include what database applications are used (Microsoft Access, DB2, Oracle, etc.). Conclude by proposing improvements. For large organizations, restrict the scope of the paper to the department in whi
Business Intelligence tool and how does an iterative approach help that process?
Write a 200 word paper that decribes the distinctions of data and information
Using a data flow diagram describe a change management procedure, which might be used in a large organization concerned with developing software for external clients. Change may be suggested fro
Use the Library and other quality resources for information about the role of computer forensics and security within organizations. Describe the roles of a computer forensics expert and a computer sec
Given below is a case study for an art museum database. The museum has a collection of ART_OBJECTs. Each ART_OBJECT has a unique IdNo, an Artist,
Discuss the thought process of a DBA as they design a database to be fault tolerant. What policies would you recommend to achieve this goal? Analyze and comment on the different factors that will affe
Your current database uses dictionary managed tablespaces. In running various performance tuning scripts, you have discovered that one of these tablespaces seems to have run out of space long befor
What information is available from a relational database containing one relation with the attributes Name, Employee identification number, and Address that is not available from a database containing
You need to create a new user named ASSOCDBA1 and a new ROLE named JRDBA1 that can be used for an assistant DBA. You want the new role to contain the DBA role that the SYSTEM user has with ADMIN OPTIO
Backup and Recovery is the number 1 responsibility of the DBA. Yet many organizations do not have a documented policy for backups, not do they practice a recovery of the database