This is a simple list table of a company trying to keep track of parts that they sell and orders that came in purchasing those parts (in other words, not a database but a flat one table file). You will design a database for this company so that they won’t be relying on a simple 1 table list system to keep track of their data. Looking at the table below, produce the 3NF of the data.
OrderNum |
OrderDate |
PartNum |
Description |
NumOrdered |
QuotedPrice |
21608 |
10/20/2010 |
AT94 |
Iron |
11 |
$21.95 |
21610 |
10/20/2010 |
DR93 |
Gas Range |
1 |
$495.00 |
21610 |
10/20/2010 |
DW11 |
Washer |
1 |
$399.99 |
21613 |
10/21/2010 |
KL62 |
Dryer |
4 |
$329.95 |
21614 |
10/21/2010 |
KT03 |
Dishwasher |
2 |
$595.00 |
21617 |
10/23/2010 |
BV06 |
Home Gym |
2 |
$794.95 |
21617 |
10/23/2010 |
CD52 |
Microwave Oven |
4 |
$150.00 |
21619 |
10/23/2010 |
DR93 |
Gas Range |
1 |
$495.00 |
21523 |
10/23/2010 |
KV29 |
Treadmill |
2 |
Create the database in an actual database application (i.e Microsoft Access, MySQL or Oracle, etc.). You must use SQL commands to create the tables in the database (i.e Create Table command). Submit the SQL commands with the completed database as part of the assignment. The tables should be populated with records from the scenario you chose.
In: Computer Science
Count the number of flops (floating point operations) in the following pseudocode:
for i=1:n
for j=1:i
for k=j:n
y=y+aijxij
end
end
end
In: Computer Science
(MATLAB ONLY) (MATLAB ONLY) (MATLAB ONLY) (MATLAB ONLY) (MATLAB ONLY) (MATLAB ONLY)
Please complete the following Question in MATLAB ASAP, Thanks. :)
2a. Write a function that outputs the amount of freezing point depression (in degrees C) given a mass of magnesium chloride salt and a volume of water. Formula to calculate freezing point depression: ΔT = iKm in which ΔT is the change in temperature in °C, i is the van't Hoff factor, which = 3 for MgCl2 because it dissociates into three ions, one Mg+2 and two Cl- , K is a constant that equals 1.86 °C kg/mol and m is the molality of the solute in mol/kg. Other useful information so you don’t have to look it up: Moles of MgCl2 = (mass MgCl2)/((atomic mass Mg)+2*(atomic mass Cl)) Atomic mass Mg = 24.31 Atomic mass Cl = 35.45 Assume the density of water is 1.0 g/mL
2b. Use your function to calculate the depression for 100g MgCl2 dissolved in 500mL water
2c. Use your function to calculate the depression for 220g MgCl2 dissolved in 1L water
2d. Make a plot that shows the mass of MgCl2 necessary to depress the freezing point of a given volume (range: 1L - 100L) water by 1 degree Celsius. Give your plot appropriate labels and a title.
In: Computer Science
Make a public class Creater that provides a single class (static) method named subtractor. subtractor takes a single int argument and returns a method that implements the following Create interface:
public interface Create {
int change(int something);
---------------------------------------------------------------------
The returned “function” should implement Create so that it subtracts the value passed to subtractor. For example
Create one = Creater.substractor(5);
Create two = Creater.subtractor(-3);
System.out.println(one.change(5)); // should print 0
System.out.println(second.change(3); // should print -6
The answer should be is a single line lambda expression.
---------------------------------------------------------------------
Please continue what I have started:
public class Creater {
public static Create subtractor(int input) {
I’m not sure how to continue. Please write in simple java code, I'm a beginner student.
In: Computer Science
Using recursion find the answer to do the question below, Use the derivation and substitution method.
3.t(n) = 6t(n-1) + 4t(n-2) +4(3^n)
In: Computer Science
You have been accepted as a Junior Project Manager at Super IT
Pty. Ltd. Your first task assigned by the Senior Project Manager is
to select and prioritise the best mobile application project in
response to COVID-19 and the second task assigned is to write the
Project Scope of the chosen project.
These candidate projects include:
Gaming or entertainment application for COVID-19 isolated
patients.
Mobile applications in support of contact tracing for
COVID-19.
Mobile application information to provide the latest update of
COVID-19.
Mobile health application to contact doctors.
Chatting application or social media platform for COVID-19
patient and family.
You have decided to use Project Selection and Prioritisation Matrix
to select the best project, and then you will write the Project
Scope of it.
2.1 Explain three criteria used for your Project Selection and
Prioritisation Matrix. Provide the reasons why you chose each
criterion.
[5 marks]
2.2 Draw the Project Selection and Prioritisation Matrix and
explain how you are finally able to select the chosen
project.
[10 marks]
2.3 Write the Project Scope statements for your chosen
project.
[10 marks]
In: Computer Science
Congratulations! After presenting your proposal on mobile
application in response to COVID-19 pandemic in front of investors,
one of the potential investors is very keen on your project.
However, the investor has asked you to speed up your project to be
completed in 2 weeks, although you have planned a project duration
of 3 months. Note that your total cost is around $100,000 and the
investor is willing to cover the expenses for it. The investor has
also asked you further questions regarding Information Technology
Infrastructure Library (ITIL) life cycle standard and the
user/customer satisfaction of your mobile application.
4.1 Provide a simple Work Breakdown Structure (WBS) of activities
and a Gantt chart of your project which fits with Questions 2, 3
and 4.
[10 marks]
4.2 Figure out which activities you would like to crash in order to
compress the duration of your project to 2 weeks. Explain how you
chose these crashed activities in detail.
[5 marks]
4.3 Explain the ITIL lifecycle processes of your chosen
project.
[5 marks]
4.4 List three best suited customer feedback questions when you
launch your project.
[5 marks]
In: Computer Science
Write Javascript code for the function malwareFrequencies() that shows the malware analyst a prompt. The analyst enters a list of malware names (separated by spaces) for each malware incident they have heard about in the last month. Note that the same malware can be involved in multiple incidents. Your function should print those malware names and their frequencies to the screen. Sample output is shown below.
Zeus 1
Emotet 3
WannaCry 2
Emotet 3
Emotet 3
WannaCry 2
In: Computer Science
Using PyCharm Edu on Windows, need to ask for an IP address (input), use "ipaddress.ip_address" to validate it, only if error (value or type) set the default IP to 192.168.1.1, if no error then use the original input. This is the code so far and I need help please.
def req_Address(): while True: try: address = str(ipaddress.ip_address(input("Please enter the ip address you wish scan [192.168.1.1]: "))) except (ValueError, TypeError): print("Not a valid IP address") else: print("Setting the default address to 192.168.1.1") address = '192.168.1.1' print("We will use: " + address) print()
In: Computer Science
The Project Management Body of Knowledge (PMBOK) recommends five (5) phases/process groups which are Initiating, Planning, Execution, Monitoring and Control; and Closing. There are PMBOK ten (10) Knowledge areas as well as tools associated to them.
a) Which is PMBOK Knowledge area using a tool of Stakeholder Register?
b) Which is PMBOK Knowledge area using a tool of Project Charter?
c) Which are two PMBOK Knowledge areas that use the tool of Resource Levelling?
d) Which are two PMBOK Knowledge areas that use the tool of WBS?
e) Which is PMBOK Knowledge area using the tool of risk register?
In: Computer Science
In: Computer Science
This program needs to be in C++. I have barely gotten anywhere but am already stuck. Any help with this one would be greatly appreciated.
Write a program that simulates playing a simplified version of the game "Candy Land." In "Candy Land" players take turns drawing cards that have a colored square on them. The player then travels on the board according to the color on the card. The first person to reach the end of the board wins.
In this version we will practice using arrays and enums. We will use an array of ints to represent the players of the game. You should have an int array of size 4, then you will prompt the user for the number of players from 2 - 4 and this will determine how much of the array you will use. You will create an enum type CARD. The values of the enum will be the possible color of the card. Value 0 should represent an empty deck, and you should have 6 colors (RED, PINK, ...).
To draw a card you will read a number from cards.txt. Write a function that takes an ifstream as an input parameter and returns a CARD. Read a number from the file and convert the number to a variable of the CARD type.
After prompting for the number of players use a loop to draw cards for each player. After drawing a card, move the player by adding the card value to the player total. The game will end either when the first player reaches 20 or there are no more cards (input file reaches the end). The winner is the first player to have a score of 20 or more, or the player with the most points after all the cards have been drawn.
The program should output for each player's turn the current player, the card they drew, how many spaces they move, and their location after moving (total score).
In: Computer Science
Ruby Problem
Create a template for an email letterhead with the following variables. The letter head will have format place holders for:
Company name
Street address
City, State and zip code
Telephone
Web site URL
Use the array of data below to fill your template place holders:
Run your finished script and capture the output to a file named email_template.txt.
# Two pieces of data in one array (multi dimensional array) contact_data = [ ['Company 1','123 Main Street', 'Anytown','Anystate', 88888,'444-444-4444','[email protected]','https://company1.com'], ['Company 2','77 Market Street', 'San Francisco','California', 94111,'415-444-4444','[email protected]','https://company2.com'] ] ######### CREATE YOUR EMAIL TEMPLATE HERE ######### email_template = "" # Process the data one array at a time contact_data.each do |arr| # your code goes here. end
Your output should end up looking something like this:
Company 1 123 Main Street Anytown, Anystate 88888 Tel: 444-444-4444 Email: [email protected] URL: https://company1.com ------------------------------ Company 2 77 Market Street San Francisco, California 94111 Tel: 415-444-4444 Email: [email protected] URL: https://company2.com ------------------------------
In: Computer Science
In Java.This program will translate a word into pig-latin. Pig-latin is a language game in which words in English are altered, usually by removing letters from the beginning of a word and arranging them into a suffix. The rules we will use for the pig-latin in this program are as follows: If a word starts with a consonant, split the word at the first instance of a vowel, moving the beginning consonants to the end of the word, following a '-'. Then add 'ay' at the end of the word. Vowels are: a, e, i, o, u (Notice: We are not considering y a vowel for this program) If a word starts with a vowel add the word "yay" at the end of the word following a '-'. Examples: hello translates to ello-hay flare translates to are-flay it translates to it-yay A more detailed explanation of the requirements for each method will be in the method header comments - please follow these closely. Suggested order of completion: isVowel() then pigLatin().
In: Computer Science
Define a Python function named matches that has
two parameters. Both parameters will be lists of ints. Both lists
will have the same length. Your function should use the
accumulator pattern to return a newly created list. For
each index, check if the lists' entries at that index are
equivalent. If the entries are equivalent, append the literal True
to your accumulator. Otherwise, append the literal False to your
accumulator.
Hint: Since you must use the same index with each list,
only write one loop in your function. The loop should use
the built-in range function as its collection, since that
will assign our loop variable to each index and, in the loop body,
we can use the loop variable to get each input's entry at that
index.
In: Computer Science