A Role Playing Simulation On Database Design

Good Essays
Feedback on Your Choices in Volunteer Now: A Role-Playing Simulation on Database Design

Name: Madisyn Olguin
1. Entity Choices
Points: 9 out of 9
Your choices for the entities are listed below, along with correct answers:

Your Choices

Correct Choices

Points Earned

Organizations

Volunteers

0

Volunteers

Organizations

0

VolunteerActivities

VolunteerActivities

3

Total Points

9

Well done!
2. Should activities be attributes in the Volunteers table?
Points: 5 out of 5
You selected No. Good choice! Volunteers and VolunteerActivities represent a one to many relationship, so each volunteer can have 0 to more activities. VolunteerActivities should thus be a separate table, that can be linked with a foreign key (VolunteerID) to Volunteers.
3. What would be the problems if we use volunteer names for their IDs?
Points: 20 out of 20

Correct Choices

Your Choices

Points

A. Different people might have the same name.

5

B. Sometimes people change their names.

5

C. There are too many possible names.

5

D. The same name is spelled differently in different languages.

5

Total Points

20

4. What would be the problems if we use volunteer names for their IDs?
Points: 15 out of 15

Correct Choices

Your Choices

Points

A. Social Security numbers are confidential.

5

B. Social Security numbers are too hard to remember.

5

C. Non US citizens may not have Social Security numbers.

5

Total Points

15

5. Attribute Choices
Points: 23 out of 23 + 3 Bonus
Your choices for the attributes for each table are shown below. The listing of "correct" choices is based on using all the available attributes at this stage of the simulation. Note that some attributes are added or deleted based on further discussion in the simulation. Except for the table's primary key, which should be the first attribute in each table, the order of the attributes within a table is not graded.

Volunteers-Your Choices

Volunteers-Correct

Organizations-Your Choices

Organizations-Correct

You May Also Find These Documents Helpful

  • Better Essays

    Database Design

    • 1126 Words
    • 5 Pages

    Database Design Scenario Currently a school uses a non-computerised database system to store the following information about its students: roll class, surname, first name, guardian 's name, address, student 's date of birth, gender, sport house, emergency-contact telephone number, mailing name, list of subjects offered, and subjects in which the student is enrolled. The system takes up a large amount of space, has many duplicated entries some of these with mistakes and it is time consuming…

    • 1126 Words
    • 5 Pages
    Better Essays
  • Satisfactory Essays

    Database Design

    • 149940 Words
    • 600 Pages

    Database Design Ryan K. Stephens Ronald R. Plew 800 East 96th St., Indianapolis, Indiana, 46240 USA Database Design ASSOCIATE PUBLISHER Copyright  2001 by Sams Publishing EXECUTIVE EDITOR Bradley L. Jones All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect…

    • 149940 Words
    • 600 Pages
    Satisfactory Essays
  • Good Essays

    Database Design

    • 739 Words
    • 3 Pages

    Database Design Process Database Life Cycle Key points Database design must reflect the information system of which the database is a part Information systems undergo evaluation and revision within a framework known as the Systems Development Life Cycle (SDLC) Databases also undergo evaluation and revision within a framework known as the Database Life Cycle (DBLC) There are two general design strategies exist: top-down vs. bottom-up design centralized vs. decentralized design 2…

    • 739 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Database Design

    • 418 Words
    • 2 Pages

    tables, forms, and other objects that will make up your database, it is important to take time to design your database. A good database design is the keystone to creating a database that foes what you want it to do effectively, accurately, and efficiently. The first step in designing a Microsoft Access database is to determine the purpose of the database and how it’s to be used. You need to know what information you want from the database. Form that, you can determine what subjects you need…

    • 418 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Database Design

    • 661 Words
    • 2 Pages

    Date: 20150216 Class: DBM/380 Instructor: In this essay I'm going to be discussing what database systems are and how they are used. I will de speaking on and defining database architecture. I also will be discussing how database systems are used in my everyday life and at my workstation. We will start this off with the answer to “What is a database?”. A database is a compilation of related or like pieces of data. This information or data is gathered and maintained to serve…

    • 661 Words
    • 2 Pages
    Good Essays
  • Better Essays

    Database Design

    • 1196 Words
    • 5 Pages

    Database Environment Brandon Smith DBM/380 10-8-2012 Kenneth Hoskins Database Environment “A database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of record, but also be able to access those records fast and efficiently. In addition, new information and changes should also be easy to input.” (tech-faq.com) To be useful over a long term the database should be able…

    • 1196 Words
    • 5 Pages
    Better Essays
  • Powerful Essays

    Working with Database Design

    • 2266 Words
    • 10 Pages

    Data Management Systems COPYWRITE (2013) BY Robert Ortega MIS405 – 1302A -01: Database Design Instructor: Anita Arceneaux, PhD Wednesday, May 8, 2013; Sunday May 12, 2013 Colorado Technical University Virtual Campus Three other Requirements for Database Various other aspects and needed requirements are to be introduced and implemented into Jim and Tim’s new ACCESS™2010® Relational Database Management Systems from concepts, theories, analysis, import/export, referential integrity…

    • 2266 Words
    • 10 Pages
    Powerful Essays
  • Powerful Essays

    PhyloInformatics 7: 1-66 - 2005 Relational Database Design and Implementation for Biodiversity Informatics Paul J. Morris The Academy of Natural Sciences 1900 Ben Franklin Parkway, Philadelphia, PA 19103 USA Received: 28 October 2004 - Accepted: 19 January 2005 Abstract The complexity of natural history collection information and similar information within the scope of biodiversity informatics poses significant challenges for effective long term stewardship of that information in electronic…

    • 38667 Words
    • 155 Pages
    Powerful Essays
  • Good Essays

    Physical Database Design

    • 971 Words
    • 10 Pages

    PHYSICAL DATABASE DESIGN EXAMPLES Example 1 – Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment: The database keeps track of the history of all of the teams that each player has played on and all of the players who have played on each team. The…

    • 971 Words
    • 10 Pages
    Good Essays
  • Powerful Essays

    MODULE: DATABASE DESIGN & DEVELOPMENT ASSIGNMENT TITLE: VETERINARY SURGERY DATABASE DEVELOPMENT Table of Content Task 1 Page 2 Task 2 Page 5 Task 3 Page 14 Task 4 Page 28 Task 5 Page 30 Reference Page 32 Bibliography Page 33 Task 1 Question: AIM: Draw an Entity Relationship Data Model that describes the content and structure of the data held by Petcare. Specify the cardinality ratio and participation constraint of each relationship type. Answer: I have prepared this assignment…

    • 2935 Words
    • 12 Pages
    Powerful Essays