Use the web or other resources to research at least two criminal or civil cases in which recovered files played a significant role in how the case was resolved.
Module 2: Assignment: Create and Link Tables Instructions
Use Access to construct a database for a college bookstore store based on the step-by-step instructions listed below.
Create a database and one table:
- The name of the database will be Inventory_YourLastname.
- Create a table named PRODUCTS based on data in Table 1.
- Determine the appropriate data type for each field.
- Assign an AutoNumber field to serve as the Primary Key. This should be the first field of the table and named PRODUCTID.
- Populate the table with data from Table 1.
PRODUCT_NAMEDEPARTMENTQUANTITYPRICESUPPLIERAvocado DipF60.99Jay’sBall Point PenP1500.89BicChipsF770.65Lay’sClass RingC5098.95BalfourDictionaryB2212.95ColumbiaDoritosF1452.49Lay’sFelt-tip PenP760.98BicLogo T-ShirtC2509.99ChampionPencilP2000.15BicPepsiF4440.65PepsiSchool JacketC10034.95ChampionSchool TieC1517.50Field’sThesaurusB 1218.00ColumbiaThree-Hole PaperA2001.98MeadThree-Ring BinderA1223.50Mead
Add a new table to the Inventory database:
You now want to include the supplier information in the INVENTORY database. Use the information below:
- Create a table named SUPPLIERS based on Table 2.
- Determine the appropriate data type for each field.
- Assign the SUPPLIER field as SUPPLIERS table Primary Key.
- Use the Telephone number input mask to format the telephone number.
- Populate the table with data from Table 2.
SUPPLIERCONTACTSTREET ADDRESSCITYSTATEZIP CODEPHONE NUMBERBalfourCoffinWall Street PlazaNew YorkNY100052122690800BicZeienPrudential TowerBostonMA22199ChampionOwen3141 MonroeRochesterNY146037163853200ColumbiaQuigleyColumbia College
New York
NY100270Field’s11 N StateChicagoIL606030Jay’s1504 W 44thChicagoIL606530Lay’sBeeby7701 Legacy DrPlanoTX750242146244700MeadRobertsCourthouse PlazaDaytonOH454635134956323PepsiCallowayAnderson Hill RoadPurchaseNY105779142532000
Relating the two tables:
You will need to establish a link between the PRODUCTS and SUPPLIERS tables.
- Determine the common attribute between the PRODUCTS and SUPPLIERS tables.
- Use the common field and create a relationship.
Perform Sort, Filter and:
- Open the SUPPLIERS table and sort the records based on CITY. Save as CitySort.
- Open the PRODUCTS table and create a filter of your own choice.
- Use the ‘Aggregate’ function to calculate the average price in the PRODUCTS table.
Close and Submit:
- Close your database.
- Submit your database to the assignment submission folder that follows this page.
powerpoint presentation 5-10 slides
I need a powerpoint presentation up to 10 slides, instructions are included.
Assignment 350 words 3 references
On April 18, 2016, The United States Supreme Court denied a petition for certiorari (refused to review the lower court’s ruling) in the case of Authors Guild v. Google, Inc., 804 F. 3d 202 – Court of Appeals, 2nd Circuit 2015.
Tell me what you would do if you were the Supreme Court.
That case let stand the ruling of the Court of Appeals which can be found at the following website:
https://scholar.google.com/scholar_case?case=2220742578695593916&q=Authors+Guild+v.+Google+Inc&hl=en&as_sdt=4000006 last accessed February 9, 2019.
Please write a 400 word summary of fair use as this court decision says it.
Student accurately summarizes the effects of this Supreme Court decision.
Own words
Answer the following questions in a short paper:
1.What functions and capabilities does project management software provide that you cannot do easily using other tools such as spreadsheet or database?
2.Do a comparative analysis of MS Project and the three other software tools you researched. This can be in the form of a MS Word table, showing a comparison of each in terms of specific features, pricing, etc. Or you can write a brief synopsis of each.
3.How can organizations justify investing in enterprise or portfolio project management software?
Your paper should be in APA format and 3-4 pages, not counting the title page and reference pages. Make sure you have in-text citations and a reference page.
Discussion 6
In chapter 8 we focus on cluster analysis. Therefore, after reading the chapter answer the following questions:
- What are the characteristics of data?
- Compare the difference in each of the following clustering types: prototype-based, density-based, graph-based.
- What is a scalable clustering algorithm?
- How do you choose the right algorithm?
Read
- ch. 8 & 9 in textbook: Cluster Analysis: Additional Issues and Algorithms AND Anomaly Detection
Digital Identity
- you will create a visual argument about your identity. Using a medium or technology of your choice, you will need to do the following:
- Create an artifact that visualizes or explains some aspect of your identity. Make sure to focus on your identity or personality traits. Some ideas include:
- Creating a professional poster using PowerPoint
- Creating a slide show presentation
- Creating a digital picture collage
- In a 2 page, discuss the following:
- What is the identity trait or category you are depicting? How would you define it?
- Why did you choose this trait? Is it a defining part of your identity, or rather an element of your identity by which you would rather not be characterized?
- How does this identity trait/category impact your life? Is there a defining event or moment which characterizes this?
- How do other people perceive or understand this element of your identity?
- What is it that you want people to learn about you?
Swift Project
The challenge of this game is to collect as many as flower with the vase (catcher). Flowers fall down from the top of the screen and user will move the vase and collects flowers. In the above figure the dashed line arrows show possible movement directions of the components. In the game no dashed line will be shown. The game scene runs in gravity. The flower will be left from randomly chosen X points (Y is fix) from the top. User can swipe vase only to the right and/or left to collect them. Once the vase touches a flower, then a score is made, and that particular flower disappears with a sound (for example, http://soundbible.com/1536-Stapler.html). User will be granted 60 sec to collect as much as flowers. On the top-right corner of the game, show the remain time and score. Make sure that not many flowers will release at the same time. You may adapt a strategy to release flowers in a discrete way, such as one flower will be release every 2 – 5 seconds from random coordinates. Make sure that flower and vase sprites are not so small and/or big. A typical size for a flower is 64×64, and for vase image is 100×100. Game ends after 60 seconds, shows the score and a restart button a new game.
Software management -4 Dis
Write about a project that you accomplished. Explain what needed to be done, how it got done, who worked on the project, how long did it take, how much it cost, and what were the risks involved in the project. (Review Chapter 1).
chpt 2 cont
Comments: study seems to be about assessing IoT issues, with no variables to measure. Please Change it and make this as a qualitative study.