answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
earnstyle
1 month ago
10

Charlie has a large book collection. He was keeping track of it in a spreadsheet, but it has grown big enough that he wants to c

onvert it into a real database. Here is a sample from the spreadsheet: Author James Taylor Author Country England May Norton United States Titles JavaScript Essentials, South Tech Books, London, 2010, $14; HTML5 Exposed, Webby Books, London, 2012, $15.50 Big Data Big Promise, Data Press, San Francisco 2012, $25 Database Development for the Cloud, Data Press San Francisco, $20.35; Data Services, Future Tech Press, New York $12.95 Jessica Lewis United States Ques. 1. What are some of the potential problems with this layout if carried directly to the database? (Exam2.docx) Ques. 2. Create the Dependency Diagram and transform it into the highest normal form (Show various stages - INF, 2NF, 3NF). Be sure to show the primary keys, and various dependencies in each stage (Exam2.docx) Ques. 3. Create the final ER diagram that shows the database in the highest Normal Form. (Indicate PK, FK, data types). You can add additional attributes as needed. (Exam 2.docx) Ques. 4. Write a single script file (Label it as Exam2.sql) to create the tables and insert the sample data in Oracle. Confirm that the rows are created, and data is inserted. Use echo and spool to create an output file (Label it as Exam2_Output.txt)

Computers and Technology
1 answer:
Harlamova29_29 [938]1 month ago
3 0

Answer:

Review the explanation

Explanation:

Response 1) Keeping all data in a single row presents challenges; if one record in the sheet is deleted, all related records may also vanish unexpectedly. For instance, should the entry for author "James Taylor" be removed, all the books associated with him would get eliminated as well.

Response 2) In the first normal form (1NF), each row is supposed to have just one tuple, but in the case of the author "James Taylor," the title field contains two books, necessitating separation into distinct rows.

Response 3) The table shown in the image does not exhibit deletion anomalies; for the author "May Norton," if you erase this record, it will result only in the deletion of her sole book.

Thus, it’s essential to transition this table into the second normal form (2NF).

Create distinct tables for Authors and Books

Authors(Author Name, Author Country)

Books(Author Name, Book Title, Publisher, Publisher Location, Year, Price)

This cannot undergo further normalization.

You might be interested in
A regional trucking company landed a contract to supply products for a major retailer. To do this, it needs to hire an IT profes
zubka84 [953]
I believe the answers are F and A
.
8 0
13 days ago
Ishaan is confused between the terms webpage and website help him in understanding the difference between both​
maria [885]

Answer:

A webpage serves as a single page within a website, while a website encompasses a collection of such pages offering valuable information.

Explanation:

Please follow

7 0
20 days ago
Complete the function definition to output the hours given minutes. Output for sample program: 3.5
Harlamova29_29 [938]

#include <iostream>

using namespace std;


void OutputMinutesAsHours(double origMinutes) {

double hours = origMinutes / 60.0;

cout << hours;

}


int main() {

OutputMinutesAsHours(210.0); // This function will also be called with 3600.0 and 0.0.

cout << endl;

return 0;

}


The lines highlighted in bold perform the conversion from minutes to hours by dividing the input minutes by 60, since there are 60 minutes in one hour. The parameter origMinutes is a double, so the division uses 60.0 to keep consistent data types. Running this code with 210.0 will output 3.5.

4 0
1 month ago
The following is a string of ASCII characters whose bit patterns have been converted into hexadecimal for compactness: 73 F4 E5
Rzqust [907]

Answer:

a) Transforming each character into its binary equivalent:

73:

The digits are 7 and 3

7 in binary is: 111

3 in binary is: 11

Thus

73: 0_111_0011

Likewise

F4:

F stands for 15 and its binary is: 1111

4 in binary: 100

Consequently

F4:  1_111_0100

E5:

E corresponds to 14 and its binary form is: 1110

5 in binary: 101

Therefore

E5:  1_110_0101

76:

7 in binary: 111

6 in binary: 110

Hence

76:  0_111_0110

E5:

E has a binary representation of: 1110

5 in binary: 101

Consequently

E5:  1_110_0101

4A:

4 in binary: 100

A represents 10

A in binary form: 1010

Therefore

4A:  0_100_1010

EF:

E in binary is: 1110

F in binary is: 1111

Thus

EF: 1_110_1111

62:

6 in binary form: 110

2 in binary form: 10

Therefore

62:  0_110_0010

73:

The digits are 7 and 3

7 in binary is: 111

3 in binary is: 11

Thus

73: 0_111_0011

for 0_1110011: the decimal equivalent is: 115 which translates to s

for 1_1110100:  the decimal equivalent is: 116 which translates to t

for 1_1100101:  the decimal equivalent is: 101 which translates to e

for 0_1110110: the decimal equivalent is:  118 which translates to v

for 1_1100101:  the decimal equivalent is: 101 which translates to e

for 0_1001010: the decimal equivalent is:  74 which translates to j

for 1_1101111: the decimal equivalent is: 111 which translates to o

for 0_1100010:  the decimal equivalent is: 98 which translates to b

for 0_1110011: the decimal equivalent is:  115 which translates to s

Thus the decoded sequence is:  stevejobs

b) The parity being utilized is odd.

for 0_1110011:  There are 5 instances of 1s and the parity is 0 indicating it is odd.

for 1_1110100: There are 4 instances of 1s and the parity is 1 indicating it is odd.

Thus, we count the number of 1s and then verify if the parity is odd or even.

Likewise

for 1_1100101:  the parity is odd

for 0_1110110: the parity is odd

for 1_1100101:  the parity is odd

for 0_1001010: the parity is odd

for 1_1101111: the parity is odd

for 0_1100010: the parity is odd

for 0_1110011: the parity is odd

Therefore, the parity being used is odd.

5 0
17 days ago
Provide an example by creating a short story or explanation of an instance where availability would be broken.
Amiraneli [929]

Explanation:

Personal Insurance

Understanding workplace confidentiality: Key points

In professions where you advise clients or patients, safeguarding private and sensitive information is essential. But are you knowledgeable about what constitutes a confidentiality breach and how to handle it if it happens?

This passage provides insights into protecting confidential data and identifying breaches in various jobs, emphasizing the significance of confidentiality at work.

What does a breach of confidentiality entail?

Essentially, a breach occurs when information is shared with someone without the explicit consent of its owner. This refers to the failure to respect an individual's privacy or the trust they placed in you while sharing their information.

Why is maintaining confidentiality critical?

Safeguarding confidential information is crucial for those who access or handle such data at work. If confidentiality is compromised, it can jeopardize your professional reputation and relationships with current and future clients, which may lead to termination of contracts or legal consequences.

Therapist/patient confidentiality

Confidentiality for patients is especially vital for therapists and counselors. It plays an essential role in establishing proper boundaries, fostering a trusting therapeutic relationship.

Here are some examples of unintentional breaches of therapist/patient confidentiality:

Disclosing confidential client information to friends or family

Discussing confidential details in public spaces where others can overhear

Leaving computers with confidential information accessible to others

Continuing treatment for a client with known conflicts of interest (e.g., if they are acquainted with family or friends)

When individuals give permission to share information but without clarity, it may lead to misunderstandings and potential breaches (e.g., a patient may consent to share details with a teacher but not with their doctor).

7 0
1 month ago
Other questions:
  • Your computer science teacher asks you to sample a black and white image that is 4" x 6". How would you sample the image to prov
    8·1 answer
  • You want to register the domain name ABCcompany.org, but the registration service is not allowing you to do that. What's the mos
    10·1 answer
  • . Electricians will sometimes call ______ "disconnects" or a "disconnecting means."
    12·1 answer
  • When a CPU executes instructions as it converts input into output, it does so with
    12·1 answer
  • A retailer is able to track which products draw the most attention from its customers through the use of 5g-enabled motion senso
    5·1 answer
  • Determine the number of bytes necessary to store an uncompressed binary image of size 4000 × 3000 pixels
    11·1 answer
  • Initialize the list short_names with strings 'Gus', 'Bob', and 'Zoe'. Sample output for the givenprogram:Gus Bob Zoeshort_names
    13·1 answer
  • Which of the following is an absolute cell reference
    10·1 answer
  • The following code is intended to test if x is NOT less than 17. Fill in the correct symbol:
    14·2 answers
  • Allison wants to use equations to simplify the process of explaining something to the Sales team, but the default eq
    8·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!