Create a provider database and related reports

Assignment Help Database Management System
Reference no: EM13836330

Case Study - Director's Requirements

Your office has outgrown its old desktop machines and is in the market for new PCs, but would like some guidance on what to purchase. The Director wants to ensure that the office obtains PC machines that meet the requirements stated below. You, as an employee of a small educational company, have been tasked to buy 5 PCs and associated equipment for the office. You only need to determine the specifications for ONE PC, not five. The office will likely buy five of the same computer model/configurations you propose.

The Director has defined some capabilities that the PCs will need to have to ensure optimal performance. These tasks and system needs are collectively the office's requirements. The requirements are as follows:

1. Create documents, spreadsheets, presentations, and send and receive email.

2. Participate in online video conferences, web courses and forums (the Director is a part-time professor at a local university).

3. Create and edit audio and video files and share video and audio files via emails, instant messaging, and in chat rooms via mobile devices.

4. Create small databases to manage all audio, video and photo data.

5. Take high quality digital photos and videosand download them to the PC as well as scan and edit the photos and videos. Manipulate/edit various image and video formats (in the relevant table,please specify at least two image and two video formats that can be accommodated by your solution(s)). .

6. Print documents to include photo quality color printing.

7. Manipulate pdf files, including editing pdfs, conversion from pdf to Word and vice versa.

8. Transfer information (audio, video and photos) between PC machines.

9. Manage the Director's schedule by using an online calendar and day planner.

10. Utilize the internet to make online purchases, conduct banking services and research new audio, video and photo editing methods using a broadband service (in the relevant table,please specify service provider).

11. Connect all required peripheral devices you deem necessary to the system unit.

12. Protect the PC and all components from dirty electrical power including under voltage (brownout or blackout) and overvoltage (power surge or spike).

13. Manage and protect the system, data, and information while working on the Internet including scanning all incoming emails, email attachments, and files downloaded from Web-based sources; firewall, virus and spyware (security) protection; and checking websites for phishing and fraudulent activities.

Create a provider database and related reports and queries to capture contact information for potential PC componentproviders that might be used to purchase the equipment your specified in your MS Word project - the PC specifications..

This Open Office database assignment has the following parts:

1. a simple database table to hold provider contact information;some of the required fields in the table require that a Caption be added to the field characteristics. The Caption will be displayed in the report that is to be generated.
2. a simple database form that can be used to enter data into the database table;
3. a simple database reports that can used to present the data as information;
4. an OO document that contains mailing labels; and
5. a separate MS Word document answering questions about the database.

Create a provider database and related reports and queries to capture contact information for potential PC componentproviders that might be used to purchase the equipment your specified in your MS Word project - the PC specifications..

This Open Office database assignment has the following parts:

1. a simple database table to hold provider contact information;some of the required fields in the table require that a Caption be added to the field characteristics. The Caption will be displayed in the report that is to be generated.
2. a simple database form that can be used to enter data into the database table;
3. a simple database reports that can used to present the data as information;
4. an OO document that contains mailing labels; and
5. a separate MS Word document answering questions about the database.

Attachment:- Assignemnt.rar

Reference no: EM13836330

Questions Cloud

A fixed resource is one that : A fixed resource is one that?
Draw one data flow diagram depicting the logical equivalent : Draw one data flow diagram depicting the logical equivalent for the business process description provided: You are assigned the role to develop a new system based on the project case study.
Conduct several searches using the databases in the library : Conduct several searches using the databases in the Library
Analyze organizational costs and identify technical : Analyze organizational costs and identify technical and economically efficient methods of production and acquisition of resources through the use of microeconomic principles and tools
Create a provider database and related reports : Create a provider database and related reports and queries to capture contact information for potential PC componentproviders that might be used to purchase the equipment your specified in your MS Word project - the PC specifications
The coddling of the american mind : The Coddling of the American Mind
What the kinked demand curve model of oligopoly : Outline what the kinked demand curve model of oligopoly seeks to explain. What are the major points of this theory? How does the kinked demand theory of oligopoly differ from other theories in terms of explaining the behavior of companies in an oligo..
Scoring guide-international economics and scoring standard : Research one case of trade restriction, implemented by any nation. Research your topic, using at least 2 sources, and write a brief report (approximately 2 pages) on your findings. Scoring Guide-International Economics, Scoring Standard
Consider the piecewise function : 1. Consider the piecewise function

Reviews

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