Preview

Data Models

Satisfactory Essays
Open Document
Open Document
521 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Data Models
Data Models Consider a simple student registration. Specifically we want to support the tasks of students registering for or withdrawing from a class. To do this, the system will need to record data about what entities? What specific data about the entities will need to be stored? What is the cardinality between students and courses? Diagram the data model. While, considering a student class registration system for registering or withdrawing a system must have the capability to record data in regards to certain entitites. Specifically, student data, system data, service data, service type, class type, and class information all must be stored on the system. Student data such as age, contact information, student major data all must be recorded. System data such as tuition payment method, and registration method must also be recorded. Service data such as the data classes begin, and the number of classes must also be recorded. Service type such as tutoring, computer lab information, extra curricular pricing, and materials for the class must also be recorded. Class state, such as size of the class, and whether the class is properly manned is also important information that must be recorded. Finally, class data such as the type of class, the instructor of the course, and concentration information is also important. A connector has cardinality, which means how many connections X has to Y, or Y has to X. In this example, the student has multiple connections to the class, and the class has multiple connections to the student.

Example of a data model for a Class registration System:
Figure 1-1

[pic]

The local library wants to update its book check process. To do this, the system will need to record data about what entities? What specific data about the entities will need to be stored? Diagram the data model.

A data model, “specifies the data that is to be stored in the system and the relationships between the data”



References: Soren Lausesen. (2002). Software Requirements, Styles and Techniques. Great Britain: Addison-Wesley

You May Also Find These Documents Helpful

  • Good Essays

    Entities are defined as a person, place, thing, or event in which data is collected and stored. Each entity is a unique and distinct object that may be a physical or abstract object within the real world (Coronel, Morris, & Rob, pg. 34). Entities of a database for a college that needs to keep track of students and courses would be students, professors, courses, classes, room, and enrollment status. These entities will be used to format the data within the database so that each student and course is accounted for. Attributes are characteristics of an entity, such as a name, phone number, or address (Coronel, Morris, & Rob, pg. 34). Attributes for the college database would include student first and last name, student phone number, student address, student identification number, student grade point average, student course major, and student classes to describe the student entity. The professor entity would be described by professor…

    • 906 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Er Modleing

    • 21230 Words
    • 85 Pages

    real-world objects and the database model that is implemented in the computer. Therefore, the importance of data-modeling details, expressed graphically through entity relationship diagrams (ERDs), cannot be overstated. Most of the basic concepts and definitions used in the entity relationship model (ERM) were introduced in Chapter 2, Data Models. For example, the basic components of entities and relationships and their representation should now be familiar to you. This chapter goes much deeper and further, analyzing the graphic depiction of relationships among the entities and showing how those depictions help you summarize the wealth of data required to implement a successful design. Finally, the chapter illustrates how conflicting goals can be a challenge in database design, possibly requiring you to make design compromises.…

    • 21230 Words
    • 85 Pages
    Good Essays
  • Satisfactory Essays

    Cipd Assignment 1 Dep

    • 812 Words
    • 4 Pages

    • Maintaining L&D data in a system. In order to maintain and design all data in usefully.…

    • 812 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Enrollment is the process of entering and verifying data of student to register on a particular school. Different interrelated processes build up enrollment procedures called Enrollment System (ES). ES are used particularly in recording and retrieving student’s information. Tracking student information is also one of the features of ES, in which the school can trace the standing of a student. Verifying payments was also added to update or browse students’ billings.…

    • 6512 Words
    • 27 Pages
    Powerful Essays
  • Powerful Essays

    Brd Templte

    • 5442 Words
    • 22 Pages

    Data Requirements 15 4.1. Data Architecture 15 4.1.1. Domain Class Diagram 16 4.1.2. Entity Relationship Diagram 16 4.2. Data Volumes 17 4.3.…

    • 5442 Words
    • 22 Pages
    Powerful Essays
  • Good Essays

    Cis 515week 3

    • 1024 Words
    • 4 Pages

    In order to properly indentify the university’s requirements and create an accurate proposal, the first step should be to create and Entity Relationship Model (ERM). The ERM will provide a visual representation of the data structure of the data stores and show the relationships between the data. The following diagram displays the ERM:…

    • 1024 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    ssssss

    • 972 Words
    • 7 Pages

    As analyzed before, the major problem faced by the company is because the old system’s…

    • 972 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    Question Bank

    • 556 Words
    • 3 Pages

    UNIT - 1 1. Explain advantages of database over file system 2. Describe Three Level Architecture. 3. Explain Data Independence with its Types and Examples. 4. Definition : 1) Assertion 2) Authorization 5. Explain Object-Oriented Data Model 6. Explain Semi-Structured Data Model. 7. Explain Database System Architecture. 8. Explain Duties of Database Administrator. UNIT - 2 9. What are the steps involved in designing a database application? Explain with an example. 10. What is E-R Model? What is purpose of E-R Model? 11. Explain Entity and Entity Sets with Examples. 12. Explain Relation and Relationship Sets with Examples. 13. What is Attributes? Explain types of Attributes with Example 14. What Cardinalities in Database System? Explain types of cardinalities. 15. Explain Superkey, Candidate Key and Primary key with proper example. 16. Explain Participation Constraint with Example. 17. Explain Weak Entity Set. 18. Explain E-R diagram components. 19. Explain Subtype and Supertype with Example. 20. Explain Generalization and Specialization with Example. 21. Explain Aggregation Relationship with Example.  NOTE: IN UNIT – 2 NOT INCLUDE E-R DIAGRAM QUESTION.…

    • 556 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Enterprise Data Model

    • 5539 Words
    • 23 Pages

    An Enterprise Data Model is an integrated view of the data produced and consumed across an entire organization. It incorporates an appropriate industry perspective. An Enterprise Data Model (EDM) represents a single integrated definition of data, unbiased of any system or application. It is independent of "how" the data is physically sourced, stored, processed or accessed. The model unites, formalizes and represents the things important to an organization, as well as the rules governing them.…

    • 5539 Words
    • 23 Pages
    Good Essays
  • Good Essays

    Database Final Exam

    • 1376 Words
    • 6 Pages

    1. (Chapter 06): Describe a relational DBMS (RDBMS), its underlying data model, data storage structures, and manner of establishing data relationships:…

    • 1376 Words
    • 6 Pages
    Good Essays
  • Good Essays

    Module: Database Systems Chapter 1 The Entity Relationship Modelling The Concepts of Entity Relationship Model 1.1 Entity Types…

    • 465 Words
    • 2 Pages
    Good Essays
  • Satisfactory Essays

    RDBMS

    • 622 Words
    • 3 Pages

    Each row in the Students relation is a record that describes a student. Every row follows the schema of the Student relation and schema can therefore be regarded as a template for describing a student.…

    • 622 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    MIS IT

    • 2947 Words
    • 9 Pages

    A physical data model represents the actual structure of a database—tables and columns, or the messages sent between computer processes. Here the entity types usually represent tables, and the relationship type lines represent the foreign keys between tables. The data model’s structure will often be tuned to the particular needs of the processes that operate on the data to ensure adequate performance. It will typically include:…

    • 2947 Words
    • 9 Pages
    Powerful Essays
  • Powerful Essays

    database schema from the top to the bottom in the process of a database design. This Section examines the entity-relationship model and the object-oriented model as representatives of conceptual modeling. The entity-relationship model is widely used and the object-oriented model is gaining more acceptance for non-traditional databases.…

    • 4703 Words
    • 19 Pages
    Powerful Essays
  • Satisfactory Essays

    • Collection of interrelated data • Set of programs to access the data • DBMS contains information about a particular enterprise • DBMS provides an environment that it both convenient and efficient to use…

    • 1023 Words
    • 5 Pages
    Satisfactory Essays