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 assignment 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:

• Write SQL queries to create tables
• Write SQL queries to create relationships among tables
• Identify indexes and create them in a database
• 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.

A. 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.

Use the attach document to complete this assignment.

1) Compute EQ based on taking 4 classes. Each class requires a term paper. Rather than start ‘1’ and finish, you decided to start all ‘4’ simultaneously. You finished ‘1’, and are 50% completed on paper #2, and 75% completed on papers #3 and #4. What is your EQ for all ‘4’ papers? Or, in other words, how many papers would you have completed if you had started only ‘1’ at a time? Show your work.

 

If you need to change your Turkish Airlines flight, there are a few options available to you depending on the type of ticket you purchased and the specific circumstances of your travel plans. If you booked your flight directly with Turkish Airlines Change Flight, you can make changes to your itinerary online through the Manage Booking section of the website. You will need to enter your reservation code and last name to access your booking and make changes.

 

Hello class,

AirAsia Group is an example of a company in the airline industry that has been struggling with cash flow issues in recent years. Because of the effect that the COVID-19 epidemic had on the aviation industry, the corporation declared a financial loss of RM 767.43 million (which is equivalent to around 170 million USD).The AirAsia Group has carried out a number of preventative actions. To begin, the corporation has been working to reduce expenses by, among other things, lowering staff pay, renegotiating contracts with vendors, and consolidating business processes. Second, in order to broaden its base of revenue, the corporation has been investigating potential new sources of income, such as the operation of cargo. Third, the corporation has been actively generating capital via a variety of channels, including the issuing of bonds and the sale of assets. Air Asia Group was also successful in obtaining a loan from the government of Malaysia in the amount of RM 300 million. Overall, the way that the AirAsia Group has taken to solve its issues with cash flow has been a mix of cost reduction, expanding into new income streams, and financing. The firm was able to successfully manage the adverse business climate brought on by the COVID-19 epidemic and enhance its cash flow situation as a result of the actions that were taken. However, the aviation industry is still dealing with substantial problems, and it will be essential for businesses such as AirAsia Group to continue to adapt to changing conditions and come up with innovative solutions if they want to continue being profitable and competitive.

-Gabe

Resources:

Reuters (2020). Malaysia’s AirAsia secures $72 mln loan from Sabah Development Bank. Retrieved from https://www.reuters.com/article/airasia-group-loan/malaysias-airasia-secures-72-mln-loan-from-sabah-development-bank-idUSL4N2HE35Z

Salim, S (2021) AirAsia X posts largest quarterly net loss, plans more job cuts. Retrieved from https://www.theedgemarkets.com/article/airasia-x-reports-rm567b-net-loss-quarter-ended-march-31-2021

Schurman, R (2023). AirAsia X continues to recover quarter by quarter. retrieved from https://airinsight.com/airasia-x-continues-to-recover-quarter-by-quarter/

  

Discussion Topic: Soap Note 3 “ASTHMA”  

Requirements

– The discussion must address the topic

– Rationale must be provided

– Use at least 600 words (no included 1st page or references in the 600 words)

– May use examples from your nursing practice

– Formatted and cited in current APA 7

– Use 3 academic sources, not older than 5 years. Not Websites are allowed.

– Plagiarism is NOT permitted

I have attached the SOAP note template, a sample, and the rubric.