Database/SQL Portion

 Please respond to the following questions and problems.

1. Describe in your own words the significance and importance of relationships in a relational database. You may use an example to illustrate your discussion.
2. Why is the study of database technology important for business professionals?
3. Define the term referential integrity constraint. Please provide an example of a referential integrity constraint to illustrate your definition.
4. Please indicate the SQL statement for the each of the following queries.
5. Provide a list of all Customer first name, last name, and phone number for customers whose boats are over 32 feet in length. List should be sorted alphabetically by last name, first name.
6. Provide a list of all Boat name sorted by size from smallest to largest.
7. Provide a list of the possible boat lengths in the marina. A length should appear only once.
8. Provide a list of the possible boat models in the marina. A model should appear only once.
9. Provide a list of all customer IDs from Washington State.
10. Database/SQL Portion
    1. The significance and importance of relationships in a relational database Relationships are important components of the database; they ensure the data makes sense as they sum up various components of the data. It is through relationships that an individual is able to make comparisons and contrasts, while further connecting on the meaning that the database hopes to raise. A simple example of such relationship in databases is when organizations identify data of their customers and divide it in various categories such as their age, regions, dates when they joined the organization and any other aspect that an organization sees fit to be on the database.
    2. Why is the study of database technology important for business professionals?

    The study of databases for business professionals is an important aspect as it allows them to categorize large sums of data into a simple outline or sheets. Such simplification makes it easy to monitor new upcoming needs and serve a huge number of people at a specific time. It also makes aspects such as communication easy as all the communication info that appears is safely kept on the database. Databases are also the basis for making decisions in an organization as they guide the professionals on the product trends of their customers.

    3. Referential integrity constraint

    Referential integrity constraint is a concept applied in relational databases with the aim of ensuring consistency on columns and rows. It may be defines as a similar association of two or more entities. A good example of the concept is when a reference of a book adopts two entities, the information about the author of the book and the publisher info.

    4. Please indicate the SQL statement for the each of the following queries.
    5. Provide a list of all Customer first name, last name, and phone number for customers whose boats are over 32 feet in length. List should be sorted alphabetically by last name, first name.

    SQL statement; first_name,last_name,phone_number from customer where boat_length>=32 0rder by last_name,first_name

    1. Provide a list of all Boat name sorted by size from smallest to largest.

    SQL statement; Select boat_name from customer order by size desc

    1. Provide a list of the possible boat lengths in the marina. A length should appear only once.

    SQL statement; select boat_length from customer group by boat_length

    1. Provide a list of the possible boat models in the marina. A model should appear only once.

    SQL statement; select model from customer where town=marina group by model

    1. Provide a list of all customer IDs from Washington State.

    SQL statement; select customer_id from customer where state=’Washington’