Exp19_Access_Ch01_CapAssessment – Latte Delights Inventory 1.0 | Access Chapter 1

Project Description:

In this project, you will open a database containing the inventory of a coffee shop, create a new table in which to store sales representatives (reps) information, and then add the sales rep records. You add a new product using a form and print a report. You apply a filter by selection and sort a query, and then you apply a filter by form to a table. You save both filters.

Open   the Customers form in Form view. Use Search to locate the record for Baker Auto   Supply. Modify   the record so that the Address1 field displays 4508 N.W. 7 Avenue. Save and close the form.

Open the Products form in Form   view. Add a new product (Access will automatically add the Product ID): Coffee-Arabica   Premium. The   Description is 24/Case, Pre-Ground 1.75 Oz Bags, the Cost is $13 (just type 13, no $), the   Markup Percent is 100%, the Brand is Premium, and the Year Introduced is 2017. Save the new record and close the form.

Open the Products report and   check that the report contains the new product P0026, Coffee-Arabica Premium.   View the layout of the report in Print Preview and then change the page   layout to Landscape. Save the report and close Print Preview.

Open the Customers table. Sort   the table by Customer Name in ascending order. Save the changes and close the   table.

Open the Revenue Stats query and   sort the City field in ascending order. Apply Filter by Selection so that   only stats for the last name Pellum   display. Save and close the filtered query.

Open the Products table. Use   Filter by Form to create a filter that will identify all premium brands in   the Brand field that were introduced after 2017. Apply the filter and preview the filtered table.   Close the table and save the changes.

Close all database objects.   Close the database and then exit Access. Submit the database as directed.

Background:

ShoppersLand Inc. is the leading retail chain in Canada. We offer a large range of products including food, clothing, electronics, and pharmaceutical drugs. As a company we strive to provide the best shopping experience for our customers. We are continually trying to find innovative ways to help shoppers have a better experience in our stores. 

We would like to develop an online system, i.e., SmartShoppers, to allow customers to find products in our stores with greater precision than the current system. When open the system, the user will need to specify their postal code and/or their city and province. They will then be presented with a list of stores within their area to choose from as the location they will be shopping at. There should also be a feature which lets the user save this store as their location for future use. The user should also be able to change the store location any time they wish. The user should then be able to create a shopping list by searching for products and by viewing a list of sale items at the store they specified. An algorithm should then provide the user with the list in the best order in which to find the items, starting at the front of the store. Users should also be able to click on items to see a product description, price and where in the store it can be found. The user should also be able to view a list of suggested items. This list would consist of products that others have searched for when they have also searched for items on the users shopping list. 

Tasks: 

a): please apply at least one design pattern we have introduced, and explain which requirements you think the patterns can help.

b): design a system that can meet the requirements described above via class diagrams, and describe how you design can meet the requirements. Please show the details of classes (including attributes, methods, and relations among classes) in your class diagrams. YOU MUST USE https://app.diagrams.net/ to draw your diagram and submit the “.png” of your class diagram, penalty will be imposed for violation.

 1 page apa format cite sources 

Unit 2 DB: Threats

The PCS working group has been a smashing success and the team members have already formed better inter-department communications. The customer Security Director from the Istanbogus Ministry of Defense has requested a threat briefing explaining the top risks to his new system. As the CISO you have your ideas but would like to get the opinion of the working group members. Describe at least three different categories (human and non-human) of threats from your Unit research. Explain how each category presents risk to information systems. Make a case for the top threat to the missile defense system for each category and give an example of how that threat might be realized in a real compromise of the system. Discuss some of the factors that play into the assessment of system threats. Include at least one research reference and associated in-text citation using APA standards. In your replies to your peers discuss the other described threats and if you feel they are greater or lesser risks to the system. 

Need to prepare 4 parts for the project. each parts should have 4-5 pages.

Unit 3 Lab: Adding a Hard Drive

Outcomes addressed in this activity:

Unit Outcomes:

• Modify the system to add storage devices, such as disk drives, to the system.
• View available disks.
• Partition disks.

Course Outcome:

IT275-2: Configure the key features of the Linux operating system.

Purpose

This lab focuses on adding a hard drive to a Linux system.

Lab Instructions

Review the Unit 3 Lab Rubric (under Course Resources, then Grading Rubrics) before beginning this activity.

1. Using the techniques discussed in the readings, complete the lab in A Cloud Gurucalled “Managing Disks, Partitions, and File Systems in SUSE Linux Enterprise.”

You will have 2 hours to complete the lab. Run the command echo your name `date`. Note: The ` symbol is next to the number 1 on your keyboard.

1. Take screen captures of the aforementioned information, along with the output of the “Create a Partition and Filesystem on…,” “Partition and Create A Filesystem Using Yast,” and “Mount the Drives to the System…” sections.
2. Finally, write a paragraph on what you have learned in this lab and any items you still need to have explained.

Lab Requirements

Your lab document should include:

• Required screenshots, as outlined in the Instructions tab, pasted inside a Microsoft Word document. Multiple screen captures are okay.
• A paragraph describing what you learned and what you still have questions about.
• Both in-text citations and references for all sources. For more information on APA style formatting, go to the resources under the Academic Tools area of this course.
• No spelling, grammar, or APA style errors.

Module 10: Discussion: Data Security and Privacy

For data sets listed below, explain whether or not data security and privacy are important issues:

• Names and addresses from a telephone book
• Names, phone numbers, and emails collected from contact pages on a website
• Census data collected from 2020
• IP addresses and visit times of users on a website

QUESTION 1

Use the following business rules to create a Crow’s Foot ERD. Write all appropriate connectivities and cardinalities in the ERD.

• A department employs many employees, but each employee is employed by only one department.
• Some employees, known as “rovers,” are not assigned to any department.
• A division operates many departments, but each department is operated by only one division.
• An employee may be assigned many projects, and a project may have many employees assigned to it.
• A project must have at least one employee assigned to it.
• One of the employees manages each department, and each department is managed by only one employee.
• One of the employees runs each division, and each division is run by only one employee.

 SAVE AS:  ch4_question1_deleon.doc 

—————————————————–

QUESTION 2

Create a complete ERD in Crow’s Foot notation that can be implemented in the relational model using the following description of operations. Hot Water (HW) is a small start-up company that sells spas. HW does not carry any stock. A few spas are set up in a simple warehouse so customers can see some of the models available, but any products sold must be ordered at the time of the sale

• HW can get spas from several different manufacturers.
• Each manufacturer produces one or more different brands of spas.
• Each and every brand is produced by only one manufacturer.
• Every brand has one or more models.
• Every model is produced as part of a brand. For example, Iguana Bay Spas is a manufacturer that produces Big Blue Iguana spas, a premium-level brand, and Lazy Lizard spas, an entry-level brand. The Big Blue Iguana brand offers several models, including the BBI-6, an 81-jet spa with two 6-hp motors, and the BBI- 10, a 102-jet spa with three 6-hp motors.
• Every manufacturer is identified by a manufacturer code. The company name, address, area code, phone number, and account number are kept in the system for every manufacturer.
• For each brand, the brand name and brand level (premium, mid-level, or entry level) are kept in the system.
• For each model, the model number, number of jets, number of motors, number of horsepower per motor, suggested retail price, HW retail price, dry weight, water capacity, and seating capacity must be kept in the system.

 SAVE AS:  ch4_question2_deleon.doc 

————————————————————

QUESTION 3

The Jonesburgh County Basketball Conference (JCBC) is an amateur basketball association. Each city in the county has one team as its representative. Each team has a maximum of 12 players and a minimum of 9 players. Each team also has up to 3 coaches (offensive, defensive, and physical training coaches). During the season, each team plays 2 games (home and visitor) against each of the other teams. Given those conditions, do the following:

• Identify the connectivity of each relationship.
• Identify the type of dependency that exists between CITY and TEAM.
• Identify the cardinality between teams and players and between teams and city.
• Identify the dependency between COACH and TEAM and between TEAM and PLAYER.
• Draw the Chen and Crow’s Foot ERDs to represent the JCBC database.
• Draw the UML class diagram to depict the JCBC database.

 SAVE AS:  ch4_question3_deleon.doc 

—————————————————————————

QUESTION 4

Create an ERD based on the Crow’s Foot notation using the following requirements:

• An INVOICE is written by a SALESREP. Each sales representative can write many invoices, but each invoice is written by a single sales representative.
• The INVOICE is written for a single CUSTOMER. However, each customer can have many invoices.
• An INVOICE can include many detail lines (LINE), each of which describes one product bought by the customer.
• The product information is stored in a PRODUCT entity.
• The product’s vendor information is found in a VENDOR entity.

 SAVE AS:  ch4_question4_deleon.doc 

—————————————————————–

QUESTION 5

The Hudson Engineering Group (HEG) has contacted you to create a conceptual model whose application will meet the expected database requirements for the company’s training program. The HEG administrator gives you the following description of the training group’s operating environment. (Hint: Some of the following sentences identify the volume of data rather than cardinalities. Can you tell which ones?)

The HEG has 12 instructors and can handle up to 30 trainees per class. HEG offers 5 Advanced Technology courses, each of which may generate several classes. If a class has fewer than 10 trainees, it will be canceled. Therefore, it is possible for a course not to generate any classes. Each class is taught by one instructor. Each instructor may teach up to 2 classes or may be assigned to do research only. Each trainee may take up to 2 classes per year.

Given that information, do the following:

a. Define all of the entities and relationships.

b. Describe the relationship between instructor and class in terms of connectivity, cardinality, and existence dependence.

 SAVE AS:  ch4_question5_deleon.doc 

——————————————————————–

QUESTION 6

Automata, Inc., produces specialty vehicles by contract. The company operates several departments, each of which builds a particular vehicle, such as a limousine, truck, van, or RV.

• Before a new vehicle is built, the department places an order with the purchasing department to request specific components. Automata’s purchasing department is interested in creating a database to keep track of orders and to accelerate the process of delivering materials.
• The order received by the purchasing department may contain several different items. An inventory is maintained so the most frequently requested items are delivered almost immediately. When an order comes in, it is checked to determine whether the requested item is in inventory. If an item is not in inventory, it must be ordered from a supplier. Each item may have several suppliers.

Given that functional description of the processes at Automata’s purchasing department, do the following:

a. Identify all of the main entities.

b. Identify all of the relations and connectivities among entities.

c. Identify the type of existence dependence in all the relationships.

d. Give at least two examples of the types of reports that can be obtained from the database. 

 SAVE AS:  ch4_question6_deleon.doc 

—————————————————————————————

QUESTION 7

United Helpers is a nonprofit organization that provides aid to people after natural disasters. Based on the following brief description of operations, create the appropriate fully labeled Crow’s Foot ERD.

• Volunteers carry out the tasks of the organization. The name, address, and telephone number are tracked for each volunteer. Each volunteer may be assigned to several tasks, and some tasks require many volunteers. A volunteer might 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 start time and end time of that assignment.
• Each task has a task code, task description, task type, and task status. For example, there may be a task with task code “101,” a description of “answer the telephone,” a type of “recurring,” and a status of “ongoing.” Another task might have a code of “102,” a description of “prepare 5,000 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 packing lists to produce different packages, such as basic medical packages, child-care packages, and food packages. Each packing list has an ID number, a packing list name, and a packing list description, which describes the items that should make up the package. Every packing task is associated with only one packing list. A packing list may not be associated with any tasks, or it 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 produced by the organization is tracked, and each package is assigned an ID number. The date the package was created and its total weight are recorded. A given package is associated with only one task. Some tasks (such as “answer the phones”) will not produce any packages, while other tasks (such as “prepare 5,000 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.
• Each item that the organization provides has 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 as well. 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 the package includes bandages and iodine needs to be recorded along with the quantity of each item included. It is possible for the organization to have items that have not been included in any package yet, but every package will contain at least one item.

 SAVE AS:  ch4_question7_deleon.doc 

———————————————————————————–

QUESTION 8

Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic using the following business rules:

• A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient.
• Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.”
• If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment.
• With each visit, the patient’s records are updated to provide a medical history.
• Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients.
• Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill.
• A patient may pay the bill directly, or the bill may be the basis for a claim submitted to an insurance company.
• If the bill is paid by an insurance company, the deductible is submitted to the patient for payment.

 SAVE AS:  ch4_question8_deleon.doc 

————————————————————

QUESTION 9

Create a Crow’s Foot notation ERD to support the following business operations:

• A friend of yours has opened Professional Electronics and Repairs (PEAR) to repair smartphones, laptops, tablets, and MP3 players. She wants you to create a database to help her run her business.
• When a customer brings a device to PEAR for repair, data must be recorded about the customer, the device, and the repair. The customer’s name, address, and a contact phone number must be recorded (if the customer has used the shop before, the information already in the system for the customer is verified as being current). For the device to be repaired, the type of device, model, and
• serial number are recorded (or verified if the device is already in the system). Only customers who have brought devices into PEAR for repair will be included in this system.
• Since a customer might sell an older device to someone else who then brings the device to PEAR for repair, it is possible for a device to be brought in for repair by more than one customer. However, each repair is associated with only one customer. When a customer brings in a device to be fixed, it is referred to as a repair request, or just “repair,” for short. Each repair request is given a reference number, which is recorded in the system along with the date of the request, and a description of the problem(s) that the customer wants fixed. It is possible for a device to be brought to the shop for repair many different times, and only devices that are brought in for repair are recorded in the system. Each repair request is for the repair of one and only one device. If a customer needs multiple devices fixed, then each device will require its own repair request.
• There are a limited number of repair services that PEAR can perform. For each repair service, there is a service ID number, description, and charge. “Charge” is how much the customer is charged for the shop to perform the service, including any parts used. The actual repair of a device is the performance of the services necessary to address the problems described by the customer. Completing a repair request may require the performance of many services. Each service can be performed many different times during the repair of different devices, but each service will be performed only once during a given repair request.
• All repairs eventually require the performance of at least one service, but which services will be required may not be known at the time the repair request is made. It is possible for services to be available at PEAR but that have never been required in performing any repair.
• Some services involve only labor activities and no parts are required, but most services require the replacement of one or more parts. The quantity of each part required in the performance of each service should also be recorded. For each part, the part number, part description, quantity in stock, and cost is recorded in the system. The cost indicated is the amount that PEAR pays for the part. Some parts may be used in more than one service, but each part is required for at least one service.

 SAVE AS:  ch4_question9_deleon.doc 

—————————————————————

QUESTION 10

Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all of the various information needs of the company. The company’s operations are as follows:

• LOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an employee ID, but the system should also record a guide’s name, home address, and date of hire. Guides take a test to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date
• that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified guides. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides.
• Every tour must be designed to visit at least three locations. For each location, a name, type, and official description are kept. Some locations (such as the White House) are visited by more than one tour, while others (such as Arlington Cemetery) are visited by a single tour. All locations are visited by at least one tour. The order in which the tour visits each location should be tracked as well.
• When a tour is actually given, that is referred to as an “outing.” LOST schedules outings well in advance so they can be advertised and so employees can understand their upcoming work schedules. A tour can have many scheduled outings, although newly designed tours may not have any outings scheduled. Each outing is for a single tour and is scheduled for a particular date and time. All outings must be associated with a tour. All tours at LOST are guided tours, so a guide must be assigned to each outing. Each outing has one and only one guide. Guides are occasionally asked to lead an outing of a tour even if they are not officially qualified to lead that tour. Newly hired guides may not have ever been scheduled to lead any outings. Tourists, called “clients” by LOST, pay to join a scheduled outing. For each client, the name and telephone number are recorded. Clients may sign up to join many different outings, and each outing can have many clients. Information is kept only on clients who have signed up for at least one outing, although newly scheduled outings may not have any clients signed up yet.

a. Create a Crow’s Foot notation ERD to support LOST operations.

b. The operations provided state that it is possible for a guide to lead an outing of a tour even if the guide is not officially qualified to lead outings of that tour. Imagine that the business rules instead specified that a guide is never, under any circumstance, allowed to lead an outing unless he or she is qualified to lead outings of that tour. How could the data model in Part a. be modified to enforce this new constraint?

 SAVE AS:  ch4_question10_deleon.doc  

Write a program wherein it asks, does user want desktop or laptop. If he says desktop prompt them to choose brand (dell, toshiba, hp), hard drive (capacity), cpu brand and speed, monitor (size in inches), ram(capacity), case (tower, mid tower, mini tower). If they choose laptop, brand (toshiba, dell etc), hard drive, ram, cpu, display size.
– if they choose laptop then laptop class, desktop, desktop class. display all options & their name.

Test Data13,2,0,1,21·

Checkpoints1) Include name, e-mail, and lab# and comments in code and include code to output this information to the output.2) Minimum of five (5) comments in main()3) use a defined constant for the tax rate 4) use a memory constant for each unit price 5) Output must be formatted exactly as above with decimal points lined up.

LAB 3: TV/VCR 

Write a program to create a customers bill for a company. The company sells only five products: TV, DVD player, Remote Controller, CD Player, and Audio Visual Processor. The unit prices are $500.00, $380.00, $35.20, $74.50, and $1500.00, respectively. Prompt the user and input for the quantity of each product sold. Calculate the subtotal for each item and the subtotal of the bill. Calculate the tax on this subtotal. Last calculate the total of subtotal plus tax. How many TVs were sold? 3How many DVD players were sold? How many Remote Controller units were sold?5How many CD Players were sold? 6How many AV Processors were sold? QTY Description Unit Price Total 

 When thinking about data visualization, it is important to understand regular expressions in data analytics.  Therefore, note the importance of data visualizations and choose two types of expressions (* – wildcards for example) and discuss the difference between the two types of expressions. 

Write a program that uses regular expressions to convert the first letter of every word to uppercase. Have it do this for an arbitrary string input by the user. 

Please use C# language and submit as a zip file.