Question: The relationship model in database Shipments S# P# QTY S1 P1 300 S2 P2 200 S3 P3 500 Parts P# PNAME COLOR WEIGHT CITY COUNTRY

The relationship model in database

Shipments

S#	P#	QTY
S1	P1	300
S2	P2	200
S3	P3	500

Parts
P#	PNAME	COLOR	WEIGHT	CITY	COUNTRY
P1	Nut	Red	12	London	Great Britain
P2	Bolt	Green	17	Paris	France
P3	Screw	Blue	17	Rome	Italy
P4	Screw	Red	14	London	Great Britain
P5	Cam	Blue	12	Paris	France

 a) Is it allowed to move the columns in Parts so that they are in a different order? Why or why not? b) Is it allowed to change the city for P1 from London to London, Athens? Why or why not not? c) Make an Equi Join on the above relationships and report the answer. d) The Relationship Parts is only in 2NF, why? e) Why is it not allowed for a primary key to be ZERO?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Investment Question Part 2 Part 1 The annual rate of return of a savings portfolio is assumed to be distributed N(9%,6%) An investor starts with a $1MM investment. The investor withdraws $10K per...

Modify given TABLE statement as follows. If the relation has one or more keys then modify the CREATE TABLE statement to declare one PRIMARY KEY and to declare all other keys as NOT NULL. For each...

Database and SQL assignment - I have provided my SPJ table, scroll down and use it for this problem. if exists(Select * from sys.databases where name = 'spjdatabase') Create DATABASE spjdatabase GO...

** Edited Q: "regarding tables can i we do in oracle sql??" Yes, Oracle SQL should work! Database management/SQL question (Scroll down for the SPJDatabase) if exists(Select * from sys.databases where...

SQL file Following is a database of suppliers (S), parts (P), and shipments (SP). S SNO SNAME STATUS CITY S1 Smith 20 London S2 Jones 10 Paris S3 Blake 30 Paris S4 Clark 20 London S5 Adams 30 Athens...

I need the SQL code for each question. Here's the database script. -- super simple distributor database -- S is a supplier table, based in a city having a rating -- P refers to Parts in distribution...

Need to write this query in PHP Language for a local host webpage. I have already created and loaded the table in my phpmyadmin. the tables and instructiions are below Prompt the user to input part...

Can I get just the written code for the question above, I do not need screenshot of answers Part 2 (50 marks) Consider the following Supplier-Part database with three tables Suppler, Part, keys are...

SQL : can I get help with these sql questions please? I just need rotten answers not screen Shots to prove Part 2 (50 marks) Consider the following Supplier-Part database with three tables Suppler,...

Write an SQL code for the following question: Get all combinations of supplier and part numbers together with their names, such that the suppliers are located in the same city and part number is P1...

Observe the following tables, what is the foreign key between supplier and shipment table? Supplier Table SNUM SNAME STATUS CITY S 1 Smith 2 0 London S 2 Jones 1 0 Paris S 3 Blake 3 0 Paris S 4 Clark...

The fixed budget for 20,800 units of production shows sales of $561,600; variable costs of $62,400; and fixed costs of $143,000. QS 21-4 (Algo) Flexible budget performance report LO P1 The company's...

8.32. In Fig. 8.6(a) if ; + 0, show that after the collision v= v; U2; and Vy Uzs = Vi- %3D %3D 8.33. A neutron of mass m, moving with velocity v collides with an atomic nucleus of mass in kinetic...

1 MultipleChoice 1 point A corporate bond comveys a small piece of ownership to the bond holder similar to a common stock True False

The preliminary 2 0 2 4 income statement of Alexian Systems, Incorporated, is presented below: ALEXIAN SYSTEMS, INCORPORATED Income Statement For the Year Ended December 3 1 , 2 0 2 4 ( $ in...

KEY QUESTION Columns 1 through 4 in the table below show the marginal utility, measured in utils, that Ricardo would get by purchasing various amounts of products A, B, C, and D. Column 5 shows the...

KEY QUESTION What is the formula for measuring the price elasticity of supply? Suppose the price of apples goes up from $20 to $22 a box. In direct response, Goldsboro Farms supplies 1200 boxes of...

How is the $10 best allocated between A and B? How much utility will the marginal dollar yield?