Author: Sunny Singh

Pro Members SQL Server Standard Members

Concept of Relational Database Model – Part 2

Join Operation A join operation combines linked tuples of different relationships if and only if a particular join condition is met. It is noted ?. For example, if there are two tables: EMPLOYEE and SALARY; Evaluation: ∏EMP_NAME, SALARY (EMPLOYEES ?. For example, if there are two tables EMPLOYEE and SALARY; Evaluation: (EMPLOYEE ?. For example, if there is two tables…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Concept of Relational Database Model – Part 1

Definition of Relational Database The relational database management system consists of all modern database management systems, such as SQL, MS SQL Server, IBM DB2, Oracle, My-SQL and MS-Access. Data is displayed in groups (rows) in RDBMS. A relational database is the most commonly used database. It contains several tables, and each table has its own primary key. The RDBMS was…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database Model and E-R Diagram – Part 2

Network Model It is an extension of the hierarchical model. In this model, the data is organized graphically and may have more than one main node. In this database model, the data is more closely linked because more relationships are established in this database model. Since the data is more closely linked, access to the data is also easier and…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database Model and E-R Diagram – Part 1

Database Models A database model defines the logical structure and structure of a database and defines how the data is stored, called up and updated in a database management system. While the relational model is the most commonly used database model, there are other models: Flat Data Model Entity-Relationship Model Relational Model Record base Model Network Model Hierarchical Model Object-oriented…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database Management System at a Glance – Part 2

Database Management System Architecture The design of a DBMS depends on its architecture. It can be central or decentralized or hierarchical. The architecture of a DBMS can be viewed as a level or as multiple levels. An architecture with n levels divides the entire system into n linked but independent modules that can be modified, changed, changed or replaced independently…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Database Management System at a Glance – Part 1

Definition of Database The Database is an interdependent collection of data that is used to retrieve, insert, and delete data efficiently. It is also used to organize data in the form of a table, chart, views and reports, etc. For example: The university Database organizes data about the administrator, employees, students and teachers etc. With the Database, you can easily…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Prior to DBMS, Database Approach, Data Model — Part 2

Necessary Concepts of Database What is a Database? A database is a set of related data used to support the events of a given company. A database can be considered as a data warehouse once defined as well as accessible by several users. Database Properties The database has the subsequent features: It is an illustration of few aspect of the…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Prior to DBMS, Database Approach, Data Model — Part 6

Organisation Based on Number of Users A DATABASE MANAGEMENT SYSTEM (DBMS) can be organisation based on the user number it can support. It can be a single-user database system, that assists only one user at a time, or a multi-user database system, that can assists several users simultaneously. Organisation Based on Database Distribution There are four key distribution systems for…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Prior to DBMS, Database Approach, Data Model — Part 5

Data Abstraction Layer In an illustrated view, an individual can understand in what way the dissimilar models work together. Consider this from the highest level, the external model. The external model is the view of the end user data. Generally, a database is a business system that meets the needs of numerous services. On the other hand, a service is…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register
Pro Members SQL Server Standard Members

Prior to DBMS, Database Approach, Data Model — Part 4

Types of Data Models Record-Based Logical Data Models Logical data models based on records deliver concepts that users can understand, however data are not far from the way is kept on the computer. Three known data models of this kind are relational data models, hierarchical data models, as well as network data models. The relational model signifies data in the…...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Log In Register