CIS108-6 Data Modelling Assignment Sample
Module code and Title: CIS108-6 Data Modelling Assignment Sample
Introduction
A framework which helps in outlining systems for data storage, creation, disposal, as well as maintenance of data is known as a model of data governance. As compared to a singular model of data for the governance used by each of the company, which is also observed here in this scenario of the sports club where the use case diagram and the entity relationship diagram is also used and designed here properly, basically a database solution for a record system of a sports club is required to be designed here. As a database designer a record system of a new membership which is capable of storing members information, staff of a sports club as well as bookings of sports activity is also designed as well as implemented here. Each member of a sports club which is designed here using use-case diagram and entity-relationship diagram has a unique reference number of a member, as well as storing of the surname, firstname, telephone number, address, date of birth and email address as well as any of the medical conditions which are there. Apart from this, all the other attributes of each of the entities are also shown properly and discussed as well which helps in the completion of this proposed work. Enterprise data management also enables the execution and enforcement of various policies, processes as well as functions which will help in the proper management and handling of data. A method used for specifying as well as help in the analysis of data requirements needed for supporting the company processes within the information systems in the company; where the data modeling method involves data modelers who are very professional as well as working very close with the company stakeholders, as well is known as data modeling. This whole area is going to be covered as well as discussed with the given scenario of the sports club here.
Analysis
Design
The design which is going to be displayed here is based on the Use-case diagram and the Entity-relationship diagram which is required for designing of the database and this whole topic of the proposed work on data modeling, management and governance. This is also helpful in the giving of shape to the proposed work on data modeling clearly as well as also showing the clear design aspects which are needed here and all of the features which are mentioned here are clearly shown as well as discussed here. An ER diagram is important here in order to design the data models of the database. To design a new data model, ER diagram preparation here helps with capturing which is essential as well as the document system requirements.
The representation is generally of the domain of data which consists of relationships as well as the entities which are needed for the relationships. An entity can be tangible like a school or student. Physical object, or a reply to the concept of transaction. This design is essential to make the clear concept of the topic very clear and understandable in the required work which is given here (Abbady et al. 2019). The use case diagram and the ERD design is going to be discussed here as well which is shown here in a proper manner which helps in the database implementation. Here, in the present case scenario of the sports club, the database implementation of the sports club is shown here, which is required for discussion and also for the understanding of the given work (Abraham et al. 2019). This diagram holds significance as it displays the attributes, entities as well as other relations properly and clearly here as well as this also assists in properly understanding the work and also assists in giving a proper structure and shape to the given work which is going to be done in the required scenario of the sports club. The entity relationship diagram uses a set of symbols which is specified, such as rectangles, connecting lines, diamonds, as well as ovals which also displays here in this work too properly and this is also required to depict the relationships, interconnections, attributes as well as their respective entities.
They help to mirror the grammatical structure, with relationships as entities and verbs and nouns for the connections (Adeabah et al. 2018). This is also required here as the management, data modeling as well as the governance is clearly displayed here in this design part of the analysis section with the focus and the intention of projecting the work clearly and the attributes and their respective entities are properly shown here and the code snips as well as the output snips which are properly displayed below is clearly shown here and all the entities and their respective aspects and attributes are clearly displayed here and helps to identify the relations between the attributes and their respective columns.
The diagram of the use-case has also represented the key actors and the use-cases in the system and displaying clearly which has the access of the use cases of each actor as well as help to define the values clearly. An ER model which is designed here helps in outlining the database structure required for implementing the new record system of a sports club of the “Sports Club Management System” database.
A solution of the database which is going to be implemented as well as designed here as well as all the values which are required to be inserted here and apart from this, this is also vital here to check if the design is precise and accurate or not (Al-Badi et al. 2018). All the attributes and the entities are also clearly designed here with a proper relation which not only helps in providing a proper idea but also helps in the proper identification of the values of the database to be designed here (Al-Ruithe et al. 2018). The use case diagram of the UML and the designing of the ER model which needs to be created here is properly shown here which has helped in the proper and clear understanding of the given proposed work.
The design of the database which is going to be implemented here in the form of use-case diagram and the ER diagram is displayed here properly which helps in showing all the necessary values clearly that needs to be inserted here which will help in the proper identification of the entities and the proper attributes along with the relations which needs to be clearly shown here based on the given work.
Use-case diagram
The use case diagram that needs to be designed here which is basically related to the management system of a sports club database is displayed below and explained or described as well.
The above diagram is the use-case diagram of a sports club management system database is displayed above where the actors like Non-employee, employee, client, administrator and the paying agent is shown here where it is shown or displayed that the three attributes which are payment, equipment and modify trainer uses the record attribute to show the record of the trainer here (Benkhelifa et al. 2019). Apart from this the other attributes which are shown here are signup, sign in, test equipment, see or view information, payment, equipment, modify trainer and handle information where the information of the administrator is handled by the handle information attribute here and the payment which is received by the paying agent is also shown here (Bennett et al. 2019). The client details are required by the sign in , the equipment and the test equipment attribute here and the employee can opt for changing trainer which is used by the modify trainer attribute here and the employee who is not registered in the sporting club or a non-employee registers through the signup attribute is also clearly shown here.
The use-case actor helps in identifying the role of the user which helps in the interaction within the proposed system which is required to be modeled by the user. The user can be a machine, a company, any other external system, or a human user (Castro et al. 2021). In models of UML, stereotyped components are those subsystems which represent independent, behavioral units of a system (Glaser and Schroter, 2020). Subsystems can be useful in class, component, and also the diagrams of the use-case to represent components in a broad scale in a particular system which needs to be modeled. In the case of UML, a link or connection between the elements of the mode is known as a relationship. A relationship of a UML is a kind of element model which involves semantics by specifying or defining the structure and behavior between the model elements.
The addition of value by the use cases since they assist in explaining the process of behavior of a system as well as in the process, they also assist in brainstorming about what can go wrong as well (Goul et al. 2020). They provide a list of goals as well as in this list is utilized to establish the cost and complexity of the system with respect to the above required scenario of the sporting club management database.
Design process is relatively simpler here using draw.io by involving the attributes and the actors as well as displaying them as proper relations which are done in a relatively easier method. The decisions of taking five actors and their respective attributes with a systematic, sequential and clear relation between them is shown here clearly and properly (Harrison et al. 2019). Initially, few issues or challenges were faced here in this step of use-case diagram while designing or drawing the diagram here but later on no such issues or challenges were faced while designing or drawing this diagram of a use-case here.
Entity relationship diagram
The model diagram of the entity-relationship on sports club management systems database is displayed below here as well as discussed properly and accordingly as well.
The above diagram is the diagram of the entity-relationship on the sporting club management systems database where the entities namely Employee, Role, Period and Trainer and their respective attributes are displayed here above (Jameel et al. 2019). The employee entity has attributes which are Employee_id where Employee_id is the primary key, Employee_name, Emp_Address, Emp_Phone, the role entity has attributes which are Role_id where Role_id is the primary key, Desc, Role_name, the period entity has attributes which are Period_desc and Period_id where period_id is the primary key and the trainer entity has attributes which are Trainer_id where Trainer_id is the primary key, T_name, T_ph & T_age (Janssen et al. 2020). The role has a relation of contains with period and has a 1:N relation, the trainer has a relation of handles with role and has a 1:1 relation and the employee has a relation of register with role and has a N:M relation here (Katzenbach and Ulbricht, 2019). This model of ERD has also outlined the database structure as displayed in the above diagram which is needed for implementing the new record system of a sporting club here in which this “Sports Club Record System” database is formed or created as well as also implemented sequentially as well (Li et al. 2019). ER Diagram is very much essential for giving it a clear and an appropriate structure as well as shape to the respective project and its respective entities as well as the attributes is properly shown and labeled also clearly as well as explained in order to provide a neat and clean look to this diagram of the proposed work (Meijer, 2018). The relations which are provided above helps in realizing the work clarity and also displays how much they are interconnected as well as interrelated with each other.
The ER diagram is important for modeling the data which needs to be stored in the database as displayed in the above diagram with respect to the scenario of a sporting club which is required here (Micheli et al. 2020). This is the actual design upon which a database needs to be built. ER diagrams help in specifying or defining which data needs to be stored, their entities as well as the attributes. They also help in displaying or showing the process of entities and their relation with all the other entities which are there. Another advantage of diagrams of ER with respect to the database of a sports club management system scenario is that these entities assist in the data representation and identification which is displayed here or shown here in a clear graphical manner (Moreno-Gómez et al. 2018). This makes it easier for the folks related with the business for understanding as well as analyzing the data and their entities as well as their respective attributes properly and easily. Some of the tables with respective entities as well as their attributes as well as lines which represent the relationships between the tables which are given here are displayed in the ER diagram which is given above. ER diagram is required for gathering requirements, promoting interaction and communication, modifying and maintaining a database. Diagrams of entity relationships help in viewing the respective entities which are used here in this ER diagram design as in real world or as in real life. This is also important to assist the database developer, database logic, as well as documentation tools.
The design process which is used here in the diagram above is relatively tougher as well as complex on designing it in draw.io as well as which involves all the attributes, entities, as well as relations between them respectively. The decisions are accepted by choosing four of the entities with their respective attributes and a relation of the database solution is utilized here. The relations types like N:M, 1:1, & 1:N are utilized here and a primary key is a unique one which is required for each of the necessary attributes for the five respective entities which are shown here for indicating a stable relationship between each of them (Muda et al. 2018). Similar to the diagram of the use-case while designing or drawing this ER diagram firstly few challenges or issues were actually faced but afterwards no challenges or issues were faced here while drawing or designing this created ER diagram.
SQL statements of creating table
The sporting table create table statement is shown or displayed here using SQL below which its structure or proper framework of the table is displayed or shown below and shown as well as discussed properly here.
The above create table snip shows all the attributes or columns which are specified with their respective data types as well which are ReferenceNo where the ReferenceNo is the primary key which should be used here, FirstName, LastName, Address, MobileNo, EmailID, BirthDate & the medical conditions where the ReferenceNo, MobileNo & the BirthDate has integer data type and FirstName, LastName, Address, EmailID, Medical Conditions has varchar data type and no null values are there which should be stored here. Table creation is essential for giving proper shape and structure to the table as well as the database being created or formed based on its given table creation (Nost, 2022). This sporting club table also consists of the required entities and their attributes, the reference number of a member which is unique here and a primary key constraint as well (Orazalin, 2020). This structure of the create table is created on Xampp and provides the database with a clear look and assists in the understanding of the work which is to be done here properly.
Tabbles are needed for storing the data and its respective entities as well as their attributes in the database. Tables are named uniquely within a specified schema as well as the database. Each and every table which is used here contains more than a single record or column. Each of these columns has a data type which is an associated one which specifies the data type to be stored by it properly (Paik et al. 2019). E.g., numbers, strings, or data which is a temporal one. To create the sports table as shown here in the above snip, specifying the name of the database first is vital here where the table needs to be created.
The database name should also be the existing database name which is also used here in this section of the table creation according to the given scenario of the sporting club. If that is not specified here, the database name will default itself to the current database. Secondly, defining the schema is required here and also done here in which the new sporting table belongs. Thirdly, the new table name is required to be specified here (Pels et al. 2018). Fourthly, each table needs to have an unique primary key which is given in the above scenario of the sporting club which is also used here too in this snip of the sporting table creation of the database which consists of a single or more than a single column.
The design process which is used here for creating table here is the syntax of create table statement is used for the creation of the table whose structure is shown above as specified in the given scenario of the sporting table and also entering its attributes as a proper area of tasking which is provided here in the given scenario of the database design of the sporting club management system (Pirzada, 2020). The decisions which could be taken here are introduction of table statements in a proper and an efficient way with their attributes which are a respective one as well. Running or execution issue or challenge was initially faced while running or executing this SQL query of create table but afterwards no such challenge or issue was raised in the proper execution of the table creation by using the SQL statement of create table whose proper structure is displayed in the above snip as well as make them execute systematically and properly as well.
SQL queries
The coding analysis which is done here using MySQL is performed here after which it is run here or executed as well as its discussion is properly done here based on which this “Data Modeling, Management and Governance” topic is displayed here in the actual form of snips. The queries are discussed through the above snips as to how it has executed or run here properly so that the database which is created here is properly as well as sequentially performed here.
The selection of all of the values of the sporting club table is shown here which means that the values are inserted as records and it will show all the records of this sporting club and it’s revealed through the above snip. The analysis of this script snippet or query generates an idea of what will be the value which should be executed here or the record here by displaying the query or the above statement (Ramadhan et al. 2021). All the values which are required in the database need to be stored here and can be shown or displayed accordingly, which helps in making the viewing of the database proper from this sporting club table.
This also makes the database look very clear and appropriate so that all of them becomes accurate or correct with respect to the value which is shown or displayed here and helps in making the viewing of the database by selecting all the values or the records of the sporting club table and all of them can be shown apart from the two records or values which is required to be stored here in which this is needed for selecting all the values or few values of the sporting table here and every values which should be added here needs to be clearly evaluated and executed here in order to give the database a clear and a solid shape and structure. The values which should be introduced here as the records are required to be given here for making the code look simpler and easier and all the values or the records is added here for generating the accurate output or display that should be added here for the actual verification and the clearance of the proposed work and this proves to be an essential or important part of the database modeling, management and governance of the data which should be added or included here.
This snip of the sporting table shows the values or records that should be inserted here and also associated with the respective columns or the attributes here.This is properly supplied here with the required attributes with the necessary entities (Safiullah and Shamsuddin, 2018). This is essential regarding knowing the inserted number of records and, apart from this, other records which could be entered here as well (Schachtner, 2022). All of the attributes or columns and their respective records or values are entered correctly or included in the database table for giving the database a proper and a solid structure as well as it will also help in giving a proper and an actual perspective of whether the values are properly executed here or not in this work which is proposed here (Sheikh et al. 2018). The values or records of the sporting club that are inserted or added here is given here based on the attributes or columns and help in giving the actual structure and shape to the database which should be added or included here and help in making the database clear and an appropriate one which help in giving the database properly and systematically here.
These records or values which needs to be inserted here based on the sporting table helps in giving a proper and a solid structure which are needed here for its insertion or addition which is required to be given here helps in giving the shape and structure to the database which helps in the insertion of the records or the values which are helpful here for giving it a solid look and help in giving the proper database an accurate and a precise look which is a completed one with respect to giving the proper database an appropriate look which also helps the database look simpler and easy to access by inserting the values or the records as required in the given scenario of the sporting club here which will create and display the database here.
Here, two values or records are inserted in this table “Sporting Club” which is presented in the database form of a record of the database where both the values or records are stored here which is based on the actual sporting club scenario which is given and shown here as well as the requirements which are needed here (Turluev and Hadjieva, 2021).
This output is needed for the implementation and testing of the database and also a clear idea is also given or provided here about the things which are necessary that are achieved here and also assist in gaining stability as well as the output of the two values or records in the above sporting club table as well as this also this values are stored in the database. In this project,to implement the values which are actually required to be stored in the database. Those values are very much important for storing the data in the database. Those values provide actual stability as well as solidarity of the database, and those values are inserted where the actual development is needed for the work purposes. In this table staff as well as sports club staff members is also checked as well as it is help to update the all employee data as well as update the sports center staff for record the attendance of the class for teaching the purpose as well as each and every member has also helping in view to their weekly as well as monthly as well as daily bookings of activity which are provides on the given structure (Wiedenhöft et al. 2020).The values which should be implemented here for the records are very much important for give the database a proper structure as well as it is very much clear. Two records as well as values are entered as well as added here for display as well as shown here clearly with respect to the above values. The correct form of execution as well as running the value is essential here for the values in order to give the database look solid as well as clear. This also assures that the records in multiple numbers can be added or entered here where two values or records are displayed in the above output snip of the work which is proposed here as well as this systematically and clearly shows all the records or values which needs to be displayed as the output of the work which is proposed here. Apart from the output which is shown in the above output snip of two records or values, many other records can be entered or added here in this table to provide a proper database with a proper and solid look and structure. Members of the normal staff and staff of the sporting club have logged in or checked in as well as updated their personal details which should be required or needed here, and apart from this sports center staff is also there for recording the actual class attendance for the purposes of teaching, and each member also helps in viewing their daily or weekly activity bookings which are provided here based on the above scenario which is given here properly. The values that need to be inserted here as the display or output is very essential for this actual data transformation and this also helps in providing the database a clear and a solid look and provides a proper database structure. The records which have been inserted here are very essential for providing the database with a proper and complete structure. Both the records or values which are added or entered here are shown or displayed here properly with respect to the given values or records. The correct form of running or execution of the necessary values are essential here in order to give the database a solid and a clear look and also assures that multiple values or records can be added or entered here in which both the values or records are displayed in the above snip of the coding of this proposed work as well as this systematically and clearly displays all the records or values which needs to be given here as the output of this proposed work.
Queries of SQL are used for executing statements in the database table so that no mistake or any issue as such arises while making the execution of queries proper and smooth. Accurate SQL queries are required to be supplied here so that during the execution of the database table no issue or problem arises. All the queries of SQL is required to be given in a proper format which is based on the actual syntax of each of the columns or attributes which are vital is required or needed here otherwise the chances of the probable errors will be there so that is to be kept in mind and this also assures that there will be no duplication or redundancy of data.
The design process which is used here is the process of selecting the query statement by the select statement, the statement for insertion which is the insert statement through which the actual output needs to be shown or displayed. The design process also involves certain other features and aspects which are needed to be introduced here. The decisions which are taken here are the selection of accurate data which has been given in the scenario through which the records need to be displayed in the table of the database. In a similar manner like the SQL statement of create table above firstly, the execution or running issue or the challenge was actually there while executing or running the scripts or SQL queries but afterwards no such challenge or issue was faced as such during the execution or running of the three queries or the SQL scripts which was needed here in the actual scenario of the database system of the sports club in the given proposed work.
Conclusion
This report details the database for the management system as well as the diagram. It is the primary task to design a database for the sports club. At first of this report a short introduction is given which conveys the information of data model as well as data management process can be stored as well as it helps to manage a large amount of data. Here it can be shown that there are differences such as admin,customer as well as designers. The tasks of all these users are defined in the help of a use case diagram. The next object of the report is to develop an entity relationship diagram which represents different cases that are present in the database. The entity relationship diagram is also modified using the same tool that is used for creating the use case diagram.The boxes of an entity relationship diagram represent the classes as well as the oval diagram represents the attributes of the classes. The last task of this report was to develop an SQL table. Using XAMPP software as well as it is used to create the SQL table. First, a new database is created in the software as well as then the required table is created here. Then the columns of the table are made following the given case study. The type of all the fields of the table that are mentioned in the table. In the last part the table is populated with values. Some SQL queries were aso executed to print the values. These tasks are analyzed as well as discussed in detail in this report. This report can be stated that, database management system is a complex task as well as it is different pieces of information about the system must be jotting in order to create a database based on the system.
Reference List
Journals
Adeabah, D., Gyeke-Dako, A. and Andoh, C., 2018. Board gender diversity, corporate governance and bank efficiency in Ghana: a two stage data envelope analysis (DEA) approach. Corporate Governance: The International Journal of Business in Society.
Al-Badi, A., Tarhini, A. and Khan, A.I., 2018. Exploring big data governance frameworks. Procedia computer science, 141, pp.271-277.
Al-Ruithe, M., Benkhelifa, E. and Hameed, K., 2018. Data governance taxonomy: Cloud versus non-cloud. Sustainability, 10(1), p.95.
Al-Ruithe, M., Benkhelifa, E. and Hameed, K., 2019. A systematic literature review of data governance and cloud data governance. Personal and Ubiquitous Computing, 23(5), pp.839-859.
Bennett, N.J., Di Franco, A., Calò, A., Nethery, E., Niccolini, F., Milazzo, M. and Guidetti, P., 2019. Local support for conservation is associated with perceptions of good governance, social impacts, and ecological effectiveness. Conservation letters, 12(4), p.e12640.
Castro, A., Villagrá, V.A., García, P., Rivera, D. and Toledo, D., 2021. An Ontological-Based Model to Data Governance for Big Data. IEEE Access, 9, pp.109943-109959.
Glaser, M. and Schroter, B., 2020. Generating knowledge on networks in environmental governance. Human Ecology Review, 26(2), pp.3-16.
Goul, M., Sidorova, A. and Saltz, J., 2020. Introduction to the Minitrack on artificial intelligence and big data analytics management, governance, and compliance.
Harrison, T., F. Luna-Reyes, L., Pardo, T., De Paula, N., Najafabadi, M. and Palmer, J., 2019, June. The data firehose and AI in government: Why data management is a key to value and ethics. In Proceedings of the 20th Annual International Conference on Digital Government Research (pp. 171-176).
Jameel, A., Asif, M. and Hussain, A., 2019. Good governance and public trust: Assessing the mediating effect of E-government in Pakistan. Lex Localis, 17(2), pp.299-320.
Janssen, M., Brous, P., Estevez, E., Barbosa, L.S. and Janowski, T., 2020. Data governance: Organizing data for trustworthy Artificial Intelligence. Government Information Quarterly, 37(3), p.101493.
Katzenbach, C. and Ulbricht, L., 2019. Algorithmic governance. Internet Policy Review, 8(4), pp.1-18.
Li, Q., Lan, L., Zeng, N., You, L., Yin, J., Zhou, X. and Meng, Q., 2019. A framework for big data governance to advance RHINs: a case study of China. IEEE Access, 7, pp.50330-50338.
Meijer, A., 2018. Datapolis: A public governance perspective on “smart cities”. Perspectives on Public Management and Governance, 1(3), pp.195-206.
Micheli, M., Ponti, M., Craglia, M. and Berti Suman, A., 2020. Emerging models of data governance in the age of datafication. Big Data & Society, 7(2), p.2053951720948087.
Moreno-Gómez, J., Lafuente, E. and Vaillant, Y., 2018. Gender diversity in the board, women’s leadership and business performance. Gender in Management: An International Journal.
Muda, I., Maulana, W., Sakti Siregar, H. and Indra, N., 2018. The analysis of effects of good corporate governance on earnings management in Indonesia with panel data approach. Iranian Economic Review, 22(2), pp.599-625.
Nost, E., 2022. Infrastructuring “data-driven” environmental governance in Louisiana’s coastal restoration plan. Environment and Planning E: Nature and Space, 5(1), pp.104-124.
Orazalin, N., 2020. Board gender diversity, corporate governance, and earnings management: Evidence from an emerging market. Gender in Management: An International Journal.
Paik, H.Y., Xu, X., Bandara, H.D., Lee, S.U. and Lo, S.K., 2019. Analysis of data management in blockchain-based systems: From architecture to governance. Ieee Access, 7, pp.186091-186107.
Pels, P., Boog, I., Henrike Florusbosch, J., Kripe, Z., Minter, T., Postma, M., Sleeboom‐Faulkner, M., Simpson, B., Dilger, H., Schönhuth, M. and von Poser, A., 2018. Data management in anthropology: the next phase in ethics governance?. Social Anthropology, 26(3), pp.391-413.
Pirzada, K., 2020. RISK MANAGEMENT, SUSTAINABLE GOVERNANCE IMPACT ON CORPORATE PERFORMANCE. Journal of Security & Sustainability Issues, 9(3).
Ramadhan, A.F., Jaafar, N.I. and Tajudeen, F.P., 2021. DATA GOVERNANCE AND ITS SCIENTIFIC OUTLOOK IN INDONESIA: A LITERATURE REVIEW. Journal of Management Information and Decision Sciences, 24(3), pp.1-10.
Safiullah, M. and Shamsuddin, A., 2018. Risk in Islamic banking and corporate governance. Pacific-Basin Finance Journal, 47, pp.129-149.
Schachtner, C., 2022. Wise Governance–Elements of the digital strategies of municipalities. ORAȘE INTELIGENTE ȘI DEZVOLTARE REGIONALĂ, 6(02), pp.23-29.
Sheikh, M.F., Shah, S.Z.A. and Akbar, S., 2018. Firm performance, corporate governance and executive compensation in Pakistan. Applied economics, 50(18), pp.2012-2027.
Turluev, R. and Hadjieva, L., 2021. Artificial Intelligence in Corporate Governance Systems. In SHS Web of Conferences (Vol. 93, p. 03015). EDP Sciences.
Wiedenhöft, G.C., Luciano, E.M. and Pereira, G.V., 2020. Information technology governance institutionalization and the behavior of individuals in the context of public organizations. Information Systems Frontiers, 22(6), pp.1487-1504.
Know more about UniqueSubmission’s other writing services:
