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.
Concepts in Designing Database
A database design is the process of data organization based on a database model. The process deals with identifying what data should be stored in a database and how data elements relate to each other.
Entity Relationship Diagram
Complex real-world applications call for large volumes of data. Therefore, it is necessary to build a great database to store data safely and coherently. The ER data model aids in the process of database design. It helps outline the structure of an organization’s database by understanding the real-world interactions of objects related to the data. For example, if a school is tasked to store student information, then analyzing the correlation between the students, subjects, and teachers would help identify how the data needs to be stored.
Suppose a Prolog
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.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
