Marcia wants to keep track of each of her customers and their orders. Ultimately, she wants to notify them that their clothes are ready via email. Suppose that you have designed a database for Marcia’s Dry Cleaning that has the following tables:

CUSTOMER (CustomerID, FirstName, LastName, Phone, EmailAddress)

INVOICE (InvoiceNumber, CustomerID, DateIn, DateOut, Subtotal, Tax, TotalAmount)

INVOICE_ITEM (InvoiceNumber, ItemNumber, ServiceID, Quantity, UnitPrice, ExtendedPrice)

SERVICE (ServiceID, ServiceDescription, UnitPrice)

The referential integrity constraints are:

CustomerID in INVOICE must exist in CustomerID in CUSTOMER

InvoiceNumber in INVOICE_ITEM must exist in InvoiceNumber in INVOICE

ServiceID in INVOICE_ITEM must exist in ServiceID in SERVICE

Assume that CustomerID of CUSTOMER, EmployeeID of EMPLOYEE, ItemID of ITEM, SaleID of SALE, and SaleItemID of SALE_ITEM are all surrogate keys with values as follows: CustomerID Start at 100 Increment by 1

InvoiceNumber Start at 2018001 Increment by 1

D. Suppose that MArcia decides to allow multiple customers per order (e.g. for customers' spouses). Modify the design of these tables to accommodate this change.

E. Code SQL statements necessary to redesign the database, as described in your answer to question D.

F.Suppose that Marcia considers changing the primary key of CUSTOMER to (FirstName, LastName). Write correlated subqueries to display any data that indicate that this change is not justifiable.

Consider the following questions and provide your responses in the form of short answers. Be sure to apply your knowledge from the course thus far and use critical thinking to address these questions thoughtfully and thoroughly. If you use any external sources in your responses, be sure to cite them.

1. Define the term “globalization” and explain how advances in information technology have stimulated globalization. Describe recent events that provide evidence of globalization.
2. What is “the digital divide?” Describe the two fundamentally different dimensions of the digital divide.

sorry found a solution!

Do you think that having a government where employees demographically represent the population means that all voices have a shot of getting heard? Does having people who look like you in government increase your faith in government? Can a government official who comes from a different background advocate on your behalf?

At some instant, an alpha particle(q=+2e) has the coordinates(3.0,0.0,0.0)(nm) and is moving along the positive x-axis with 500km/s while an electron at (0.0,4.0,0.0)(nm) is moving along the negative y-axis with 1000km/s.
A)SHOW ALL WORK
Find the magnitude and direction of the total magnetic field at the location(3.0,4.0,0.0)(nm)
B)SHOW ALL WORK
Find the magnitude and direction of the magnetic forces felt by the electron and alpha particle.

A ladder is leaning against a vertical wall, and both ends of the ladder are at the point of slipping. The coefficient of friction between the ladder and the horizontal surface is μ1 = 0.295 and the coefficient of friction between the ladder and the wall is μ2 = 0.153. Determine the maximum angle with the vertical the ladder can make without falling on the ground.

IT Project Management:

1. Duration estimates are often provided as a discrete number, such as four weeks, or as a range, such as three to five weeks, or as a(n) ____________________.

2. Most projects have one path through a network diagram.

True or False

3. To make milestones meaningful, some people use the ____________________ criteria to help define them.

4. ____ involves analyzing activity sequences, activity resource estimates, and activity duration estimates to create the project schedule.

a. Estimating activity durations

b. Developing the schedule

c. Controlling the schedule

d. Estimating activity resources

5. ____ results in supporting detail to document important product information as well as assumptions and constraints related to specific activities.

a. Defining activities

b. Sequencing activities

c. Estimating activity resources

d. Estimating activity duration

*Answer must be in C*

Write a program as follows:

a- Define a structure type named "student" capable of storing the name of a student (string less than 15 characters long),

homework grade as float, and exam grade as a float.

b- Create an array of students named "cats" to store the info for 50 students.

c- Create a menu (and repeatedly display the menu) with three options:

option 1: enter the info for a student.

option 2: print the info of all students, do not print structures that have no hurricane data in them

option 3: exit program

d. write code to carry out each menu option

Regarding Operating Systems

Researchers have suggested that, instead of having an access control list associated with each file (specifying which users can access the file, and how), we should have a user control list associated with each user (specifying which files a user can access, and how). Discuss the relative merits of these two schemes.

A firm’s total cost per month is $24000 including $12000 as total fixed cost and remaining as total variable cost. Firm produces 1000 units of the product every month in a competitive environment where it is a price taker. Firm’s per month total revenue is $30000. Some thing went wrong and firm’s total revenue dropped from $30000 in October to $ 21000 in November. Should the firm shut down or not and why? The manager of the firm knows that total revenue of the firm will further decrease to $10000 in December. What is the best decision manager will take and when and why?

#Write a function called average_word_length that takes as
#input a string called my_string, and returns as output the
#average length of the words in the string.

In writing this function, note the following:
#
# - You should account for consecutive spaces. A string like
# "Hi Lucy" is two words with an average length of 3.0
# characters.
# - You should not assume the string starts with a letter.
# A string like " David" has one word with an average
# length of 5.0 characters.
# - You should not count punctuation marks toward the
# length of a word. A string like "Hi, Lucy" has two
# words with an average length of 3.0 characters: the ,
# after "Hi" does not count as a character in the word.
# The only punctuation marks you need to handle are
# these: . , ! ?
# - You may assume the only characters in the string are
# letters, the punctuation marks listed above, and spaces.
# - If my_string is not a string, you should instead return
# the string, "Not a string".
# - If there are no words in my_string, you should instead
# return the string, "No words". This could happen for
# strings like "" (an empty string) and ".,!?" (a string
# of only punctuation marks). You may assume that any
# of these punctuation marks will always be followed by
# at least one space.
#
#Here are a few hints that might help you:
#
# - You can peak at the first character in my_string with
# my_string[0]. If my_string is "Hi, Lucy", then the value
# of my_string[0] is "H". You don't have to do this, but
# you can if you want.
# - There are lots of ways you can do this. If you're
# stuck, try taking a step back and thinking about the
# problem from a fresh perspective.
# - If you're still stuck, try counting words and letters
# separately, and worrying about average length only
# after both have been counted.
# - The word count should equal the number of letters that
# come immediately after a space or the start of the
# string. The character count should simply equal the
# number of characters besides spaces and punctuation
# marks. The average word length should be character
# count divided by word count.

#Write your function here!
average_word_length(my_string)

#When your function works, the following code should
#output:
#2.0
#3.0
#4.0
#Not a string
#No words

print(average_word_length("Hi"))
print(average_word_length("Hi, Lucy"))
print(average_word_length(" What big spaces you have!"))
print(average_word_length(True))
print(average_word_length("?!?!?! ... !"))

1. Choose any model of the SDLC and analyze the tasks at each stage as described below. Write at least one full paragraph for each stage of the SDLC including what it consists of and how you would apply that stage to the Case Study as described below.

Apply the Systems Development Life Cycle to the case described below. Choose any model of the Systems Development Life Cycle and analyze the tasks you would need to accomplish at each stage of the Systems Development Life Cycle for that model. You may use any of the SDLC models I gave you in the Lessons area in the Week 1 or Week 2 Lessons, or any other model of your own choice. However, be sure to state which model you are using and provide a URL to the resource(s) you consulted on that model so that I can compare your analysis of the case study against the specific Systems Development Life Cycle model that you chose for your analysis.

For example, if the model you follow has a Systems Initiation phase, you should explain to me how you would conduct the initial investigation. Who are the stakeholders that you would need to talk to? What information would you need to gather to establish the requirements of the project and how would you gather that information? What kind of feasibility study would you conduct and how would you do it? How would you conduct your cost-benefit analysis in this stage? What should be the end result of this stage?

You will have to identify the appropriate questions to ask yourself and to answer for each stage of your Systems Development Life Cycle, similar to what I have done for the Systems Initiation phase above. Part of this assignment is for you to understand and explain to me what needs to be accomplished in each phase and how that would specifically look for the Case Study below.

You must use your own general knowledge about organizations to make reasonable assumptions appropriate to the case study, since you will not be given every possible detail of the case. For example, who do you think the stakeholders would be? Think about the students, the faculty, the staff and administration of a typical university, etc., and identify all of the possible groups of stakeholders. You will have to think beyond the short description below and use your own general knowledge to complete the scenario and provide a full analysis of the Case Study.

2. Include details like specific questions and examples as indicated below.

Be as detailed as possible in your analysis. For example, if you are discussing how you would conduct a feasibility study, give a couple examples of specific questions you would ask. For another example, if you are describing how the Systems Design phase applies to the case study, include a couple examples of design items relevant to this case, such as an Entity Relationship Model for part of this system, or an example of a use case for your system, or the details of one or more classes you would create in this system. In this assignment, you are not required to create full design specifications, but you are encouraged to provide enough examples of design items to demonstrate your understanding of how you would approach the case study. For example, instead of delineating ALL classes you would need to create, choose one class and develop it as fully as you can, to illustrate that you understand the basics of creating an object class (with a class name, some class attributes, and some appropriate class methods).

***

Case Study

You are leading a team of software developers at a university. The university’s President has approached you about developing a new information system for tracking student course registrations. The system will need to contain information about students, faculty, and courses. Students should be able to use the system to browse course descriptions and the schedule of classes for each semester, add classes to their schedule, and drop classes from their schedule.

****

What are microexpressions? Can you be trained to recognize these? In what ways are microexpressions potentially useful?

2. A vector is an ordered collection of values in mathematics. An array is a very straightforward way to implement a vector on a computer. Two vectors are multiplied on an entry-by-entry basis, e.g. (1, 2, 3) * (4, 5, 6) = (4, 10, 18).
Write a program that include the following functions.
void multi_vec (int v1[], int v2[], int v3[], int n);
int comp_vec(int v1[], int v2[], int n);
The multi_vec function multiplies vectors v1 and v2 and stores the result in v3. n is the length of the vectors.
The comp_vec function compares v1 and v2, return 1 if vectors v1 and v2 are equal (their corresponding components are equal), and 0 otherwise. n is the length of the vectors.
In the main function, ask the user to enter the length of the vectors, declare two arrays with the length, read in the values for two vectors, and call the two functions to compute the multiplication and comparison of them. The main function should display the result.
Enter the length of the vectors: 5
Enter the first vector: 3 4 9 1 4
Enter the second vector: 5 7 2 6 8
Output:
The multiplication of the vectors is: 15 28 18 6 32
The vectors are not the same.