The following table contains data about projects and the hours charged against them:
ProjectBilling:
ProjectNbr ProjectName EmployeeNbr EmployeeName JobClass HourlyRate HoursBilled
15 Evergreen 103 June Phillips SA-3 96.75 23.8
15 Evergreen 101 John Baker DD-5 105.00 19.4
15 Evergreen 105 Alice Miller DD-5 105.00 35.7
15 Evergreen 106 William Smithfield SA-2 62.50 12.6
18 Amber Wave 114 Anna Jones SA-1 55.00 23.8
18 Amber Wave 101 John Baker DD-5 105.00 24.6
18 Amber Wave 112 Brad White SA-3 96.75 45.3
22 Starlight 107 Terry Ray SA-2 62.50 32.4
22 Starlight 115 Peter Novak SA-3 96.75 44.0
22 Starlight 101 John Baker DD-5 105.00 64.7
22 Starlight 114 Anna Jones SA-1 55.00 48.4
22 Starlight 108 Susan Brown SA-2 62.50 23.6
(A) Convert the table to 3NF.
Answers
Answer:
The final tables in 3NF are as follows.
Project( ProjectNbr, ProjectName)
Employee( EmployeeNbr, EmployeeName, JobClass)
Job( JobClass, HourlyRate)
ProjectBilling( ProjectNbr, EmployeeNbr, HoursBilled)
Explanation:
The given table is given below.
ProjectBilling( ProjectNbr, ProjectName, EmployeeNbr, EmployeeName, JobClass, HourlyRate, HoursBilled)
ProjectNbr -> ProjectName
EmployeeNbr -> EmployeeName
JobClass -> HourlyRate
ProjectNbr, EmployeeNbr -> HoursBilled
1NF
1. All the fields in the given table contain only a single value. The table is in 1NF.
2NF
2. New tables are formed based on the given functional dependencies.
Project( ProjectNbr, ProjectName)
Employee( EmployeeNbr, EmployeeName)
Job( JobClass, HourlyRate)
ProjectBilling( ProjectNbr, EmployeeNbr, HoursBilled)
3. Every table is assigned a primary key which are as follows.
ProjectNbr is the primary key for Project table.
EmployeeNbr is the primary key for Project table.
JobClass is the primary key for Project table.
(ProjectNbr, EmployeeNbr) is the composite primary key for the ProjectBilling table.
4. The tables which are related to each other are linked via primary key and foreign key.
5. In the ProjectBilling table, the composite primary key, ProjectNbr, EmployeeNbr is composed of the primary keys of the Project and Employee tables, i.e., ProjectNbr and EmployeeNbr respectively.
6. Job table is related to Employee table. Hence, primary key of Job table, JobClass, is introduced as foreign key in Employee table.
Employee( EmployeeNbr, EmployeeName, JobClass)
7. Partial dependency arises when composite primary key exists and non-prime attributes (columns other than the primary key) depend on a part of the primary key, i.e., partial primary key.
In the ProjectBilling table, no partial dependency exists.
8. All the tables are in 2NF as given below.
Project( ProjectNbr, ProjectName)
Employee( EmployeeNbr, EmployeeName, JobClass)
Job( JobClass, HourlyRate)
ProjectBilling( ProjectNbr, EmployeeNbr, HoursBilled)
3NF
9. All the tables are in 2NF.
10. In every table, all non-prime attribute depend only on the primary key.
11. No transitive dependency exists, i.e., all non-prime attributes do not depend on other non-prime attributes.
12. Hence, all the conditions are satisfied and the tables are in 3NF.
Related Questions
quick topic
if i make severs out of Ps4's, and Xbox'es which server would be more likly to crash ?
explain give an example
Answers
Answer: Xbox because ps4 has more people on it.
Explanation: for example if I had 2 computer and 1 computer it will be easier to make servers on the one computer
You work as a software developer on an agile team your manager has decided that the team must work off the existing requirements documents what's one of the main challenges with this approach
Answers
One of the main challenges with this approach is option a: Agile teams embrace change, requirements documents are designed to limit conversation and flexibility.
What agile team means?An Agile team is known to be a kind of a cross-functional group that helps to create, test, and also deliver a kind of an increment of value in a short time in regards to business.
Hence, One of the main challenges with this approach is option a: Agile teams embrace change, requirements documents are designed to limit conversation and flexibility.
Learn more about software developer from
https://brainly.com/question/26135704
#SPJ1
See full question below
You work as a software developer in an agile team. Your manager has decided that the team must work off the existing requirements documents. What's one of the main challenges with this approach?
Select an answer:
Agile teams embrace change, requirements documents are designed to limit conversation and flexibility.
Agile teams only work off user story cards, so the team should copy the requirements onto cards.
If the project requirements are already created, then the product owner would have to leave the team.
Agile teams always write their own requirements documentation.
Answer this is it right here
Answers
In the program below, which two variables have the same scope?
def rhyme(word):
leftCharacter = word[0]
if leftCharacter != 'd':
return 'd' + word[1:]
else:
return 'f' + word[1:]
def poem():
print("Enter Q to quit.")
userWord = input("Enter a word: ")
while userWord != 'Q' and userWord != 'q':
rhymeWord = rhyme(userWord)
print(rhymeWord)
userWord = input("Enter a word: ")
# the main part of your program that calls the function
poem()
userWord and ____
Fill in the blank Answer options: poem, word, rhymeWord
Answers
Answer:
rhymeWord
Explanation:
correct answer edge 2020
# the main part of your program that calls the function poem() userWord and rhymeWord. Hence, option C is correct.
What is rhymeWord?Rhyming words all have the same last consonant. Simply put, it is the repetition of similar sounds. When two words have similar sounds, usually those that follow the final stressed syllable of each word, the words are said to rhyme. Cat-hat, rotten-forgotten, and heard-bird are some examples of words that rhyme; they all have similar sounds after the final stressed syllable.
If the last sounds of two or more words are the same or similar, then the words will rhyme. Some words that rhyme are goat, boat, moat, float, and coat. To determine whether two words rhyme, use your ears to listen while you speak the words. If two words have a similar or matching sound, they rhyme.
Thus, option C is correct.
For more information about rhymeWord, click here:
https://brainly.com/question/2398244
#SPJ2
What is the data type of the following variable?
name = "John Doe"
Answers
In computer programming, a variable is a storage location that holds a value or an identifier. A data type determines the type of data that can be stored in a variable. The data type of the following variable, name = "John Doe" is a string data type.
In programming, a string is a sequence of characters that is enclosed in quotes. The string data type can store any textual data such as names, words, or sentences.The string data type is used in programming languages such as Java, Python, C++, and many others. In Python, the string data type is denoted by enclosing the value in either single or double quotes.
For instance, "Hello World" and 'Hello World' are both strings.In conclusion, the data type of the variable name is string. When declaring variables in programming, it is important to assign them the correct data type, as it determines the operations that can be performed on them.
For more such questions on variable, click on:
https://brainly.com/question/28248724
#SPJ8
true or false. Two of the main differences between storage and memory is that storage is usually very expensive, but very fast to access.
Answers
Answer:
False. in fact, the two main differences would have to be that memory is violate, meaning that data is lost when the power is turned off and also memory is faster to access than storage.
-- of 5 points Question 3 1 try left While designing a new system, a company uncovered several processes that were quite rule-based, and that didn't really require staff to handle. The company chose to automate those processes using ___________________________ so they would no longer need to assign people to perform those tasks. A. code review B. robotic process automation C. application programming interfaces D. service-oriented architecture
Answers
Answer:
B. robotic process automation.
Explanation:
In the design of a new system, a company was able to uncover several processes that were typically rule-based, and which did not really require staff to control or handle.
Hence, the company chose to automate those processes using robotic process automation so they would no longer need to assign people to perform those tasks.
Imagine you're an Event Expert at SeatGeek. How would you respond to this customer?
* Hi SeatGeek, I went to go see a concert last night with my family, and the lead singer made several inappropriate comments throughout the show. There was no warning on your website that this show would not be child friendly, and I was FORCED to leave the show early because of the lead singer's behavior. I demand a refund in full, or else you can expect to hear from my attorney.
Best, Blake
Answers
By Imagining myself as an Event Expert at SeatGeek.I would respond to the customer by following below.
Dear Ronikha,
Thank you for reaching out to SeatGeek regarding your recent concert experience. We apologize for any inconvenience caused and understand your concerns regarding the lead singer's inappropriate comments during the show.
We strive to provide accurate and comprehensive event information to our customers, and we regret any oversight in this case.
SeatGeek acts as a ticket marketplace, facilitating the purchase of tickets from various sellers. While we make every effort to provide accurate event details, including any warnings or disclaimers provided by the event organizers, it is ultimately the responsibility of the event organizers to communicate the nature and content of their shows.
We recommend reaching out directly to the event organizers or the venue where the concert took place to express your concerns and seek a resolution.
They would be in the best position to address your experience and provide any applicable remedies.
Should you require any assistance in contacting the event organizers or obtaining their contact information, please let us know, and we will be happy to assist you further.
We appreciate your understanding and value your feedback as it helps us improve our services.
Best regards,
Vicky
Event Expert, SeatGeek
For more such questions Event,click on
https://brainly.com/question/30562157
#SPJ8
Which of the following gives one reason that explains why computers can solve logic problems?
O Computers can executes steps repeatedly without error.
O Computers follow instructions in a random sequence.
O Computers evaluate criteria without direction.
O Computers are a good option for solving all problems.
Answers
Answer:
Option A
Explanation:
Computers are able to solve the questions based on defined steps again and again without any error. They are even capable of executing ill defined steps correctly. Thus, they can solve the logical problem.
Option C is incorrect because computers can work only in a set direction. Option D is incorrect because here the question is specifically asking about logical problems and not all problems.
Option B is incorrect as sequences cannot be random.
Thus, option A is correct
Option A, Computers can execute steps repeatedly without error. Making them useful when it comes to solving logic problems.
--
B, C, and D are all incorrect because, well usually you don't want a random sequence, you don't want criteria without direction, and they are not the best option for solving all problems, there are alternatives that may be better based off situation.
Write a Java program for user defined exception that checks the internal and external marks; if the internal marks is greater than 30 it raises the exception “Internal mark exceeded”; if the external marks is greater than 70 it raises the exception and displays the message “External mark exceeded”, Create the above exception and test the exceptions.
Answers
Answer:
class MarksException extends Exception {
public MarksException(String message) {
super(message);
}
}
public class Main {
public static void main(String[] args) {
try {
checkMarks(35, 80);
} catch (MarksException e) {
System.out.println(e.getMessage());
}
}
public static void checkMarks(int internal, int external) throws MarksException {
if (internal > 30) {
throw new MarksException("Internal mark exceeded");
}
if (external > 70) {
throw new MarksException("External mark exceeded");
}
}
}
Explanation:
I need help with my C++ class I need to learn how to do a multiplication table but in reverse please any help will do
Answers
Answer:
You can use a nested for loop to create a multiplication table in reverse. Start with the outer loop and set it to iterate from 10 down to 1. Inside the loop, set up a second loop to iterate from 10 to 1 and print out the result of the multiplication each time.
#include <iostream>
using namespace std;
int main()
{
for (int i = 10; i >= 1; i--)
{
for (int j = 10; j >= 1; j--)
{
cout << i << " * " << j << " = " << i*j << endl;
}
}
return 0;
}
This code initialises two variables, num1 and num2, to 12 before iterating through each pair of numbers in reverse order using a while loop. It prints the outcome of multiplying num1 by num2 inside the loop.
How can I print a table from 1 to 10 in C?Algorithm. Step 1: Input a value to print a table dynamically. Read that number off the keyboard in step two. Step 3: Print number*I ten times using the for loop. / for(i=1; i=10; i++) Print num*I 10 times, with I ranging from 0 to 10.
#include
num1 = 12 int main();
num2 (int) = 12;
"Table of 12 in reverse," std::cout, followed by std::endl;
as long as (num1 >= 1) num1 * num2 std::endl; num2--; if (num2 == 0) num2 = 12; num1--; std::cout num1 " by " std::cout num2 " = "
returning 0;
To know more about code visit:-
https://brainly.com/question/17293834
#SPJ1
In which text compression technique is it invalid for a bit string that represents a character to be the prefix of any other string used to represent a character
Answers
Answer:
Huffman encoding
Explanation:
Huffman code can be regarded as optimal prefix code that is utilized in data compression It should be noted that Huffman encoding is text compression technique that it is invalid for a bit string that represents a character to be the prefix of any other string used to represent a character
Most of the devices on the network are connected to least two other nodes or processing
centers. Which type of network topology is being described?
bus
data
mesh
star
Answers
which is the best cpu
Answers
how mainy asia countries
?
Answers
According to the United Nations, there are 48 countries in Asia. However, this number may vary slightly due to political disputes or international recognition of certain regions.
Asia is the largest continent on Earth and is home to a diverse range of countries. The exact number of countries in Asia may vary depending on the definition used and geopolitical considerations.
Some of the well-known countries in Asia include China, India, Japan, South Korea, Indonesia, Vietnam, Thailand, Malaysia, Philippines, and Singapore. These countries, along with many others, contribute to the cultural, economic, and geopolitical landscape of the continent.
It's important to note that there are also territories, dependencies, and regions with varying degrees of autonomy in Asia. These may include regions like Hong Kong, Macau, Taiwan, Palestine, and other disputed territories. The political status of these regions can sometimes be complex and subject to different interpretations.
For more questions on Asia, click on:
https://brainly.com/question/30819846
#SPJ8
In cell F15 insert a function that will automatically display the word discontinue if the value in cell D15 is less than 1500, or the text No Change if the value in the cell D 15 is greater than or equal to 1500
Answers
The question demonstrates the illustration of the IF function in Microsoft Office Excel. The required IF function may be as follows:
IF(D15<1500, "Discontinue", "No Change"). What is the IF function in Excel?IF function in excel may be characterized as one of the most important functions that allow a user to make logical comparisons between a value and what you expect. So an IF statement can have two results that are as follows:
The first result is if your comparison is True, The second is if your comparison is False.Assuming that this is excel, you can locate the cell F15 and input the IF function. The formula for the IF function is IF(<condition>, <action if true>, <action if false>).
So before the 1st comma, we place the condition which is D15 < 1500. In the middle, before the 2nd comma, we place the text to display if D15 is less than 1500, which is "Discontinue". In the last place, we place the text to display if D15 is greater than or equal to 1500, which is "No Change"
To learn more about the IF function, refer to the link:
https://brainly.com/question/20497277
#SPJ1
If we ignore the audio data in a video file, a video file is just a collection of many individual frames (i.e., images). What is the main reason that a video file can achieve a much higher compression ratio than a file that contains a single image file?
Answers
Answer:
It is compressing the video file to make it smaller, but doing so without actually losing any quality
Explanation:
The main reason for a video file that can achieve a much higher compression ratio than a file that contains a single image file is that it can reduce the size of the file without affecting its quality.
What is Video compression?Video compression may be defined as a type of methodology that is significantly utilized in order to decline the size of a video file or alter the formatting of the video without compromising its quality.
The process of compression effectively permits you to reduce the number of storage resources that are needed to store videos and save costs. The importance of video compression includes smaller overall file sizes.
Therefore, the main reason for a video file that can achieve a much higher compression ratio than a file that contains a single image file is that it can reduce the size of the file without affecting its quality.
To learn more about Video compression, refer to the link:
https://brainly.com/question/28078112
#SPJ2
Which factor increases the risk of IS project delays?
A.
loss of hardware
B.
shortage of technical staff
C.
poor password practices
D.
loss of equipment
E.
environmental issue
Answers
Explanation:
It talks about how it is a delay and if you lose
something its going to delay whatever you are
list the field in the tcp header that are missing from udp header
Answers
Answer:
Sequence number, acknowledgement number, data offset, res, flags, window size, checksum, urgent pointer, options.
Explanation:
Check out the picture for details. "Missing" is not really the right term, since UDP has a different purpose than TCP. TCP needs these headers to form a connection oriented protocol, whereas UDP is a fire-and-forget type of packet transfer.
Any one know 23 24 25?
Answers
24- C
25- i’m not sure what it is but the definition to it is that it represents a range of text that has been deleted from a document. so which ever one is closest to it.
in the situation above, what ict trend andy used to connect with his friends and relatives
Answers
The ICT trend that Andy can use to connect with his friends and relatives such that they can maintain face-to-face communication is video Conferencing.
What are ICT trends?ICT trends refer to those innovations that allow us to communicate and interact with people on a wide scale. There are different situations that would require a person to use ICT trends for interactions.
If Andy has family and friends abroad and wants to keep in touch with them, video conferencing would give him the desired effect.
Learn more about ICT trends here:
https://brainly.com/question/13724249
#SPJ1
Upload your completed Lesson 8 Simulation here. 8.Organizing Content in Tables
Answers
Tables are an effective way to organize and present information in a structured and easy-to-read format.
How to explain the tableHere are some tips on how to effectively organize content in tables:
Determine the purpose of the table: Before creating a table, identify the purpose and the message you want to convey. Determine what kind of information you want to include in the table and how it can be best presented.
Use clear and concise headings: Use headings that are brief and clearly describe the content in each column or row. Headings help the reader to quickly identify the content and understand the structure of the table.
Keep the table simple and easy to read: Avoid using too many colors, borders, and font styles. Keep the table clean and simple, with clear lines and easy-to-read fonts.
Use consistent formatting: Ensure that the table formatting is consistent throughout the document. Use the same font size, style, and color for all the tables.
Group similar items together: Organize the table by grouping similar items together. This makes it easier for the reader to compare and analyze the information.
Use appropriate units of measure: Use appropriate units of measure for the data presented in the table. For example, use dollars for financial data, and use percentages for statistical data.
Use appropriate table type: Choose the appropriate table type to present the data. There are various types of tables such as comparison tables, frequency tables, and contingency tables, among others. Choose the type that best suits your data.
Consider accessibility: Ensure that the table is accessible to everyone, including those with visual impairments. Use alt text to describe the content of the table, and ensure that the table is navigable with a screen reader.
By following these tips, you can create effective and easy-to-read tables that convey the message you want to share with your readers.
Learn more about tables on;
https://brainly.com/question/28768000
#SPJ1
C++ program
Sort only the even elements of an array of integers in ascending order.
Answers
Answer: Here is one way you could write a C++ program to sort only the even elements of an array of integers in ascending order:
Explanation: Copy this Code
#include <iostream>
#include <algorithm>
using namespace std;
// Function to sort only the even elements of an array in ascending order
void sortEvenElements(int arr[], int n)
{
// create an auxiliary array to store only the even elements
int aux[n];
int j = 0;
// copy only the even elements from the original array to the auxiliary array
for (int i = 0; i < n; i++)
if (arr[i] % 2 == 0)
aux[j++] = arr[i];
// sort the auxiliary array using the STL sort function
sort(aux, aux + j);
// copy the sorted even elements back to the original array
j = 0;
for (int i = 0; i < n; i++)
if (arr[i] % 2 == 0)
arr[i] = aux[j++];
}
int main()
{
// test the sortEvenElements function
int arr[] = {5, 3, 2, 8, 1, 4};
int n = sizeof(arr) / sizeof(arr[0]);
sortEvenElements(arr, n);
// print the sorted array
for (int i = 0; i < n; i++)
cout << arr[i] << " ";
return 0;
}
Message queues allow for programs to synchronize their operations as well as transfer data. How much data can be sent in a single message using this mechanism
Answers
The maximum size of a message queue is 16384 bytes for Linux. For IBM WebSphere MQ. this value is 4 MB.
What is the message queue?The size of the message queue refers to the size (in bytes) that a message may have for a given operative system.
For example, the maximum value for IBM WebSphere MQ has been configured in four megabytes (4 MB).
In this case, when the message is higher than the set size (here 4 MB), then this message is returned.
Learn more about IBM here:
https://brainly.com/question/896257
Describe producing any four (4) methods output. o
Answers
Outputs are final products or services that are given to the client. These outputs come from the processes that are used to transform the inputs into a business.
Thus, In other words, the output method counts the accomplishments. An entity must first estimate how many outputs will be required to fulfill the contract before implementing the output method.
The entity then monitors the development of the contract by comparing the total estimated outputs required to fulfill the performance obligation with the outputs that have already been produced and Bussiness.
Quantifying outputs can be done in a variety of ways and is easily adaptable to a contract. Examples of production measures are finished tables, units delivered, homes built, or miles of track constructed and outputs.
Thus, Outputs are final products or services that are given to the client. These outputs come from the processes that are used to transform the inputs into a business.
Learn more about Bussiness, refer to the link:
https://brainly.com/question/30762888
#SPJ1
In which of the following situations must you stop for a school bus with flashing red lights?
None of the choices are correct.
on a highway that is divided into two separate roadways if you are on the SAME roadway as the school bus
you never have to stop for a school bus as long as you slow down and proceed with caution until you have completely passed it
on a highway that is divided into two separate roadways if you are on the OPPOSITE roadway as the school bus
Answers
The correct answer is:
on a highway that is divided into two separate roadways if you are on the OPPOSITE roadway as the school busWhat happens when a school bus is flashing red lightsWhen a school bus has its flashing red lights activated and the stop sign extended, it is indicating that students are either boarding or exiting the bus. In most jurisdictions, drivers are required to stop when they are on the opposite side of a divided highway from the school bus. This is to ensure the safety of the students crossing the road.
It is crucial to follow the specific laws and regulations of your local jurisdiction regarding school bus safety, as they may vary.
Learn more about school bus at
https://brainly.com/question/30615345
#SPJ1
The _______ allows you to quickly access features such as formatting, charts, tables, and totals
Answers
Answer:
The Quick Analysis toolbar allows you to quickly access features such as formatting, charts, tables, and totals
What is the purpose of this parallelogram shape in a flowchart?
Answers
Answer: Parallelogram A parallelogram is used to read data (input) or to print data (output). Rectangle A rectangle is used to show the processing that takes place in the flowchart. Diamond A diamond with two branches is used to show the decision making step in a flowchart.
HOPE THIS HELPS!!
Ok so im going to list my question and then the work so far.
Here is the code so far:(THE PROBLEM WITH THE CODE IS THAT THE IM SUPPOSE TO USE FIND() TO REPEATEDLY CHANGE THE OCCURRENCE OF THE WORD "MASK" TO THE WORD "HAT" IN THE FILE BUT AM KIND OF LOST HAVE BEEN WORKING ON THIS FOR A WEEK AND A HALF) ALSO I CAN NOT use the replace method, count method, split method, range() function, or lists in your solution. HAVE BEEN TRYING TO FIND SUM WAY TO USE FIND() BUT AM COMING UP SHORT
CODE:
#Get input file name
fileOne = input("Enter the input file name :")
#Get output file name
fileTwo = input("Enter the output file name :")
'''Get a string that will be searched in the source file
to locate all occurrences of the string'''
targetString = input("Enter the target string :")
'''Get a string that will replace each occurrence of the target
string in the source file'''
replacementString = input("Enter the replacement string :")
files =input("Enter a file with the word 'mask':")
#Open the input file in read mode
f1 = open(fileOne,"r+")
#Read the content of input file
content =f1.read()
#Replace the target string with the replacement string
content =f1.find('mask')
print(files[0:content]+ "hat"+ files[content +content:len(files)])
#Open the output file in write mode
f1 = open(fileTwo,"w")
'''Write the content after all of the occurrences of the target
string have been found and replaced by the replacement string'''
f1.close()
Answers
Answer:
qwerty
Explanation:
qwerty
The show port-security interface f0/1 command lists a port status of secure-down. Which one of the following answers must be true about this interface at this time?
a. The show interface status command lists the interface status as connected.
b. The show interface status command lists the interface status as err-disabled.
c. The show port-security interface command could list a mode of shutdown or restrict, but not protect.
d. The show port-security interface command could list a violation counter value of 10.
Answers
The status of the interface is listed as connected by the show interface status command. Currently, this interface's statement is accurate. The secure-down port status is provided via the show port-security.
With more data breaches occurring every year, the global cyber threat is still evolving quickly. According to a survey from RiskBased Security, data breaches have exposed an astonishing 7.9 billion records in just the first nine months of 2019. Constructors are absent from an interface. An interface contains only abstract methods. Instance fields are not permitted in interfaces. Only fields that are defined as static and final are permitted to exist in interfaces. Classes do not extend interfaces.
Learn more about port-security here
https://brainly.com/question/3669279
#SPJ4