The first step of CSDP is transforming every familiar example into an elementary fact. For specifying what is needed for the information system, there is a need to know the type of information required for the system. Any information as the output for this system should be stored within the system and should be deliverable by this system. Hence, the first step is beginning with relevant information’s familiar examples, along with expressing these regarding elementary facts. As the check on the work’s quality, several factors have been addressed (1). The entities are well identified, and facts are split into small ones without loss of any information. It includes the first step of this CSDP.
The second step of CSDP is drawing every fact type along with applying the population check. After translating the examples of information into the elementary facts, along with performing quality checks, the second step of CSDP could be completed. A diagram of conceptual schema is drawn that shows every fact type (2). It illustrates every relevant object type, predicate along with reference schemes. After drawing the diagram, it is checked with some sample population.
The third step of CSDP is checking for all entity types which must be combined. After drawing all fact types along with performing the population check, the third step of CSDP could be completed. In this step, it is checked if there exist a few entity types which must be combined. It is also checked if a few fact types could be derived from others with the use of arithmetic computation. For understanding this step’s first part, there is a need in knowing how every object is classified into types.
Forth step of CSDP is adding uniqueness constraints along with checking fact types’ arity. The focus of this CSDP is to specify every elementary fact type; both derived as well as asserted. The remaining CSDP is mostly concerned with all specifying constraints (3). These constraints apply to this database, along with are either dynamic or static. Every static constraint applies to the database’s every individual state, along with might be specified within the schema diagram.
The fifth step of CSDP is adding every mandatory role constraint, along with a check for all logical deviations. Mandatory role constraints are also important as the uniqueness constraints. These indicate what roles should be played by the object type’s population, along with which are also optional. After specifying every mandatory role constraint, there is a check done for seeing if a few fact types might be derived logically from all others.
The sixth and final step of CSDP is adding value, exclusion, equality, subset, along with subtype constraints. This final step of this CSDP includes three types of constraints such as subtype, set comparison, and value (4). The set-comparison constraint is of three types such as exclusion, equality, and subset.
Business Economics Assignment 3: Case Study Analysis on Price Controls in Pharma and Monopoly Power in Airline Industry
Read MoreCSC408 MIS Case Study Assignment Report: Analysis of Issues and Solutions in Information Systems
Read MoreScientific Research Review Assignment 4: Advancements and Ethical Practices in Your Study Area Literature Synthesis
Read MoreOrganizational Development Assignment: Tech Solutions Inc. Case Study on Engagement, Retention, and Inclusive Culture
Read MoreHPGD3103 Instructional Technology Assignment: ASSURE Model-Based Lesson Design in Google Classroom
Read MoreAI Deepfake Cybersecurity Assignment: Evaluating Security Risks and Detection Techniques for Safe Digital Environments
Read MoreMGT4216E Strategic Innovation Management Assignment: Exploring Innovation Capabilities, Strategy Stages, and Leadership for Business Transformation
Read MoreEmployee Engagement & HR Strategy Assignment: Case Analysis of Tech Solutions Inc. on Turnover, D&I, Performance, and Work-Life Balance
Read MoreHigher Education Reform Assignment: Curriculum Development Strategies for a Future-Ready Malaysia
Read MoreCross-Cultural Management Assignment Report: Importance, Challenges & Strategies in Global Teams
Read More