TASK 2: Airline flight information Using domain and tuple relational calculus, find: 1. Find the eids of pilots certified for some Boeing aircraft. 2. Find the names of pilots certified for some Boeing aircraft. 3. Find the aids of all aircraft that can be used on non-stop flights from Paris to Vancouver. 4. Find the names of pilots who can operate planes with a range greater than 3,000 miles but are not certified on any Boeing aircraft. 5. Find the eids of employees who make the highest salary (multiple employees can have highest salary). Relation Flights Aircraft Certified Relational schema FLIGHTS(flno, from, to, distance, departs, arrives) AIRCRAFT (aid, aname, cruisingrange) CERTIFIED (#eid, #aid) Employees EMPLOYEES(eid, ename, salary)

2- Design a class diagram of a course registration system. Note: utilize various class relations: generalization, aggregation, composition, and association; the class diagram should include but not be limited to the following class names User, Student, Instructor, Admin, Course, LogonPage, AddPage, DropPage, ChangePage, PrintPage, QueryPage, CoursenfoDB, StudentInfoDB, InstructorinfoDB, AdmintnfoDB, and EntireDB.

Scenario – 2 Suppose that you are developing ERD about reality shows on TV. For each reality show, itsname, genre, basic_info and participants name. Any reality show has at least two or moreparticipants. Reality show may run for multiple days during the week. For each producer, thecompany name, company country is stored. A show is produced by exactly one producer. Andone producer produces exactly one show. For each television, its name, start year, head officeis stored.  A television may broadcast multiple shows. Each show is broadcasted by exactly onetelevision. For each user, his/her username, password, and age is stored. A user may ratemultiple shows, and a show may be rated by multiple users. Each rating has a score of 0 to 10.Every show comes with Advertisement. Advertisement may belong to Single or more shows.Every advertisement will have customer who will pay for different packages for advertisements.Advertisements may vary from Reality show. Task to do: i. Identify Entities…

SQL Help

Each publisher has a unique name; a mailing address and telephone number are also kept on each publisher. A publisher publishes one or more books; a book is published by exactly one publisher. A book is identified by its ISBN, and other attributes are title, price, and number of pages. Each book is written by one or more authors; an author writes one or more books, potentially for different publishers. Each author is uniquely described by an author ID, and we know each author’s name and address. Each author is paid a certain royalty rate on each book he or she authors, which potentially varies for each book and for each author. An author receives a separate royalty check for each book he or she writes. Each check is identified by its check number, and we also keep track of the date and amount of each check. As you develop the ERD for this problem, follow good data naming guidelines.

QUESTION 3 A functor is a function symbol that names the relationship, but the name can be anything as long as it's a valid identifier. True False

Databases: Regular entity type is transformed to a relation.

Create a database Entity and Relationship Diagram (ERD) for the following application (Submitted An image of the Diagram By using Any Application:The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community. Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of users Messager…

Which of the following is not a type of main UML diagram? What function do they serve?

Give proper view