Implementable entity-relationship diagram

Assignment Help Database Management System
Reference no: EM132100588

Description

The First Aid Brigade (FAB) is a non-profit, UN funded organization that has the unique authority, under international humanitarian law, to protect lives and provides aid to victims of wars, epidemics or natural disasters. To date, it has lead and organizes, in close cooperation with national societies in various countries, over 1800 relief assistance missions responding to large scale human crisis.

Due to the rapid expansion of the scope and size of its operations, there is an urgent need to re-look at how data is being tracked and maintained. The Director of IT services has appointed you to examine and analyze its current data needs / usages, and revamp its data model, which is to be used in its implementation of a new database a few months from now.

- The bulk of FAB's human resources comes from big-hearted volunteers from all over the world. These individuals volunteer their time to carry out the tasks of the organization. For each volunteer, their name, address, and telephone number are tracked.

Each volunteer may be assigned to several tasks during the time that they are doing volunteer work, and some tasks require many volunteers. It is possible for a volunteer to be in the system without having been assigned a task yet. It is possible to have tasks that no one has been assigned.

When a volunteer is assigned to a task, the system should track the location (i.e. Country, City, State, Address, etc) as well as the start time and end time of that assignment.

- For each task, there is a task code, task description, task type, and a task status. For example, there may be a task with:
- task code "101", with a description of "answer the help-lines," a type of "recurring," and a status of "ongoing."
OR, there could be another task with
- a task code of "102," a description of "prepare 5000 packages of basic medical supplies," a type of "packing," and a status of "open."

- For all tasks of type "packing," there is a packing list that specifies the contents of the packages. There are many different packing lists to produce different packages, such as:
- water purification packages,
- shelter/clothing packages,
- basic medical packages,
- child care packages,
- food packages, etc.

Each packing list has a packing list ID number, packing list name, and a packing list description, which describes the items that ideally go into making that type of package. Every packing task is associated with only one packing list. A packing list may not be associated with any tasks or may be associated with many tasks. Tasks that are not packing tasks are not associated with any packing list.

- Packing tasks result in the creation of packages. Each individual package of supplies that is produced by the organization is tracked. Each package is assigned an ID number. The date the package was created and total weight of the package is recorded.

A given package is associated with only one task. Some tasks (e.g., "answer the phones") will not have produced any packages, while other tasks (e.g., "prepare 5000 packages of basic medical supplies") will be associated with many packages.

- The packing list describes the ideal contents of each package, but it is not always possible to include the ideal number of each item. Therefore, the actual items included in each package should be tracked. A package can contain many different items, and a given item can be used in many different packages.

- For each item that the organization provides, there is an item ID number, item description, item value, and item quantity on hand stored in the system. Along with tracking the actual items that are placed in each package, the quantity of each item placed in the package must be tracked too.

For example, a packing list may state that basic medical packages should include 100 bandages, 4 bottles of iodine, and 4 bottles of hydrogen peroxide. However, because of the limited supply of items, a given package may include only 10 bandages, 1 bottle of iodine, and no hydrogen peroxide.

The fact that this package includes bandages and iodine needs to be recorded along with the quantity of each that is included. It is possible for the organization to have items donated that have not been included in any package yet, but every package will contain at least one item.

Task

1) You are to write all applicable business rules necessary to establish entities, relationships, optionalities, connectivities, cardinalities and constraints. If a many-to-many relationship is involved, state the business rules regarding the bridging entities after breaking down the many-to-many relationship. An example business rules format can be found in Appendix A of this document.

2) Based on these business rules, draw a fully labeled and implementable Entity-Relationship Diagram (ERD). Include all entities, relationships, optionalities, connectivities, cardinalities and constraints. You must use Crow's foot notation and MS Visio to create the ERD. A Hand-drawn ERD will NOT be accepted. A sample ERD can be found in Appendix A of this document.

3) A data dictionary is to be created to provide the details related data type, data domain, constraints, primary keys, and foreign keys. The data dictionary needs to be presented in a table format as shown Appendix B of this document.

4) Use MS ACCESS to implement the database as specified in the data dictionary. Include validation rules, input masks and indexes where appropriate. You need to input some text data in the database. Include appropriate testing data to illustrate the relationships of constraints.

5) A summary to describe the major justifications, assumptions and limitations related to your database design. For example: assumption / justifications for optionalitiy, connectivities, constraints data type and data domain; and special cases or data integrity issues that cannot be handled.

Attachment:- Instructions.rar

Verified Expert

The task of the assignment is to develop database for First Aid Bridge (FAB). From the list of requirement specification the business rules is found and made as documentation. Then an Entity Relationship Diagram is drawn using VISIO software. A Data Dictionary of all the tables in the FAB database is formed then the designed database is implemented in MS Access and the summary of the database is attached in the Excel sheet

Reference no: EM132100588

Questions Cloud

Development of infants or toddlers : What types of early learning environments foster the development of infants or toddlers? How?
Geographic region economic growth : What do think are the major factors contributing to a country's or geographic region's economic growth?
What is the total quantity produced in equilibrium : Suppose two firms are engaged in Cournot competition. The firms are identical, produce homogeneous products and have marginal costs = $0 and no fixed cost.
Knowledge and skills leading to mastery of this competency: : Knowledge and skills leading to mastery of this competency:
Implementable entity-relationship diagram : CP5633 - Database Modelling - James Cook University - write all applicable business rules necessary to establish entities, relationships, optionalities
Write a memo from josie sung to the board : Write a memo from Josie Sung to the Board explaining why it was necessary to terminate Tristan.
Business decision making process : Why can Managerial Economics be applied to any business decision making process, regardless of the industry?
Establish a wan connectivity between your local offices : You would like to establish a WAN connectivity between your local offices across town. You are considering the use of a wireless solution.
Differentiate interest income from noninterest income : Differentiate interest income from noninterest income. Which, if any, is more significant for long-term health of banks (in your opinion)? Why?

Reviews

len2100588

8/30/2018 11:27:21 PM

(II) Naming Conventions For all files, use the following naming format : Name_Stud. No._CP5633_Assnt file extension Name refers to your JCU registered name (e.g. JohnDoeAnderson) Stud. No. refers to your JCU assigned student number (e.g. 1234567) Assnl if you are submitting assignment 1, Assn2 if submitting assignment 2 etc. file extension refers to the type of file (e.g. .pdf, .doc, .xls, .mdb, .accdb) Example 1 : if your name is 'John Doe Anderson' and you are submitting a word document (for Task 1¬3 & 5), then the filename would be : JohnDoeAnderson_1234567_CP5633_Assnl.doc (Save as MS Word 97-2003 format !!) Example 2 : if your name is 'John Doe Anderson' and you are submitting a MS Access database (for Task 4), then the filename would be : JohnDoeAnderson 1234567 CP5633_Assnl.mdb (or *.accdb)

len2100588

8/30/2018 11:25:42 PM

Assignment 1 Due: Before Lesson 6 Designing the database is an iterative process; you may find yourself going back and forth between Tasks 1 and 5 to revise the design. Make sure that your final submission shows consistent design in the business rules, ERD, data dictionary, and the implementation.Submission (I) What to include MS Word / PDF file, with all the answers for Task 1-3 & 5 MS Access database file for Task 4 MS Excel Design Summary file All submissions should be in softcopy, unless otherwise instructed

len2100588

8/30/2018 11:24:22 PM

instructions

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd