Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Good Database Design is what everyone wants to achieve to avoid the consequences of dealing with a bad design.The following are the objectives of a good database design −Avoid Redundant DataThe table in the database should be constructed following standards and with utmost dedication. It should have different fields and minimize redundant data. The table should always have a Primary Key that would be a unique id.Faultless InformationThe database should follow the standards and conventions and provide meaningful information useful to the organization.Data IntegrityIntegrity assists in guaranteeing that the values are valid and faultless. Data Integrity is set to tables, ... Read More
Relationships in DBMS can be stated as a relation between two entities like Employee-Department, Student-Course, etc.One-to-One relationship in DBMS is a relationship between an instance of an entity with another.The relation can be stated as −An Employee is issued an Employee ID Card. An individual employee is offered a unique ID card in the company. Here, Employee and ID Card (ID_Card) are entities.
Database Design can be a tiresome task and you would need to follow the below approach and tackle the challenges to get a well-designed database.The concerns and challenges with Database design are the following −Following Design StandardsConsidering Design Standards while designing a database is quite essential. It gives you components that are well defined. With this, you can also easily evaluate an existing design.If you are unable to follow the design standards approach, then do not expect the design to be proper and you will not be able to evaluate it.Achieving High Processing SpeedEveryone needs faster access for the relationships ... Read More
An attribute is fully functional dependent on another attribute, if it is Functionally Dependent on that attribute and not on any of its proper subset.For example, an attribute Q is fully functional dependent on another attribute P, if it is Functionally Dependent on P and not on any of the proper subset of P.Let us see an example −ProjectIDProjectCost00110000015000EmpIDProjectIDDaysE099001320E056002190The above relations states that −Days are the number of days spent on the project.EmpID, ProjectID, ProjectCost -> DaysHowever, it is not fully functional dependent.Whereas the subset {EmpID, ProjectID} can easily determine the {Days} spent on the project by the employee.This summarizes ... Read More
A good database design has many benefits and is a goal to achieve for every DBA −Easy Retrieval of InformationIf the design is developed properly, then it would be easier to retrieve information. Correct design means the tables, constraints, and relationships created are flawless.Easier ModificationChanges that you make to the value of a given field will not adversely affect the values of other fields within the table.Easy to MaintainThe database structure should be easy to maintain. The design is perfect if changes in one field is not affecting changes in another field.InformationWith a good design, you can enhance the quality ... Read More
Many-to-Many relationship in DBMS is a relationship between more than one instance of an entity with more than one instance of another entity i.e. both the entities can have many relationships between each other.The relation can be stated as −Let us see an example −Many Authors can write a Book, whereas an Author has written more than one book.Here, Book and Author are entities.Let’s say a book has two authors, whereas an individual author has written six books till now.
Database Design Methodologies has phases to guide the designer for assistance. The Methodology has a structured approach to help in the design process.The following are the phases/ models −Conceptual PhaseThe Conceptual phase lets you know the entities and the relation between them. It describes the conceptual schema. The entities & relations are defined here.Logical PhaseLogical data model provides details about the data to the physical phase. The physical process gives ER Diagram, data dictionary, schema, etc that acts as a source for the physical design process.Physical PhaseThe physical database design allows the designer to decide on how the database will ... Read More
To set flex items to be of equal width column, use the flex-fill class. The class displays the items as equal width. In the below example screenshot, you can see that we have four flex items with equal width columns −The flex-fill class is used for every flex items and in this way, we can set equal width. Below, we have two flex items − Example 1 Example 2 ExampleLive DemoThe following is an example showing how to set flex items into equal width columns using the flex-fill class − Bootstrap Example ... Read More
The history of data models had three generations of DBMS −Hierarchical System was the first generation of DBMS. The first generation also came with the CODASYL system. Both of them introduced in 1960s.The second generation includes the Relational Model. Dr. E.F.Codd introduced it in 1970.The third generation includes Object-Relational DBMS and Object-Oriented DBMS.The history timeline of databases is shown below −File based systemsFile based systems came in 1960s and was widely used. It stores information and organize it into storage devices like a hard disk, a CD-ROM, USB, SSD, floppy disk, etc.Relational ModelRelational Model introduced by E.F.Codd in 1969. The ... Read More
Entity in DBMS can be a real-world object with an existence, For example, in a Company database, the entities can be Employees, Department, Project, etc. In a College database, the entities are Profession, Students, Result, Activities, etc.An entity is represented as a single rectangle, shown belowThe following are the entity relationships −One-to-One RelationshipUnder One-to-One (1:1) relationship, an instance of entity P is related to instance of entity Q and an instance of entity Q is related to instance of entity P.Let us see an example −A person can have only one passport, and a passport is assigned to a single person.One-to-Many RelationshipUnder ... Read More