Steps Of CSDP And Relational Schema In An Essay.

Steps of CSDP

The first step of this CSDP process includes translating all relevant examples of information into facts. This step starts with every familiar example of appropriate information, along with expressing these with respect to elementary facts. The second step of this CSDP process includes drawing every fact type along with applying the population check. In this step, a design procedure of conceptual schema is drawn for showing every fact type (An and Park 2018). The third step of this CSDP process includes checking for the types of entities that must be combined. In this step, it is checked if a few entity types exist that could be combined. It is also checked if a few fact types could be derived from all others with the help of arithmetic computation.

The fourth step of this CSDP process includes adding uniqueness constraints as well as checking fact types’ arity. In this step, static constraints are applied to the database’s every individual state. The fifth step of this CSDP process includes checking for every logical derivation along with adding mandatory role constraints. Every mandatory role constraint is specified, along with a check performed for seeing if a few fact types might be derived logically from all others (Brdjanin et al. 2019). The final step of this CSDP process includes adding value, exclusion, equality, subset, along with subtype constraints. This step covers several constraints like subtype, set comparison, and value.

Relational Schema

Vehicle-> Vehicle_Reg (PK), Person_Name, Cost, Registation_Date

Repairer-> Repairer_Name (PK), Vehicle_Reg (FK), Repair_Cost, Repair_Dat

References

An, J. and Park, Y.B., 2018. Methodology for automatic ontology generation using database schema information. Mobile Information Systems, 2018.

Brdjanin, D., Banjac, G., Banjac, D. and Maric, S., 2019. An experiment in model-driven conceptual database design. Software & Systems Modeling, 18(3), pp.1859-1883.