1 / 23

CBAD2103

CBAD2103. Data Analysis and Modeling. Chapter 7. Conceptual Design Methodology. 1. Determination of entity; 2. Determination of relationship; 3. Determination of attribute for entity and relationship; 4. Determination of domain for attribute; 5. Determination of primary key; and

talli
Download Presentation

CBAD2103

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CBAD2103 Data Analysis and Modeling

  2. Chapter 7 Conceptual Design Methodology

  3. 1. Determination of entity; 2. Determination of relationship; 3. Determination of attribute for entity and relationship; 4. Determination of domain for attribute; 5. Determination of primary key; and 6. Re-evaluation of data model with users. CONCEPTUAL DESIGNING PHASE

  4. The determination of an entity in a given particular environment is the first thing you have to do. The usual method used to determine entity is to examine the requirement specification of users. implementing each class. ENTITY DETERMINATION

  5. Worker Works Company • Students Register Course • Manager Supervises Staff RELATIONSHIP DETERMINATION

  6. Attribute can be determined when the noun mentioned constitutes a property, quality, identifier or characteristic of any of these entities or relationships modeled in database. • In recognizing attributes, it is important for you to model the attributes as simple or composite, solitary, multi-valued or derived attribute. • All attributes must be documented. DETERMINING ATTRIBUTE FOR ENTITY OR RELATIONSHIP

  7. The main purpose of this step is to determine the domain for each modeled attribute. A Domain is the type of value permitted for each attribute. • The following are examples of how you can determine attribute domain. • Attribute Domain for Worker No is five characters with the first two characters represented by letters of the alphabet and the rest by digits ranging from 1 to 999. • Attribute Domain for Gender is either F or M which is an alphabet character. DETERMINING ATTRIBUTE DOMAIN

  8. A key candidate is an attribute or a set of minimum attributes that uniquely recognizes occurrences in an entity. • When choosing a primary key from several possible key candidates you may want to use the following guidelines: • The key candidate with the minimum attribute sets. • The key candidate that is least likely to have its values changed. • The key candidate with the shortest characters (for key candidate from the character domain). • The key candidate with lowest maximum value (for a key candidate from the numeric domain). • The key candidate that is the easiest to use by users of the system. DETERMINING KEY

  9. Tutorial 1

  10. Chapter 8 Normalization

  11. Technique of determining and evaluating the resultant logical data model to ensure that it is accurate as well as containing the minimum amount of anomalies. • The process of normalization is a formal method of determining relationships based on the primary key or candidate key and of functional dependency between attributes. PURPOSE OF NORMALIZATION

  12. Relationships which contain the element of excess data often cause problems known as anomalies of updating. The concept of updating anomalies: (i) insertion anomaly (ii) deletion anomaly (iii) modification anomaly

  13. If A and B are attributes of the H relationship, B is said to be functionally dependent on A (represented as A-) if each value of A is only connected to only one value of B. FUNCTIONAL DEPENDENCY

  14. The purpose of normalization is to minimize anomalies found in each relationship. • Through this process, relationships which contain excess data and high anomalies will be divided into several tables which contain the minimum number of anomalies. NORMALIZATION PROCESS

  15. Unusual form (UNF) is a table relationship which contains one or more repetitive groups. • The first normalization form (1NF) is a relationship which crosses between each row and column containing only one value (fulfils relationship characteristics). • Each relationship or table in the UNF form must be normalized to 1NF form. • The change to 1NF form is done by identifying the repetitive group and remove it from the relationship mentioned 1NF Form

  16. The second normalization form (2NF) is based on the concept of full functional dependency. To clarify the concept of full functional dependency, consider the following relationship: The second normalization form (2NF) is a relationship which is already in 1NF form and each attribute is not the full functional dependency key of the overall primary key. 2NF Form

  17. The third normalization form (3NF) is a relationship which is already in the form of 1NF and 2NF and there are no non-key attributes which are transitively dependent on the primary key. Project (ProjectNo, ProjectName, WorkerNo, Date of Birth) ProjectNo - ProjectName, WorkerNo WorkerNo - Date of Birth Based on the concept of transitive dependency, ProjectNo - Date of Birth 3NF Form

More Related