Write a query to find all the small capital cities

Assignment Help Database Management System

Reference no: EM132142326

Question:

Suppose a Prolog database exists that gives information about states and capital cities. Some cities are big, others small. Some states are eastern, others are western.

a. Write a query to find all the small capital cities

b. Write a query to find all the states with small capital cities.

c. Write a query to find all the eastern states with big capital cities.

d. Formulate a rule to define cosmopolitan cities as big capitals of western States.

e. Write a query to find all the cosmopolitan cities.

Reference no: EM132142326

Questions Cloud

Draw the er diagram using the concise form : For the HIGH SCHOOL entity, we will reDraw thcord the high school name and the location (meaning, city and state). Draw the ER diagram using the concise form.

Significant difference in the population : 1) When there is a significant difference in the population, but the research fails to find one ...this is what kind of error?

Write a program that gives the user a second chance : Suppose a program has a button with the caption "Quit" Suppose also that Name property of this button is btnQuit.

Hypothesis with a significance level : Conduct a hypothesis with a significance level of 0.05. What is the test statistic?

Write a query to find all the small capital cities : Write a query to find all the eastern states with big capital cities. Formulate a rule to define cosmopolitan cities as big capitals of western States.

Create a compareto method for this class : Suppose we have a Rectangle class that includes length and width attributes of type int, both set by the constructor.

Distinguish between the colors red and green : Nine percent of men and 0.25% of women cannot distinguish between the colors red and green. This is the type of color blindness that causes problems with traffi

Determine which activity should use which lecture hall : Suppose that we have a set of activities to schedule among a large number of lecture halls, where any activity can take place in any lecture hall.

How many bytes does the record take if : Suppose a record has the following fields in this order: A character string of length 15, an integer of 2 bytes, a SQL date, and a SQL time (no decimal point).

User Account

All Pages