Develop ERD and the relational schema
- Develop ERD and the relational schema
- Define entities and relationships. Provide the business rules of the ERD.
- Include the final ERD.
- Convert the ERD to a relational schema. Normalize all tables to third normal form.
- Include the relational schema. (This is not DDL.)
For: Hampton Roads Helping Hands
Hampton Roads Helping Hands is a nonprofit organization that provides assistance to people and families who need basic assistance to survive. We provide employment, food, housing, and utilities support to those in need.
Our organization has grown over the last 25 years from a staff of 3 people and 20 volunteers to a staff of 10 people and 100 volunteers. Our contributions have grown from $100,000 from 40 contributors in our first year to an estimated $2,000,000 from 400 contributors per year. Our organization is currently working from two locations; one location is located in Newport News, VA and the other is located in Virginia Beach, VA both are within the Hampton Roads area.
The problem is that we do not currently have a proper distributed database that can handle of the information and data transactions that comes through our offices on a daily basis. We need to start with a way to track contact information for staff members, volunteers, contributors, and donations so that those resources can be managed and utilized to the maximum effect.
Data will be distributed across the two locations with the master database located in Newport News while the slave database will be distributed from the location in Virginia Beach.
Data information that needs to be collected includes information about:
- Staff contact information
- Volunteer contact information
- Contributor contact information
- Donation information
- Monthly Expenses
The new Helping Hands distributed database should be up and running no later than April 15, 2018.
|Project Work Plan||2/11/18|
|Logical Model (ERD) and Relational Schema||2/18/18|
|Data Distribution Plan||2/25/18|
|Distribution Plan Implementation||3/4/18|
|Create DDL and Populate the Tables||3/18/18|
|Views and Queries||3/25/18|
|Final Report and Final Versions of Scripts||4/15/18|
We will be using the following software to complete our goal of having an efficient and accurate distributed database:
- Microsoft Office 365 that includes
- Microsoft Word 2016
- Microsoft Excel 2016
- PowerPoint 2016
- Outlook 2016
- Oracle SQL Developer Version 17.3
- Oracle SQL Developer Date Modeler Version 17.3
Each location will have at a minimum the following hardware component requirements:
|Physical Memory (RAM)||8 GB|
|Virtual Memory||Double the amount of physical memory (RAM)|
|Disk Space||1 TB|
|Processor||Intel i3 quad core|
|SVGA Video Monitor with HDMI input||16 million colors|
Steve Ballard and Maria Cavenaghi will manage the master database at the Newport News office, while Gary Chaffin and Lionel Bird will manage the slave database at the Virginia Beach office. At both locations the local team will communicate with each other as to what and when the database is to be modified. Also, the same information will be passed along to the other location at least until the database is fully functional and more normal methods of communication and database work protocols are put into place.
Outside of the four main database managers currently involved with the project, anyone else will have limited access to the database. There will be passwords protection for the different levels of access. Until the database is fully functional only the 4 database managers will have any access. After the database is fully functional the different levels of access will be:
- Basic user – can view nonconfidential information and use program to enter information
- Executive user – basic user rights plus access to confidential information but cannot modify database DDL
- Database Administrator – full access rights
What We Offer:
100% Original Paper
On-Time Delivery Guarantee
Automatic Plagiarism Check
100% Money-Back Guarantee
100% Privacy and Confidentiality
24/7 Support Service
Save Your Time for More Important Things!
Let a professional tutor with over 10+ years’ experience writes a custom paper for you on this topic