At your first discussion, Director Coulson wants you to create 3 tables: A gadgets table, a...

  

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)

Answer rating: 100% (QA)

Exercise 1 A Create Table Gadgets GadgetID number4 NOT NU... View the full answer