Abstract

A study was conducted using the Dataflow diagramming to describe the information flows of the subject area "Comfortable living in an apartment building", where the construction process is presented in the form of a decomposition diagram and construction of a context diagram of the 0th level. Therefore, the DFD chart includes the following indicators of comfort: 1. Factors of comfortable living in the neighborhood. 2. Factors of comfort of the house territory. 3. Factors of home comfort. 4. Factors of apartment comfort, as well as a description of external entities (expert, buyer, construction company) and their impact on all indicators of comfort. Next, we present and describe the input and output data streams in which information is determined and transmitted from the source (process, external entities) to the receiver (external entities, processes). After constructing the context diagram, we obtained a complex system, which is further presented in the form of a hierarchy of the context diagram of the 1st level and contains a set of four subsystems and is connected by data streams and form data warehouses (environment, fuzzy set, norm), which are the prototype of the future database. As a result of research of the DFD chart of the 1st level we received: 1. The main functions are defined. 2. Described objects. 3. The main data streams are defined. 3. Creating an information system using data warehouses. The following is the 2nd level of the DFD chart and we use it for a detailed description of the information system, which provides an opportunity to consider in more detail the work of the designed system "Comfort of the neighborhood", namely the detail of the lower level process. Accordingly, each process coexists with the top-level process and I use the structural process numbers. We detail the process of the DFD chart of the 1st level 1.2, which contains 2 processes: (processing pedestrian accessibility, 1.2.2 Processing noise level) and describes the hierarchy of input and output data streams into the system. Next, we move from data warehouses to building a database model, which we present in the form of such diagrams (conceptual model, data model and physical model). The first step is to build a conceptual design, which is described using a table called "Attributes of entities and the relationship of entities). The second stage is the creation of a data model based on the created "Connection of entities", and has the following external keys: (norm, fuzzy set, linguistic variable). Next, we present a physical model where Microsoft SQL Server was processed and the data types are specified accordingly.

Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call