Normalise the following tables upto 3 NF. If it is Normalised already upto 3Nf explain why. Thank you? The data dictionary for items table:Data typeNumberDescriptionNumber of itemsDescribes the itemNumberNameQuantityItem NoNumber The data dictionary for order table:Data typeNumberNameDescriptionDescribes the orderOrder NonumberSum of the ordertotalDescribes theTotalNumberPayment typeVarcharpayment type ofthe order

Primary key for the relation = {Hairdresser ID, SkillID} The FDs on the relation are Hairdresser ID…

Answered: malised already upto

Engineering

Computer Science

malised already upto

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter5: Data Manipulation And Transaction Control

Section: Chapter Questions

Problem 5HOA: Add a new row in the ORDERS table with the following data: Order# = 1023 and Customer# = 1009....

See similar textbooks

Related questions

Q: What does MAC stand for? Describe in detail the three classes of MAC protocols ?

A: The Answer is

Q: Write a for loop that computes the sum of the integers from 1 to n. Get the value of n from the user...

A: Note - As you haven't specified particular programming language to write code in, I have written the...

Q: When does Oracle 12c construct an index automatically for a table?

A: Index Index on a table helps to access the data faster. Means, when search the data base table us...

Q: Write a program to create Teacher class and enter data through keyboard. Create another class Studen...

A: 1)Create class Teacher with two variables to store teacher name and subject teaches 2)In class Tea...

Q: Describe the underlying security issues described by Dan Kaminsky with the DNS protocol and give a b...

A: In a session at the Black Hat security conference in Las Vegas on Wednesday, Kaminsky detailed how t...

Q: Convert the following FP number ( 165.375 )10 into ()8 and fill in the blank with the final answe...

A: I Step 2, I have provided answer with brief explanation-----

Q: When would a system ever require the use of a page table to organize its data?

A: Specifically, a page table is a data structure used by a virtual memory system in a computer operati...

Q: SOLVE RECURRENCE USING THE TREE METHOD (NOT MASTER METHOD) : (I need to solve for " i " and show...

A: a) T(n) =2T(n/2)+C , The recurrence tree is

Q: #include using namespace std; int main() { int i, n; bool is_prime = true; cout > n; //...

A: Prime number is a number that is greater than 1 and divided by 1 or itself. In other words, prime nu...

Q: In a database, how can you utilize a sequence?

A: An object tied to a schema, a sequence creates a list of numbers. For a variety of applications, uni...

Q: Write a program in Java to take an infix mathematical expression. The expression will contain singl...

A: The infix and postfix expressions can have the following operators: '+', '-', '%','*', '/' and alpha...

Q: For the following scenario for a point of sale system, draw the following: • A mail order company th...

A: Answer:

Q: Is there a centralised control point for internet traffic? Is this correct or incorrect?

A: Introduction: The data on the internet is today controlled primarily on centralised, private servers...

Q: What are the Consequences of Virtual Reality Use?

A: Answer:

Q: write a note on artificial intelligence Application, and its Importance, Advantages and Disadvantage...

A: Introduction write a note on artificial intelligence Application, and its Importance, Advantages an...

Q: Write a class Point for 2D Cartesian co-ordinates. The class should have 2 fields: abscissa(x) anc o...

A: As mentioned in the question im writing a class point for 2D Cartesian co-ordinates

Q: 1 added to "4 times x"

A: Lets see the solution in the next steps

Q: Write a program that reads two integers as input, and outputs the first integer and subsequent incre...

A: The Answer is

Q: Paula's manufacturing builds products in batches of 50 pieces at a time. She is trying to determine ...

A: Paula's manufacturing builds products in batches of 50 pieces at a time. She is trying to determine ...

Q: se random-number generation to enable the knight to walk around the cheeseboard(in the legitimate L-...

A: Q: Display movement of knight using random number generation

Q: In the case of a data transfer from a big endian computer to a tiny endian machine, what kinds of is...

A: Introduction: Data transfer from a Big Endian to a Little Endian computer causes issues. The order o...

Q: Write a Visual Basic statement to change the text property of Form1 into "Midterm Exam"

A: The Text property of form is used to set the title for a form window. Given form instance is form1 W...

Q: The problem is from Introduction to Programming and Data Structures with C++, 4th edition (Algebra:...

A: Program Explanation: Declare the header files Define the main function Declare three variables a,...

Q: Nrite a C# console application named MaxMin that a and make sure it is valid (i.e., in between 0 and...

A: In this question, we are asked to write a C# program which calculates the maximum and minimum elemen...

Q: Which of the following are atomic operations? TestAndSet X++ Load R1, x V y = y + 2

A: We all know that when an atomic operation executes no other process can read through or modify the d...

Q: Bubble sort is a sorting algorithm that compares two adjacent elements and swaps them until they are...

A: Here, I have to write a bubble sort program for sorting 15 elements entered by the user.

Q: What gadget must be installed on a DSL \snetwork to protect the sound quality of \sphone calls?

A: What gadget must be installed on a DSL Isnetwork to protect the sound quality of sphone calls?

Q: imum number of program segmen

A: The maximum number of program segments that a COM program can have

Q: With the assistance of appropriate examples, discuss memory representations of 1D and 2D arrays

A: 1D Array Memory Representation of 1-D array: One-dimensional arrays are allocated in a contiguous...

Q: How does a nonblocking cache benefit the user?

A: Cache: The cache is a kind of memory or buffer located closer to the CPU. The cache's primary role i...

Q: describe the input

A: Introduction: Data entered into or received by a computer is referred to as an input. A user hitting...

Q: 3. Display the sum of 28 + 2, using two variables: x and y. int y = 2; System.out.println (x + y); %...

A: Answer - int x = 28;

Q: Hello therei I am a robot that was made to read and analyze numbers of all sorts. Ive been doing sim...

A: PROGRAM INTRODUCTION: Include the required header files. Declare the required variables. Take the s...

Q: t do you f

A: given - Which of the measurements of development do you find logical and acceptable?

Q: What are the benefits of firewalls?

A: Introduction: You may already be engaging in a number of safe computer and internet usage behaviours...

Q: When should you opt for manual testing over automation testing?

A: Solution:

Q: 1.) Show that the premises "If you send me an email message, then I will finish writing the program,...

A: I have written the solution in next step.

Q: Write a program to find the area of a rectangle, square and triangle using abstract class.

A: PROGRAM INTRODUCTION: Import the required libraries. Start the definition of an abstract class that...

Q: In rate instance inconsistent formulae within a range are necessary

A: Answer: False

Q: The decimal value -19.625 is equivalent to the IEEE single-precision representation (in hexadecimal ...

A: The decimal numbers are the base 10 numbers , the binary numbers are the base 2 numbers , the hexade...

Q: Calculate 2039 + 978 using 8-4-2-1 BCD

A: BCD Addition Given Below :

Q: 3. Let's assume you have a dataset as given below. Perform second order Lagrange interpolation and N...

A: Newton Interpolation polynomial x 1 1.3 1.6 1.9 2.2 f(x) 0.1411 -0.6878 -0.9962 -0.5507 0.3115 ...

Q: In what way does effective access time (EAT) differ from other types of time?

A: Each working framework has its own strategies for putting away page tables. Mostly apportion a page ...

Q: You have been hired by a local organic sod company to write coverage calculator for their website. O...

A: PROGRAM INTRODUCTION: Take the length from the user. Take the width from the user. Calculate the ar...

Q: Analyze the way CPU registers are implemented in terms of logic gates

A: A CPU register is simply a very quick memory. You can implement memory in terms of logic gates -in f...

Q: Could someone give me an example of how to design a UML/class diagram for a Python program? Mainly j...

A: UML class diagram: In the project tool window, right-click an item for which you want to create a di...

Q: Write a Java program to print the content of linked list using the Iterator object.

A: Required:- Write a Java program to print the content of the linked list using the Iterator Object. A...

Q: Sample 1.1) Use Karnaugh Map to simplify following expression. 1- xyzt + x yzt + x y zt + xyzt + xy ...

A: K map is a graphical method to solve Boolean expression.

Question

Normalise the following tables upto 3 NF. If it is Normalised already upto 3Nf explain why. Thank you?

The data dictionary for items table:
Data type
Number
Description
Number of items
Describes the item
Number
Name
Quantity
Item No
Number

The data dictionary for order table:
Data type
Number
Name
Description
Describes the order
Order No
number
Sum of the order
total
Describes the
Total
Number
Payment type
Varchar
payment type of
the order

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Create a table named BOOK_STORES to include the columns listed in the following chart.
Attempt to view the structure of the HOMEWORK13 view.
Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The table name should be EMPLOYEES. The Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldn’t be padded if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five-digit number. Use column sizes you consider suitable for the Firstname and Lastname columns.
Add a new row in the ORDERS table with the following data: Order# = 1023 and Customer# = 1009. Describe the error raised and what caused the error.
Refer to the film and inventory tables of the Sakila database. The tables in this lab have the same columns and data types but fewer rows. Write a query that lists the titles of films with the fewest rows in the inventory table. This query requires a subquery that computes the minimum of counts by film_id: SELECT MIN(count_film_id) FROM ( SELECT COUNT(film_id) AS count_film_id FROM inventory GROUP BY film_id ) AS temp_table; This subquery is provided in the template.
A data dictionary should have a full list of column names along with full description of each column, what the abbreviations within the columns stand for, the data type of each column. True False
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be ≥ 10.0 and ≤ 20.0 BirthDate - date, must be ≥ Jan 1, 2015
Q. A table is a collection of related ______________ and it consists of _________ and _____.
The Horse table has the following columns: ID - integer, auto increment, primary key registered name - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be between 10.0 and 20.0 BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: RegisteredName Breed Height BirthDate Babe Quarter Horse 15.3 2015-02-10 Independence Holsteiner 16.0 2011-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be between 10.0 and 20.0 BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: RegisteredName Breed Height BirthDate Babe Quarter Horse 15.3 2015-02-10 Independence Holsteiner 16.0 2017-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12 Notes: Your SQL code does not display any results in Develop mode. Use Submit mode to test your code. In another lab that creates the Horse table, RegisteredName is NOT NULL. In this l
select * from cast where cast_id=162652763; Use explain to display the query plan without creating any index. Now create an index to speed up the query. Use explain and timer to show the improvement.
Textbook: Digital Systems Chapter 8 Question/Problem 44 I'm not sure if I'm running the correct Query for this problem. The question is: "Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)" I ran this query without any errors: CREATE TRIGGER trg_char_hours AFTER INSERT ON CHARTER FOR EACH ROW UPDATE AIRCRAFT SET AC_TTAF = AC_TTAF + NEW.CHAR_HOURS_FLOWN, AC_TTEL = AC_TTEL + NEW.CHAR_HOURS_FLOWN, AC_TTER = AC_TTER + NEW.CHAR_HOURS_FLOWN WHERE AIRCRAFT.AC_NUMBER = NEW.AC_NUMBER; But the answer is still incorrect because the last row doesn't have the expected values. I'm not sure why the test query would delete any row with a CHAR_TRIP ABOVE 10018. I attached a screen of the output I'm getting: I saw in another answer this:…

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS