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

  Create a fictional list for job openings

Each student will create an Access 2013 database which will be used to match personal job skills learned in college courses with desired skills for job openings. Students may use their own personal course history, or create a fictional list.

  Relationship of primis to back-end systems at mcgraw-hill

Assess whether the prototyping would have helped the Primis team. Justify why or why not. Conclude why it was important to consider the relationship of Primis to back-end systems at McGraw-Hill

  Database planner should spend a considerable amount of time

Provide what reports may be produced as a result of your database design.Based on the information you have researched, create a 2-3 page design document that includes a description of the database you would like to create as well as sample tables ..

  Identify all entities that have a direct bearing on database

Describe all the business rules that apply to this problem (relationship and constraint). Using the relationship business rules, establish the correct relationships (1:1, 1: M, M: N) between the entities.

  Explain the problems associated with data redundancy

Assignment 5: Logical Design, Part II, Explain the problems associated with data redundancy as it pertains to effectively using information for reporting and analysis.

  What tools does your organization use to deliver rich

q 1 name 3 common vulnerabilities in web applications. how does a company protect against these vulnerabilities?q 2

  Create a database for wild woods apartments

The objective is to create a database for Wild Woods Apartments that can help them organize all of their properties information into one system t help streamline some of the work both the onsite managers have to do as well as the cooperate workers

  Describe the challenges that an organization will face when

describe the challenges that an organization will face when changing business processes and how information systems

  Store information about musicians who perform on its albums

REQUIREMENTS: YoTown Records has decided to store information about musicians who perform on its albums (as well as other company data) in a database

  Discussion of heather sweeney designs operational database

Based on the discussion of the Heather Sweeney Designs operational database (HSD) and dimensional database (HSD-DW) in the text, answer the following questions. Using the SQL statements shown in Figure 1, create the HSD-DW data-base in a DBMS

  Create an rdm for each table in the erd

List all the business rules for the database for Kangaroo Inn. An example of a business rule is: "An invoice is generated by only one customer".

  Create a schema that supports the company business

Create a schema that supports the company's business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure

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