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

  • Satisfactory Essays

    Nt1330 Unit 5 Exercise 1

    • 595 Words
    • 3 Pages

    • Create an activity diagram and a set of use case descriptions for an online university registration system. • The system should enable the staff of each academic department to examine the courses offered by their department, add and remove courses, and change the information about them (e.g., the maximum number of students permitted).…

    • 595 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Week 1 SOW 1

    • 452 Words
    • 2 Pages

    Building the Physical Database: The data model will be translated into the Relational Database Management system of choice. All Tables and Columns with specific data types will be created and will include Relational and other constraints.…

    • 452 Words
    • 2 Pages
    Good 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
  • Satisfactory Essays

    4. Building the physical database: The database model will be constructed into the actual database program.…

    • 358 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Business Data Model

    • 3130 Words
    • 13 Pages

    What is the probability that a randomly selected order will require between two and three minutes?…

    • 3130 Words
    • 13 Pages
    Good Essays
  • 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
  • Satisfactory Essays

    DBM 380 Syllabus

    • 623 Words
    • 4 Pages

    This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration.…

    • 623 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    In a database model, each object that we want to track in the database is known as entitiy. For example, in a college database there might be several entities which is known as set of similar objects. Some of the entities in college database are:…

    • 688 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Dbm380 Course Syllabus

    • 2296 Words
    • 10 Pages

    Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum.…

    • 2296 Words
    • 10 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Doctor

    • 2483 Words
    • 9 Pages

    Identify the different types of entities, attributes, keys and relationships you will want to consider when designing the database.…

    • 2483 Words
    • 9 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
  • Satisfactory Essays

    Databases are used for record keeping and tracking of information institutions like colleges or organizations (Coronel & Morris, 2015). In this case, the database will be used to keep track of the students・attendance, performance and the courses they are supposed to be taking. This will help the college analyze how the students perform and which classes they least or most attend. The database will also help the college keep track of all the subjects which the student is taking or is expected to take in during the course. Instructors will also be part of the database. The database will track their performance in various subjects and their attendance in each class. The database will be upgraded at the beginning of every subject where each student will confirm their attendance for the particular subject and whether the instructor is in class as well. After an examination, all the students・performance will be…

    • 590 Words
    • 3 Pages
    Satisfactory 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

    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