Relational Database - Logical design of tables in relational database
In articles of creating database with schema, I have suggested to design the schema before establishing tables in the database. Frankly speaking, you may still be confused about the design of the schema. As a result, I am going to talk more about the logical design and tables structure in the relational database. Firstly, I do highlight the relational databases could be far away from that of NoSQL and non-relational databases so do not mix up each of them. In order to make this tutorial more readable, the list of terms are explained and list out below: Database: All tables and raw data stored and consolidated in Table (Entity): Arrange and store data in with table structure (e.g. Member Table, Product Table) Column (Attribute): the column of the table (e.g. member_id, member_name, gender in Member Table) Row (Record): the row of the table (e.g. 1, horace, M) Some of you should have heard about "Normalization". Actually, the process of normalization is quite simila...