Database Designing
In the database design stage, you can design th entity-Relationship(E-R) model of the database. An entity-Relationship model is used to represent the logical structure of a database in the form of a diagram. This diagram is known as an entity-relationship diagram. An entity-relationship diagram consist of many shapes, such as oval, rectangle, arrows and diamond to represent attributes of the database, entity of the database, relationship between entities and the scope of the entities. After designing the entity-relationship model of the database, you have to check the correctness of the entity-relationship model. To check the correctness of the entity-relationship model, you need to use normalization, which helps to remove redundancy and provides consistency of the entities in the database. The result is used the entity-relationship diagram. After designing an accurate entity-relationship model of the database, you have to define the set of tables, which are required to manage the data in the conceptual level of the database. After defining all the tables of the database, you have to create those tables using different language of RDBMS. You can also specify primary key, foreign key, different constraints and integrity rules, such as Not Null and Unique for the tables in a database.
Like it on Facebook, Tweet it or share this article on other bookmarking websites.