Case description: COUNTRYLANGUAGE PK Language CHAR(30) O FK Country Code CHAR(3) IsOfficial Percentage CITY ENUM ('T','F')...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Case description: COUNTRYLANGUAGE PK Language CHAR(30) O FK Country Code CHAR(3) IsOfficial Percentage CITY ENUM ('T','F') Decimal (4,1) PK ID INT FK Country Code CHAR(3) Name CHAR(35) District CHAR(20) Population INT JPK # ++ Code Name Continent Region SurfaceArea IndepYear Population LifeExpectancy COUNTRY CHAR(3) CHAR(55) enum(Asia', 'Europe', 'North America', 'Africa', 'Oceania', 'Antarctica', 'South America') 4. Create a User that can insert data to the country table (User2) 5. Create a user that can insert data into City table. (User3) 6. Show all created users and their privileges. (a screenshot) CHAR(26) Decimal (10,2) Smallint int Decimal (3,1) 1. Use MYSQL to Implement the above database 2. Show the steps of your implementation with justifications 3. Create a User (User1) that can add, modify, and insert data to the database. What to submit: 1. A word/pdf file that includes the following: a. Cover page (course code, course name, group number, students name, students ID) b. Details steps of your implementation procedure with justifications 2. A screen shot from MYSQL Workbench showing the database name and all related tables Case description: COUNTRYLANGUAGE PK Language CHAR(30) O FK Country Code CHAR(3) IsOfficial Percentage CITY ENUM ('T','F') Decimal (4,1) PK ID INT FK Country Code CHAR(3) Name CHAR(35) District CHAR(20) Population INT JPK # ++ Code Name Continent Region SurfaceArea IndepYear Population LifeExpectancy COUNTRY CHAR(3) CHAR(55) enum(Asia', 'Europe', 'North America', 'Africa', 'Oceania', 'Antarctica', 'South America') 4. Create a User that can insert data to the country table (User2) 5. Create a user that can insert data into City table. (User3) 6. Show all created users and their privileges. (a screenshot) CHAR(26) Decimal (10,2) Smallint int Decimal (3,1) 1. Use MYSQL to Implement the above database 2. Show the steps of your implementation with justifications 3. Create a User (User1) that can add, modify, and insert data to the database. What to submit: 1. A word/pdf file that includes the following: a. Cover page (course code, course name, group number, students name, students ID) b. Details steps of your implementation procedure with justifications 2. A screen shot from MYSQL Workbench showing the database name and all related tables
Expert Answer:
Related Book For
Essentials of Database Management
ISBN: 978-0133405682
1st edition
Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman
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.
-
QUIZ... Let D be a poset and let f : D D be a monotone function. (i) Give the definition of the least pre-fixed point, fix (f), of f. Show that fix (f) is a fixed point of f. [5 marks] (ii) Show that...
-
When something burns, a. it combines with phlogiston b. it gives off phlogiston c. it combines with oxygen d. it gives off oxygen
-
If the total cost function for a product is C(x) = 100(0.02x+4)3 dollars, where x represents the number of hundreds of units produced, producing how many units will minimize average cost? Find the...
-
The following data relate to notes receivable and interest for Sciatic Co., a financial services company. (All notes are dated as of the day they are received.) Mar. 3. Received a $14,000, 9%, 60-day...
-
As the owner of a landmark Chicago skyscraper, you decide to purchase insurance that will pay $1 billion in the event the building is destroyed by terrorists. Suppose the likelihood of such a loss is...
-
Shi Importers balance sheet shows $300 million in debt, $50 million in preferred stock, and $250 million in total common equity. Shis tax rate is 40%, rd = 6%, rps = 5.8%, and rs = 12%. If Shi has a...
-
12. "New competition is not between what companies produce in their factories, but between what they add to their factory output in the form of packaging, services, advertising, customer advice,...
-
After the success of the company's first two months, Santana Rey continues to operate Business Solutions. (Transactions for the first two months are described in the Chapter 2 serial problem.) The...
-
What is one reason to plan for retirement now? there is no reason to plan now, it's still a long time from now inflation erodes purchasing power in the future if you plan later you will still have...
-
The United States has minimum wage laws that prevent businesses from paying extremely low wages. For the most part, businesses are legally allowed to pay employees whatever they want as long as it is...
-
Suppose the size of a factory is fixed at K while labour input L is variable in the short run such that the total product curve has the "half-bell" shape like the example used in class. Use separate...
-
2. There are two kinds of people, who are those with college degrees and those without college degrees. Assume that they are all white-collar workers. The wage status is described in Table 1. Table...
-
What are the 10 leadership styles? construct open-ended questions for an executive, the questions should be best suited for each of the 10 leadership styles, for a total of 30 questions. Describe why...
-
In the estimation of international trade's casual effect on country's income, InYa+BT+yWi+i, = where Y; denotes income per person, T; denotes international trade, W; denotes within-country trade and...
-
Write on line to declare 1204-Bytes words, starting at memory location with offset 1200H, all initialized to 0, and name it DATA A BI !!!
-
Complete the equations for the following equilibria and calculate Keq where the Keq expression includes [HO]. Be sure to enter Keq in proper scientific notation. (a) ammonia (acting as a base) reacts...
-
Can an outer join be easily implemented when joining more than two tables? Why or why not?
-
For each customer, list the CustomerID and the total number of orders placed in 2010.
-
Transform the relational schema developed in Problem and Exercise 9 into an EER diagram. State any assumptions that you have made.
-
Prove that the boosted right-handed spinor \(\psi_{\mathrm{R}}(\boldsymbol{p})\) is related to the corresponding rest spinor by Eq. (14.21).
-
Use the \(\gamma\)-matrices in the Weyl representation to show that the Dirac equation (14.31) is equivalent to Eq. (14.25). Data from Eq. 14.31 Data from Eq. 14.25 (y"Pu-m)(p) = (iy" - m)(p) = 0
-
Prove the identity \((\sigma \cdot \boldsymbol{p})^{2}=\mathrm{I}^{(2)} p^{2}\), where \(\sigma=\left(\sigma_{1}, \sigma_{2}, \sigma_{3} ight)\) are the Pauli matrices, \(\boldsymbol{p}\) is the...
Study smarter with the SolutionInn App