Using the World database, insert the Filipino language as an unofficial language for Australia and Oceania (AUS). Approximately 11.8% of people speak Filipino. World Table RelationshipscountryCode CHAR(3)Name CHAR(52)citycountrylanguageContinent ENUM(...)ID INTCountryCode CHAR(3) (FK)Name CHAR(35)Region CHAR(26)Language CHAR(30)SurfaceArea FLOAT(10,2)CountryCode CHAR(3) (FK)IsOfficial ENUM('T', 'F')District CHAR(20)IndepYear SMALLINTPercentage FLOAT(4,1)Population INTPopulation INTLifeExpectancy FLOAT(3,1)GNP FLOAT(10,2)GNPOID FLOAT(10,2)LocalName CHAR(45)GovernmentForm CHAR(45)HeadOfState CHAR(60)Capital INTCode2 CHAR(2)

The query is given in next step with explanation

Answered: Using the World database, insert the…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Using the World database, insert the Filipino language as an unofficial language for Australia and Oceania (AUS).
Approximately 11.8% of people speak Filipino.

World Table Relationships
country
Code CHAR(3)
Name CHAR(52)
city
countrylanguage
Continent ENUM(...)
ID INT
CountryCode CHAR(3) (FK)
Name CHAR(35)
Region CHAR(26)
Language CHAR(30)
SurfaceArea FLOAT(10,2)
CountryCode CHAR(3) (FK)
IsOfficial ENUM('T', 'F')
District CHAR(20)
IndepYear SMALLINT
Percentage FLOAT(4,1)
Population INT
Population INT
LifeExpectancy FLOAT(3,1)
GNP FLOAT(10,2)
GNPOID FLOAT(10,2)
LocalName CHAR(45)
GovernmentForm CHAR(45)
HeadOfState CHAR(60)
Capital INT
Code2 CHAR(2)

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions