Enter your keyword

MySQL

Definition MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL). MySQL runs on virtually all platforms, including Linux, UNIX, and Windows. Although it can be used in a wide range of applications, MySQL is most often associated with web-based applications and online publishing and is an important component […]

Database Design And Normalization

Definition Database normalization, or simply normalisation, is the process of organizing the columns (attributes) and tables (relations) of a relational database to minimize data redundancy. Normalization involves decomposing a table into less redundant (and smaller) tables without losing information, and then linking the data back together by defining foreign keys in the old table referencing […]

PRIMARY KEY

Definition A primary key, also called a primary keyword, is a key in a relational database that is unique for each record. It is a unique identifier, such as a driver license number, telephone number (including area code), or vehicle identification number (VIN). A relational database must always have one and only one primary key. […]

KEYS

Definition According to the SQL Standard, a key is a subset of columns in a table that allow a row to be uniquely identified. So, a key can be more than just one column. And, every row in the table will have a unique value for the key – or a unique combination of values […]

STRING DATA TYPES

Definition A string is a data type used in programming, such as an integer and floating point unit, but is used to represent text rather than numbers. It is comprised of a set of characters that can also contain spaces and numbers. For example, the word “hamburger” and the phrase “I ate 3 hamburgers” are […]

Database and SQL

Definition Commonly asked interview questions on Constructors 1. what is client and server Answer : 2. What is DDL, DML and DCL commands ? Answer : 3. what is difference between DBMS and RDBMS ? Answer : Take Sample Test Reference Books 1. Head First SQL

Normal Form of Database Normalization

Definition Second Normal Form of Database Normalization Third Normal Form of Database Normalization Commonly asked interview questions on Constructors 1. what is First normal form? Answer : 2. What is second normal form? Answer : 3. what is third normal form? Answer : Take Sample Test Reference Books 1. Head First SQL