Write sql queries to create relationships among tables

Assignment Help Computer Engineering

Reference no: EM133473267

Homework: Data Programming

This is a Database Programming course. This course covers advanced topics in databases. It starts by reviewing basic knowledge on databases and ends with advanced database concepts like security.

In this project, you will use the knowledge you acquired throughout the course to build a simple database and query it to extract information from it. You will create tables and relationships among them, in addition to the necessary keys and indexes. The next step will be to populate the database with suitable data. Populating the tables with sufficient and appropriate example data is an important step in testing and validating your design. When your database is ready, you will write SQL queries to retrieve information.

Note: This homework was created with MySQL in mind. Therefore, dates, numbers, etc. have been set up with that tool in mind.

Upon completion of this project, you will be able to:

Question 1. Write SQL queries to create tables
Question 2. Write SQL queries to create relationships among tables
Question 3. Identify indexes and create them in a database
Question 4. Write queries to extract important information from a database

Prompt

In this project you will build a database for a public library. This database is aimed to collect and analyze information about the clients' reading interests. The project concentrates only on books and the clients' interests in books. The analyses that will result from this project will be used by the library's management to decide on the future purchasing policy.

Question: Write the SQL statements in order to create the tables for the database. Use the Entity Relationship Diagram (ERD) of the database shown in Figure 1. For simplicity, we are assuming in this project that a book cannot be written by more than one author. You need to create the tables as well as the required constraints, including the keys (primary and foreign), and the relationships between table.

Reference no: EM133473267

Questions Cloud

Instant messaging or use of social networks in business : Research the use of email, voicemail, instant messaging or the use of social networks in business.

What are the main components of a healthy lifestyle : What are the main components of a healthy lifestyle?

Bad news messages : As an employee at BUSCOM, you and your team have been planning a presentation for your client for the last few weeks.

Discuss the availability and cost of capital in saudi arabia : Discuss the availability and cost of capital in Saudi Arabia, your discussion should explain the effect of productions' diversification on the availability

Write sql queries to create relationships among tables : Write SQL queries to create tables. Write SQL queries to create relationships among tables. Write queries to extract important information from a database.

What strengths does servant leadership offer that can guide : what strengths does servant leadership offer that can guide an organization? - How do you perceive the level of devotion that this leadership theory

Modes of transportation would they most likely use : What mode or modes of transportation would they most likely use? Draw on Rawls, be specific, and speculate with an imagination informed by the historical record

Responsibilities of the director of adult prisons : What are the duties and responsibilities of the Director of Adult Prisons?

Discuss relationship between policy and clinical practice : Discuss the relationship between policy and clinical practice? Can you think of an example of how this has impacted on Advanced Nursing Practice.

User Account

All Pages