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

  Determine a list of n numbers has no duplicates

Express given five loosely described problems carefully in { Instance, Question } form as utilized in "Computers and Intractability". Determine that a list of n numbers has no duplicates.

  Compare and contrast the advantages of servlets of cgi

Describe the following CLI's and Database Gateways and Describe their architecture, components and challenges.

  Write long term problems when constraints are implemented

Why are these so significant yet so frequently ignored by developers? Write the long term problems when these constraints are not implemented? "

  Display the invoice number and the invoice date

Display the invoice number, the invoice date, the customer id, and the customer name for each order in the database

  Find all of the strong association rules

Find all of the strong association rules. Provide support, c onfidence, and lift for all the rule. Provide the reasons why the rules you selected are interesting.

  Create application owner and stored in schema

One of the tenets of database development is to never permit developers to create or own objects during development. All objects are created by application owner and stored in that schema.

  Program that reads the data from the file into an array

Write a program that- Reads the data from the file into an array of structure when the form is loaded

  Define the digital divide and the impact of the olpc

The Digital Divide and the impact of the OLPC initiative. Write a 1 page summary for each article and include the proper citations.

  Explain the primary and foreign keys for each table

Instructions- This assignment builds on your first two assignments using Access and asks you to consider the process of designing, implementing, and converting data.

  List and explain the defined business rules

The Relational Data Model (RDM) which corresponds to the ERD in the format shown below. The RDMMUSTidentify all primary keys, alternate keys and foreign key constraints. Raw SQL Create Table script dumps from a modeling tool, or SQL Server WILL NO..

  Draw relationship diagram for arrays

Information Gathering Component is very important to a shopping cart system. You really want to develop a good algorithm for it. As a professional practice, you decided to first make a working plan in pseudocode before putting hands.

  The time to complete data modeling

How must a database designer balance the time to complete data modeling steps with the benefits the data modeling process offers in creating a database? Consider examples from your work place and class assignments.

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