Author: Sunny Singh

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 Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, 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 Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, 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 Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, 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 Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, 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 Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, 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 Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, 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 Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, 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 3

Control of Data Redundancy Ideally, the database approach stores each piece of data in a place in the database. In certain cases, there is still data redundancy to increase system performance. However, this redundancy is controlled as well as minimized through application programming by introducing the least amount of redundancy as much as possible in the database design. Data sharing...

This content is for Pro Member, Pro, Standard Member, Standard, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, 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 1

Prior to Introduction of Database Management Systems (DBMS) The way computers manage data has changed dramatically in the last few decades. Today’s end users take the many advantages of a database system for granted. Not so long ago, computers used a less elegant as well as expensive approach to data management called a file-based system. File-Based System One way to...

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

Concepts of Network Model and Hierarchical Data Structure – Part 4

Properties of a Hierarchical Schema The hierarchical schema of record types as well as Parent Child Relationship (PCR) types should have the subsequent properties: A record type, known as a root of the hierarchical schema, do not take part in any type of Parent Child Relationship (PCR) as a child record type. Each and every single record type excluding the...

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