A prearranged collection of figures known as data is called database.
2. What is DBMS?
It is a collection of programs that enables user to create and maintain a Database.
3. What is a Database system?
The database and DBMS software together is called as Database system.
4. What is RDBMS ?
RDBMS are database management systems that maintain data records and indices in tables.
5. What are the advantages of DBMS?
Redundancy is controlled.
Unauthorised access is restricted.
Providing multiple user interfaces.
Enforcing integrity constraints.
Providing backup and recovery.
6. What are the disadvantage in File Processing System?
Data redundancy and inconsistency.
Difficult in accessing data.
Concurrent access is not possible.
7. Whats the difference between DBMS and RDBMS?
DBMS provides a systematic and organized way of storing, managing and retreiving from collection of logically related information. RDBMS also provides what DBMS provides but above that it provides relationship integrity.
8. Describe the three levels of data abstraction?
The are three levels of abstraction:
Physical level: The lowest level of abstraction describes how data are stored.
Logical level: The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
View level: The highest level of abstraction describes only part of entire database.
9. What is SQL ?
Structured Query Language(SQL) is a language designed specifically for communicating with databases. SQL is an ANSI (American National Standards Institute) standard
10. What are the different type of SQL 's statements ?
SQL statements are broadly classified into three. They...
... middle of paper ...
There are two Integrity rules.
Entity Integrity: States that "Primary key cannot have NULL value"
Referential Integrity: States that "Foreign Key can be either a NULL value or should be Primary Key value of other relation.
17. What are super, primary, candidate and foreign keys?
A superkey is a set of attributes of a relation schema upon which all attributes of the schema are functionally dependent. No two rows can have the same value of super key attributes.
A Candidate key is minimal superkey, i.e., no proper subset of Candidate key attributes can be a superkey.
A Primary Key is one of the candidate keys. One of the candidate keys is selected as most important and becomes the primary key. There cannot be more that one primary keys in a table.
Foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table.
Need Writing Help?
Get feedback on grammar, clarity, concision and logic instantly.Check your paper »
- The ultimate aim of this paper is to discuss the history of Database Management Systems (DBMSs) and in particular the Relational Database Management System (RDBMS) (McManus, 2003). The paper will start with the definition of DBMSs and an explanation of their functions. The paper will then list the various database models in existence today. The next stage will be to dive in to the history of DBMSs starting from the 1960s, when the first database systems made their way into the computing world to modern trends in DBMS development.... [tags: hardware, RDBMS, Edgar codd, SQL]
2233 words (6.4 pages)
- Comparison of RDBMS with OODBMS: Choosing between these options need to have a closer look at some different aspects. The main keywords are development, performance and access to different sources (it’s possible that more than one application needs the same data source). The last one is a necessary point for DreamHome company, because all the different offices can have different applications and need the data from the same database. The performance of the Database is concerned on the structure of the data.... [tags: Database, Relational model]
816 words (2.3 pages)
- Every application in the real world needs to interact with databases. Java Database Connectivity (JDBC) is the Application Programming Interface (API) used to build Java applications that can interact with relational databases. There are many relational databases such as Oracle, My SQL, DB2, Java DB, Dbase, Sybase, Ingress, Informix, FoxPro and so on. The researcher will be able to use the four types of JDBC drivers to interact with any kind of database in the world. In this iteration, the researcher also learns Structured Query Language (SQL) which is the underlying language used long with JDBC API to get things done in backend (a term used to refer database).... [tags: SQL, Database, Database management system]
1365 words (3.9 pages)
- In the web space where vast amounts of data is processed and collected, it is typical to store this information in a database. A common form of database is an RDBMS (Relational Database Management System). The act of retrieving and/or storing data to or from an RDBMS is called a transaction (Connolly and Begg, 2014). Connoly and Begg go on to outline the process in which these transactions are applied, by way of a COMMIT or ROLLBACK SQL statement, which are also written to a transaction log and may be used in the event of a systems failure to restore the database to a point prior to the failure.... [tags: SQL, Database, Relational model]
1079 words (3.1 pages)
- A number of recent studies have revealed that most enterprise customers nowadays prefer open source databases over commercial databases. Based on their requirements, the enterprises also have option to choose from a number of open source relational database management systems (RDBMS) including MySQL, MangoDB, Cassandra, Redis and PostgreSQL. But the usage statistics posted on various websites indicate that MySQL is more popular than other open-source and proprietary relational database management systems.... [tags: SQL, Database, Database management system]
716 words (2 pages)
- In this section, the steps and considerations for selecting a suitable database are outlined and explained. These considerations have been developed by professionals through decades of research, implementation and first-hand experience. While they are not a fully set list of considerations, they are widely accepted as relevant and crucial to the developmental process. There are a number of important decisions that are needed when deciding on a suitable database. 1. Choosing the Database Model – Relational or Object etc.... [tags: operating system,dbms, network database]
1581 words (4.5 pages)
- Relational Database Management System for a Cloud Application Lakisha Griffin University of Maryland University College Abstract While a lot of research is currently taking place in technology itself, there is an equally critical requirement for understanding the cloud computing issues. This paper examines “database-as-a-service” (DBaaS) called Relational Cloud. “A DBaaS promises to move much of the operational burden of provisioning, configuration, scaling, performance tuning, backup, privacy, and access control from the database users to the service operator, offering lower overall costs to users.” (Curino, 2011) Database management systems that control web application... [tags: SQL, Database management system, Database]
1802 words (5.1 pages)
- Introduction: Database environment can be classified into three simple categories: a. Human: Database Administrator - They are responsible to monitor and maintain the databases in an organization. Systems Developers - They are responsible for the development of the computer applications which will talk to the database in do the necessary operations and display the results to the end users. b. Machine: User Interface - This is how the computer application looks and what the end user will use to interact.... [tags: human, machine, database]
1389 words (4 pages)
- Evolution of data model The evolution of data model was traced back in 1960s when the first generation of data model – File system model was introduced. File system used to strictly maintain the records and it does not have relationship between the tables. As the requirement to for managing data evolve, in 1970s, hierarchical and network model were used. These data model handle the relationship between the tables and conceptually simple. However, it still using navigational system and complex in implementation.... [tags: Database normalization, Relational model]
1034 words (3 pages)
- Relational Database Management System Oracle provides a flexible RDBMS called Oracle7. Using its features, you can store and manage data with all the advantages of a relational structure plus PL/SQL, an engine that provides you with the ability to store and execute program units. The server offers the options of retrieving data based on optimization techniques. It includes security features that control how a database is accessed and used. Other features include consistency and protection of data through locking mechanisms.... [tags: Database Data]
1093 words (3.1 pages)