With the schema described, can a user check out more than 1 copy of a specific...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
With the schema described, can a user check out more than 1 copy of a specific book (unique ISBN)? Describe why you answered yes or no in 2 or 3 sentences. Schema CREATE TABLE equivalents: CREATE TABLE Book ( ); isbn INTEGER PRIMARY KEY, title VARCHAR, genre VARCHAR, format VARCHAR CREATE TABLE LibUser ); id INTEGER PRIMARY KEY, fullname VARCHAR, debt FLOAT CREATE TABLE Inventory ( ); libbranch VARCHAR NOT NULL, isbn INTEGER NOT NULL REFERENCES Book, available INTEGER, PRIMARY KEY (libbranch, isbn) CREATE TABLE Checkout ( uid INTEGER NOT NULL, isbn INTEGER NOT NULL REFERENCES Book, timeout INTEGER, FOREIGN KEY (uid) REFERENCES LibUser ON DELETE CASCADE, PRIMARY KEY (uid, isbn) ); With the schema described, can a user check out more than 1 copy of a specific book (unique ISBN)? Describe why you answered yes or no in 2 or 3 sentences. Schema CREATE TABLE equivalents: CREATE TABLE Book ( ); isbn INTEGER PRIMARY KEY, title VARCHAR, genre VARCHAR, format VARCHAR CREATE TABLE LibUser ); id INTEGER PRIMARY KEY, fullname VARCHAR, debt FLOAT CREATE TABLE Inventory ( ); libbranch VARCHAR NOT NULL, isbn INTEGER NOT NULL REFERENCES Book, available INTEGER, PRIMARY KEY (libbranch, isbn) CREATE TABLE Checkout ( uid INTEGER NOT NULL, isbn INTEGER NOT NULL REFERENCES Book, timeout INTEGER, FOREIGN KEY (uid) REFERENCES LibUser ON DELETE CASCADE, PRIMARY KEY (uid, isbn) );
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
Design a Java class that represents a cache with a fixed size. It should support operations like add, retrieve, and remove, and it should evict the least recently used item when it reaches capacity.
-
Define the contextual-equivalence relation ` M =ctx M0 : for pairs of PCF terms M, M0 , PCF types , and PCF type environments . [3 marks] (ii) For PCF terms M and N with respective typings ` M : and...
-
In Problems 1158, perform the indicated operation, and write each expression in the standard form a + bi. 3i(-3 + 4i)
-
The article "Statistical Design and Analysis of Qualification Test Program for a Small Rocket Engine" (Industrial Quality Control, 1964: 14-18) presents data from an experiment to assess the effects...
-
During the first month of operation, Graham Expeditions recorded the following transactions. Describe what has happened in each of the transactions (a) through (k). J. D. Rakes, Capital J.D. Rakes,...
-
Discuss the ways in which a salesperson can attempt to identify buyer needs.
-
As part of the year-end accounting process and review of operating policies, Cullen Co. is considering a change in the accounting for its equipment from the straightline method to an accelerated...
-
The fully-loaded tractor-trailer drives up a 3% incline at a steady speed of 70 km/h (45 mph). The frontal area of the tractor-trailer is 2.59 m (102 in.) wide and 4.11 m (13.5 ft) high, and it is...
-
Martin Moreno is 42 years old, single, and works as a designer for a major architectural firm. He is well paid and over time has built up a sizable portfolio of investments. He considers himself an...
-
Simplify the following radical expression. F xy 16 a.) xy 4 b.) 4xy c.) 4xy d.) yx 4 SUBMIT MY ANSWER
-
Waterway Company manufactures two products, Mini A and Maxi B. Waterway's overhead costs consist of setting up machines- $870000; machining- $2040000; and inspecting- $610000. Information on the two...
-
The following are the transactions of Spotlighter, Incorporated, for the month of January. a. Borrowed $3,940 from a local bank on a note due in six months. b. Received $4,630 cash from investors and...
-
Beginning work-in-process inventory is $188,000, ending work-in-process inventory is $220,000, cost of goods manufactured is $850,000, and direct materials used are $194,000. What are the conversion...
-
An idea that vertical spring mass system oscillates with a period of 1.6 second when the mass used is 2.00 kg. how much elastic potential energy is stored in the spring when the mass is at its...
-
A bus travels 280 km South along a straight path with an average velocity of 88 km/hr to the south. The bus stops for 24 min. Then, it travels 210 km south with an average velocity of 75 km/h to the...
-
To analyze a rod assembly in three-dimensional space and determine the support reactions by using the equations of equilibrium for a rigid body. The rod assembly shown has smooth journal bearings at...
-
Which of the companies has the lowest accounts receivable turnover in the year 20X2? a. Company A. b. Company B. c. Company C. d. CompanyD. 20X1 20X2 Credit Sales Average Receivables Balance $1.0...
-
Describe the difference between communication and effective communication. How can a sender verify that a communication was effective? How can a receiver verify that a communication was effective?
-
List the changes that occur as an organization grows in size. List the changes that occur as an organization ages over time. Are the two lists the same? Explain any differences you find.
-
How might a SWOT analysis have helped Electronic Arts assess its slippage in the videogame market?
-
What part should the sales function play when drawing up a detailed 12 months operational marketing plan for EMA?
-
Suggest a general outline marketing planning strategy for 12 months ahead for Graham Keddie.
-
Explain the differences between marketing strategies and sales strategies.
Study smarter with the SolutionInn App