Categories
Posts on Database label.
MySQL Command Line Cheat Sheet
Posted on 23rd Sep 2018 03:58:47 in Database
MySQL cheat sheet provides you with the most commonly used MySQL commands and statements that help you work with MySQL more effectively.
Reset a MySQL root password in command line interface
Posted on 23rd Sep 2018 03:41:47 in Database
The MySQL root password allows the root user to have full access to the MySQL database. You must have (Linux) root or (Windows) Administrator access to the Cloud Server to reset the MySQL root password.
Note: The Cloud Server (Linux) root or (Windows) Administrator account password is not the same as the MySQL password. The Cloud Server password allows access to the server. The MySQL root password allows access only to the MySQL database
Use the following steps to reset a MySQL root password by using the command line interface.
Database Design - I
Posted on 20th Jan 2017 23:22:17 in Database
The requirements and the collection analysis phase produce both data requirements and functional requirements. The data requirements are used as a source of database design. The data requirements should be specified in as detailed and complete form as possible.
In parallel with specifying the data requirements, it is useful to specify the known functional requirements of the application. These consist of user-defined operations that will be applied to the database (retrievals and updates). The functional requirements are used as a source of application software design. Of course some functions may produce also needs for database design.
Note that some phases are database management system independent and some are dependent. The idea is to design first the database without thinking about the actual database system - just to concentrate on the data.
Database Design and Implementation is applicable for whatever industry your in. Here is a step by step approach to designing and implementing a database in your organisation.
Database design is the process of producing a detailed data model of database. This data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a data definition language, which can then be used to create a database.
Modeling Database - I
Posted on 19th Jan 2017 01:07:46 in Database
This article/tutorial will teach the basis of relational database design and explains how to make a good database design. It is a rather long text, but we advise to read all of it. Designing a database is in fact fairly easy, but there are a few rules to stick to. It is important to know what these rules are, but more importantly is to know why these rules exist, otherwise you will tend to make mistakes!
Modeling Database - II
Posted on 14th Jan 2017 20:54:39 in Database
Normalization of Database
In the first part of this tutorial on modeling database -I we saw how we can model a table. In this part we will focus on what we mean by normalization of relational DB, what are few ways to do it.
Database normalization, or simply normalization, is the process of organizing the columns (attributes) and tables (relations) of a relational database to reduce data redundancy and improve data integrity.
Normalization involves arranging attributes in tables based on dependencies between attributes, ensuring that the dependencies are properly enforced by database integrity constraints.
"Don’t grieve. Anything you lose comes round in another form."
-Rumi
"Let the beauty we love be what we do."
-Rumi