Loading...
Chapter 6 – Mapping from Logical ERD to Relational ERD
Loading...
Category: Database Analysis and Design
Loading...
Reload document 
Open in new tab Chapter 5 – Crow’s Foot Notation
Crow’s Foot Notation is the most popular notion used to draw Database Modelling Diagram such as Entity Relationship Diagram (ERD) or Enhanced Entity Relationship Diagram (EERD). Note: 1.Participation/ Association: -The line that connects two entities denotes the participation/ association of two entities -The participation can be denoted as identified by line or unidentified by dash…
Database Forward Engineering vs Reverse Engineering
1.Database Forward Engineering Database Forward Engineering is the process to create the Relational Model Diagram or export to a DDL file from a Logical Model Diagram. A Logical Model Diagram contains entities and relationship design for the database. It also contains columns for tables as well as defined of Primary Key, Foreign Key, Constraints, etc….
Read More “Database Forward Engineering vs Reverse Engineering” »
Chapter 4 – How to know Relation in 2NF or 3NF?
First, we need to know about dependencies 1. Functional Dependencies -Dependency can be understand as one/more attributes depend on other one/more attributes Example: studentid –> (studentname, dob) (semesterid, courseid) –> coursefee 1.1 Functional Dependency (FD): This is the dependency of non-key attributes to key attributes +If non-key attributes depend on the whole key PK(attr1, attr2),…
Read More “Chapter 4 – How to know Relation in 2NF or 3NF?” »
Chapter 3 – Table Index and Constraint
1.Index -As we know that PK is the unique constraint in a table. -If we want to make one or more columns that are NOT keys but to be unique. We can create UNIQUE INDEX. Ex: tb1 (c1, c2, c3, c4, c5) –> We have c1 is PK –> c3, c4 are not keys, but…
Chapter 2 – Entity, Type and Key
1.Entity -By convert the relation, we have entities with attributes in each of entities -In each entities, we can define a Primary Key (PK) for an entity -A weak entity is an entity with a composite key. A weak entity is denoted by double rectangle box compare to single rectangle box of normal entity. 2….
Chapter 1 – What is Normalization?
Normalization is the process to normalize (split) a large relation (entity/table) into smaller relations (entities/tables) The Normalization start with a UNF (UnNormalization Form) form. Then, UNF will be processed into 1NF 2NF 3NF BCNF and ERD 1.1NF: First Normalization Form, in this phrase, we will: -Detect the Primary Key (PK) for the large relation -Define…
Software Engineering Tool Collection
A.System Analysis and Design Tool – Database Design Tool 1.Microsoft Visio – Commercial Software 2.Visual Paradigm – Community version 3.UMLet – Freeware 4.LucidChart – Freeware B.Database Modelling Tool 1.Oracle +Oracle SQL Developer Data Modeler – Freeware 2.MySQL +MySQL WorkBench – Freeware These tools enable to design from ERD -> Relational Database -> Export to SQL