See Harrington Figure 11 4 This Figure Shows The Final Sql Code For Implementing The Antique Opticals Database In Thi 1 (109.87 KiB) Viewed 24 times
See Harrington, Figure 11.4. This figure shows the final SQL code for implementing the Antique Opticals database. In this assignment, you are going to type some code in order to create the Antique Opticals tables in your username_db database on in-info-web4. The code you are to type is pictured below. given, all should be fine. The code given here has been edited to be MySQL compliant. Do not use the code from the that is example, MySQL requires more information when making a foreign key reference (the name of the column is repeated for tablex At least one of the tables is named using a MySQL reserved word (order), and you will generate an error message unless you surround it with backs when it (and backticks are not the same thing as single quotes): YES: 'order' NO: 'order' Some data types are named differently between flavors. The MySQL data type for NUMERIC is DECIMAL, for example. You can still type "numeric," but note that MYSQL will change it to its accepted name. In addition, MySQL will also replace BOOLEAN with TINYINT. Here is the code to enter into phpMyAdmin. The reason you get this as an image rather than as text is because you need to type this for practice.
a. Why is state in the distributor table given as CHAR(2) instead as VARCHAR? b. Why is selling_price in the order_line table DECIMAL(7,2) and not INT? c. Why is shipped in the order_line table BOOLEAN and not VARCHAR?
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!