At your first discussion, Director Coulson wants you to create 3 tables: A gadgets table, a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
At your first discussion, Director Coulson wants you to create 3 tables: A gadgets table, a student agent's table, and a gadget assignment table. A. Write SQL to create the table of "Gadgets" with the following columns: Gadget ID Gadget Name Whole number, allow 4 digits Text field, variable, maximum of 20 characters Gadget Cost Dollars and cents up to $5,000.00 maximum Gadget's power in Gigawatts Date Obtained Allow 2 digits and one decimal place Date B. Write SQL to create the table of "Gadget Assignments" with the following columns. Note: Like everything else in college, student agents have to pay for their own gadgets! Assignment Number Date the Gadget was assigned Gadget ID of the assigned Gadget Agent ID of the student agent whom the gadget is assigned to. The Name of the Senior Agent who assigned the gadget to the student agent. Gadget Sold Price Whole number, allow 5 digits Date Whole number, allow 4 digits Whole number allow 2 digits Variable but up to 50 characters Dollars and cents up to $10,000.00 maximum C. Write SQL to create the table of "Student Agents" with these columns: Student Agent ID Student Agent First Name Student Agent Last Name Student Agent Initials Students Agent Zip Code Student Agent Active? Whole number, allow 2 digits Up to 10 Characters Up to 25 Characters 3 characters exactly 5 characters exactly 1 character (Y/N) At your first discussion, Director Coulson wants you to create 3 tables: A gadgets table, a student agent's table, and a gadget assignment table. A. Write SQL to create the table of "Gadgets" with the following columns: Gadget ID Gadget Name Whole number, allow 4 digits Text field, variable, maximum of 20 characters Gadget Cost Dollars and cents up to $5,000.00 maximum Gadget's power in Gigawatts Date Obtained Allow 2 digits and one decimal place Date B. Write SQL to create the table of "Gadget Assignments" with the following columns. Note: Like everything else in college, student agents have to pay for their own gadgets! Assignment Number Date the Gadget was assigned Gadget ID of the assigned Gadget Agent ID of the student agent whom the gadget is assigned to. The Name of the Senior Agent who assigned the gadget to the student agent. Gadget Sold Price Whole number, allow 5 digits Date Whole number, allow 4 digits Whole number allow 2 digits Variable but up to 50 characters Dollars and cents up to $10,000.00 maximum C. Write SQL to create the table of "Student Agents" with these columns: Student Agent ID Student Agent First Name Student Agent Last Name Student Agent Initials Students Agent Zip Code Student Agent Active? Whole number, allow 2 digits Up to 10 Characters Up to 25 Characters 3 characters exactly 5 characters exactly 1 character (Y/N)
Expert Answer:
Answer rating: 100% (QA)
Exercise 1 A Create Table Gadgets GadgetID number4 NOT NU... View the full answer
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these economics questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
In a remote area of the American Midwest before the railroads arrived, cast iron cookstoves were much desired, but people lived far apart, roads were poor, and heavy stoves were expensive to...
-
The common stock of Fido Corporation was trading at $45 per share on October 15, 2010. A year later, on October 15, 2011, it was trading at $80 per share. On this date, Fidos board of directors...
-
A 20-year $1,000 par value bond has a 7% annual coupon. The bond is callable after the 10th year for a call premium of $1,025. If the bond is trading with a yield to call of 6.25%, what is the bonds...
-
Return to the facts of problem 30. Assume that Show Corporation is organized as an S corporation. In its second year of operations, Show has an operating loss of $40,000 and pays out $20,000 in...
-
Calculate the capacitance-to-neutral in F/m and the admittance-to-neutral in S/km for the single-phase line in Problem 4.8. Neglect the effect of the earth plane. Data From Problem 4.8:- A 60-Hz...
-
Rocky Mountain Corporation makes two types of hiking bootsXactive and the Pathbreaker. Data concerning these two product lines appear below: The company has a traditional costing system in which...
-
July3 Sold goods costing $9,000 to Gonzalez Company on account, $15,000, terms 5/10, n/30. The goods are shipped FOB Shipping Point, Freight Prepaid by Seller, $320. July9 Gonzalez Company returned...
-
David R. and Ella M. Cole (ages 39 and 38, respectively) are husband and wife who live at 1820 Elk Avenue, Denver, CO 80202. David is a self-employed consultant, specializing in retail management and...
-
Play Company acquired an 80% interest in Stop Company for $272,000 cash on January 1, 2016. Sunday had the following Balance Sheet on the date of acquisition: Stop Company Balance Sheet January 1,...
-
CONSIDER THE FOLLOWING INFORMATION FOR THE NEXT THREE QUESTIONS: You are given the following information about stocks A and B. 19. You have $20,000 to invest in stocks A and B. If you decide to...
-
As the world's leading free water refill app, mymizu connects people to 10,000+ water refill stations (water fountains and partner cafes, shops, hotels) across Japan and 200,000 globally. Using...
-
Thecurrent yieldandyield to maturity (YTM)are two important metrics for bond investors. The current yield of a bond is a measure of the bondholder's return if the bond is purchased and held for one...
-
dx et y = f(x) be the solution to the differential equation What is the approximation for f(0) obtained using Euler's method with 2 steps of equal length, d=3y-x with initial condition f(1) = 3....
-
Consider the vibrations of a vehicle traveling forward at a constant speed on a road. The sprung mass of the vehicle is 750 kg and has a radius of gyration of 69.3 cm. The centre of mass of the...
-
Give an example of functions f and g and a point x=a such that the limit of f as x approaches a exists, the limit of g as x approaches a exists, but the limit of the function f/g as x approaches a...
-
Draw and label the E and Z isomers for each of the following compounds: 1. CH3CH2CH==CHCH3 2. 3. 4. CH,CH2C CHCH2CH Cl CH3CH2CH2CH2 CH CH2CCCH2CI CHCH3 CH3 HOCH CH CCC CH O-CH C(CH
-
Consider the universal relation schema INVENTORY (Store#, Item, Vendor, Date, Cost, Units, Manager, Price, Sale, Size, Color, Location) and the constraint set F {fd1, fd2, fd3, fd4, fd5, fd6, fd7}...
-
The NCAA (National Collegiate Athletic Association) wants to develop a database to keep track of information about college basketball. Each university team belongs to only one conference (e.g., the...
-
Define the term referential integrity constraint. Why is referential integrity important? How is the term foreign key used in the context of referential integrity?
-
Referring to the information in Brief Exercise 17-45, prepare the journal entries in 2020 for CareMax Inc. assuming that the fair value of the vehicle is \(\$ 28,000\) and it has a useful life of 6...
-
The following separate scenarios relate to a 5-year lease, pertaining to equipment with a fair value of \(\$ 25,000\). Assume in all scenarios that payments are made at the beginning of the period....
-
On January 1, 2020, Alex Company signed a 5-year lease contract for equipment with Abel Company. The equipment had a normal selling price of \(\$ 55,000\) and an estimated useful life of 6 years....
Study smarter with the SolutionInn App