What is database management system?
Database management system is a set of computer programs that controls the creation, maintenance, and the use of database with computer as a platform or of an organization-wide database development in the hands of database administrators and other specialists. DBMS is a system software package that helps the use of integrated collection of data records and files known as databases.
What is the primary role of data in business?
A business can be defined as an organization that provides goods and services to others who wants or need them. The primary role of data in a business is to keep record of persons and their information. Data is information that is needed to access and to look at persons records.
How do primary processes relate to data collection activities?
In any organization, data is collected in numerous ways for an ever-increasing number reasons. Data may be abstracted from primary source and collected for unique reporting requirement. When faced with a new application of data, the following factors should be considered. Accountability.
How do primary processes relates to an organization core business?
A business process or business method is a collection of related, structured activities or tasks that produce a specific service or product. A business process begins with a customer need and ends with a customer need fulfillment
Why would you not organize data in a DBMS
Well, if you are not a database personnel who don’t know that you are doing in a business, you will not organize the data. But for the record, data should be organized in a database systems
What is data repository?
Data repository simply means a facility where things can be deposited for storage of safekeeping. It is a data storage unit where the physical data files are kept and is the central storage location for the data content.
What is data dictionary?
There are 2 aspects to the concept of data. The structure of the data consists of the field name, field sizes and data types. The next aspect to it is the actual data values which are stored in the fields. The first part relates to the structure and is stored separately from the database values as the data dictionary or data catalog. Therefore, data dictionary contains data element structures and the relationships among data elements.
What is data access?
This includes the fundamental operations that can be applied to data. Every database management system provides the data some basic access operations. The four basic functions which are provided are READ- data contained in the database, ADD-data in the database, UPDATE-individual parts of the data in the database and DELETE-portions of data in the database.
What is a transaction?
A transaction in SQL (structured query language) is a larger unit of database processing that contains one or more database access operations like insertion ,deletion, retrieval and modification operations.
It is a series of statements or commands that execute as a group. All statements must either run successfully or all must be rolled back. This compensates for errors that might occur during transaction execution. When a transaction is initiated it should complete all the tasks and leave the data in the database in a consistent state. There are two types of transactions: explicit and implicit .This is a Database Terminology.
What is data Abstraction?
Data abstraction helps one to look at data that breaks down into its basic components, giving the us we different ways of looking at the data. In other words it hides the complexities of data design at the levels where they are not required.
What is a cluster index?
A clustered index determines the physical order of data in a table. A clustered index is analogous to a telephone directory, which arranges data by last name. Because the clusted index dictates the physical storage order of the data in the table, a table can contain only one clusted index.
What is a query processor?
A relational database consists of many parts, but at its heart are two major components, the storage engine and the query processor. The query processor accepts SQL syntax, selects a plan for executing the syntax and then executes the chosen plan. It isolates the user from the details of execution
Wednesday, March 3, 2010
Subscribe to:
Posts (Atom)
About Me
- lodgements
- I am a third year Information Science major with a minor in Mass Communication. I am Loud and also noisy.I enjoying giving alot of trouble and putting a smile on persons face. Above all I love the Lord and do my best to serve Him with the talents He has given me.