Preview

Data Basing 101

Powerful Essays
Open Document
Open Document
1926 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Data Basing 101
Conceptual Data Models for Database Design

Database Design Process

The database design process consists of a number of steps listed below. We will focus mainly on step 2, the conceptual database design, and the models used during this step.

Step 1: Requirements Collection and Analysis ▪ Prospective users are interviewed to understand and document data requirements ▪ This step results in a concise set of user requirements, which should be detailed and complete. ▪ The functional requirements should be specified, as well as the data requirements. Functional requirements consist of user operations that will be applied to the database, including retrievals and updates. ▪ Functional requirements can be documented using diagrams such as sequence diagrams, data flow diagrams, scenarios, etc.

Step 2: Conceptual Design ▪ Once the requirements are collected and analyzed, the designers go about creating the conceptual schema. ▪ Conceptual schema: concise description of data requirements of the users, and includes a detailed description of the entity types, relationships and constraints. ▪ The concepts do not include implementation details; therefore the end users easily understand them, and they can be used as a communication tool. ▪ The conceptual schema is used to ensure all user requirements are met, and they do not conflict.

Step 3: Database Implementation

▪ Many DBMS systems use an implementation data model, so the conceptual schema is transformed from the high-level data model into the implementation data model. ▪ This step is called logical design or data model mapping, which results in the implementation data model of the DBMS.

Step 4: Physical Design ▪ Internal storage structures, indexes, access paths and file organizations are specified. ▪ Application programs are designed and implemented.

Entity Relationship (ER) Model

The most popular high-level conceptual data model is the ER model. It is frequently

You May Also Find These Documents Helpful

  • Satisfactory Essays

    I think this relates to database development in a number of ways. One is how it starts, gathering information and finding the intent of the system. Next you must plan out how to set up the database, which is the vital information? What are the minor details? Then you set up your database fill in some test information insure it works properly and make needed adjustments. Finally you implement your database design where in it works properly you merely maintain and fix any errors.…

    • 317 Words
    • 2 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 331 Case Study

    • 705 Words
    • 3 Pages

    There are several basics a writer needs to write when concerning a software requirement specification. The writer needs to include these issues: functionality, external interfaces, performances, attributes and design qualities. This type of document lists everything that is required when it comes to the system that is being created. This is basically a backbone for the work that needs to be completed.…

    • 705 Words
    • 3 Pages
    Good Essays
  • Good Essays

    CMGT 400 Week 1 DQs

    • 676 Words
    • 3 Pages

    The project for CIS336 is designed to touch all aspects of the fundamental concepts of database design and logical data modeling covered during the class. The project is team centered and each team will be responsible for designing, developing, and demonstrating the functionality of a database created based on a defined set of business specifications. At the end of the session, each project team will submit the database designed by the team and demonstrate the database's ability to deliver the required information as outlined in the project specifications. All aspects of the project will be ...…

    • 676 Words
    • 3 Pages
    Good Essays
  • Good Essays

    It2640 Week 5 Appendix B

    • 632 Words
    • 3 Pages

    Prior to designing my database, I will have a clear understanding of the data. This will allow me to determine the purpose of the database. Once all information is gathered, I will divide this information into tables. Information will be properly placed into columns and I will set a primary key. Upon completion of table design, I will set the relationships between tables. I will refine my design and apply normalization rules to my design.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Nt1320 Unit 7

    • 2041 Words
    • 9 Pages

    Answer: A database is a model of how the users view their business world. This means that the users are the final judges as to what data the database should contain and how the records in that database should be related to one another. The easiest time to change the database structure is during the data modeling stage. So the user should be actively involved in the modeling process. The user review of a data model is crucial. When a database is developed, the user must carefully review the data model.…

    • 2041 Words
    • 9 Pages
    Good Essays
  • Satisfactory Essays

    Kroenke, D. M., & Auer, D. J. (2010). Database Concepts (4th ed.). Retrieved from https://ecampus.phoenix.edu/content/eBookLibrary2.…

    • 553 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Requirements Definition: This step defines project goals into specific functions and operations of the intended application. It also analyzes end-user information needs.…

    • 595 Words
    • 3 Pages
    Satisfactory 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
  • Powerful Essays

    The database plan is the first step in creating a database. It includes the following items and as appropriate each will be created using Microsoft Project, Microsoft Visio, or Microsoft Office 's Word applications:…

    • 2376 Words
    • 10 Pages
    Powerful Essays
  • Good Essays

    -A schema is the way we make sense of the world by organizing what we know into a mental framework.…

    • 510 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Is3110 Chapter 1

    • 789 Words
    • 4 Pages

    | 2. The determination of database requirements is part of a process known as systems development.…

    • 789 Words
    • 4 Pages
    Satisfactory Essays
  • Powerful Essays

    Assignment1

    • 354 Words
    • 5 Pages

    What problem would you encounter if you tried to create a listing by last name?…

    • 354 Words
    • 5 Pages
    Powerful Essays
  • Best Essays

    The selected database I have chosen for this project will be that of a veterinary medical supply database and the veterinarians who order medications from that database. I will track what is ordered and shipped to the veterinarians. This is an online veterinary supply, so, all medications will be mailed (or shipped) to the customer with a…

    • 3587 Words
    • 15 Pages
    Best Essays
  • Powerful Essays

    conceptual framework is used in research to outline possible courses of action or to present a preferred approach to a system analysis project. The framework is built from a set of concepts linked to a planned or existing system of methods, behaviors, functions, relationships, and objects. A conceptual framework might, in computing terms, be thought of as a relational model.…

    • 7998 Words
    • 32 Pages
    Powerful Essays