1. Consider the following schema:PlayerplvId plyNameHilalTarekSportspld1Record#plyId#evCode placespNameFootballTennisSwimmingCycling11E1223Sultan31E64Salim42E212E51Event3ЕЗ32evCodeev Title#spId evPlayes43ESE43Mini Foot FestIbri TourEl175E71E2415Oman OpenArab Sea RaceMuscat CyclingDhofar FestIndoors CupSuhar OpenE332E4336E5448Еб1115E7332B8264Note: primary keys are underlined, foreign keys have #.Answer the following questions : (after executing the SQL command, copy the command and screen shot of theresult in a word file. Do not forget to indicate the question number, save the file with your student numberand send it by email)Q2. Insert data in tables as in the figure.

1. Consider the following schema: Player plvld plyName Hilal Sport spld 1 Record #evCode place spName Football #plyld 1 1 E1 2 Tarek Sultan 2 Tennis 1. E6 4 Swimming Cycling 3 3 E2 E5 1 4 Salim 4 1 3 ЕЗ E8 32 8 Event 3 evCode #spId evPlayes 4 evTitle E4 El Mini Foot Fest 75 4 E7 1 E2 Ibri Tour 4 15 E3 Oman Open 32 E4 E5 E6 Arab Sea Race Muscat Cycling Dhofar Fest Indoors Cup Suhar Open 3 36 48 4 1 115 32 E7 B8 64

1. Consider the following schema: Player plvld plyName Hilal Sport spld 1 Record #evCode place spName Football #plyld 1 1 E1 2 Tarek Sultan 2 Tennis 1. E6 4 Swimming Cycling 3 3 E2 E5 1 4 Salim 4 1 3 ЕЗ E8 32 8 Event 3 evCode #spId evPlayes 4 evTitle E4 El Mini Foot Fest 75 4 E7 1 E2 Ibri Tour 4 15 E3 Oman Open 32 E4 E5 E6 Arab Sea Race Muscat Cycling Dhofar Fest Indoors Cup Suhar Open 3 36 48 4 1 115 32 E7 B8 64

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Draw the domain class diagrams Scenario: Lillian’s Auto Works Lillian is the owner of Lillian’s Auto Works, a vehicle servicing center based in Gqeberha. Lillianrequires a new computerized Vehicle Servicing Record System (VSRS) - with a websitecomponent for private customers - to keep track of all customers and their vehicle’ serviceinformation. Lillian’s Auto Works’ customers can be private customers or companies.For private customers their id number must be submitted, whereas for companies their VATnumber is recorded. Each customer is allocated a unique customer number, and has a name,address and telephone number. Each customer can own many cars. The registration numberof the car uniquely identifies it, and the make, model and model year of the car must berecorded. A car is owned by only one customer. Customers bring their cars in for a service.A car can be brought in many times to be serviced.The system must keep information about Lillian’s employees. Details include employeenumber,…
QUESTION 12 Each domain can be subdivided into which of the following that allows you to organize the objects in a domain? a. Forests b. Organizational units (OUs) c. Domain controllers d. Trees
Open your text editor and create a new document named model.php model.php will contain functions that will connect to a database potentially return PDO statementobjects to the controller for processing. updateMessagesfunction updateMessages($id)This method will take a single parameter of id which is the saved id from the last or latest message displayed. It will conditionally select from the table “messages”, id, name, message, and time. The condition is that the field id is greater than the parameter for id. The return is the PDOStatement object with the row data from the query.
Introduction The goals of this assignment are for you to: Define a controller and an action on the controller that passes data to a view that displays the content dynamically using Razor syntax. What you need to do To complete this in-class assignment you need to do all of the following: Complete the task as described below. Submit your solution as a single zip file to the eConestoga Dropbox for the assignment so that ultimately, I can associate a grade with it. Your Task Create a simple blog application using ASP.NET Core MVC. The application should allow users to view and add blog posts. It will consist of two main parts: a blog post list page and a page for creating new blog posts. To do this you will define your controller and models with the data and display it on views to show the output. Steps: Create Models: Create a BlogPost model with properties like Id, Title, Content, and PublicationDate. Create a Controller: Create a BlogController with actions to:…
The following schema is given (primary keys are bold): ARTWORK (ArtworkCode. Title, Author, BasicAuction Price, FinalSalePrice". NumParticipantingBuyers", FinalBuyerID") OFFER (ArtworkCode, BuyerID, Date, Amount) REQUEST AUCTION ENDING (ArtworkCode. Auction EndingDate, Description) Write the trigger to manage the following activities related to an online auction of artworks. The ARTWORK table contains the list of artworks sold at the auction. The OFFER table contains, for each artwork, a list of the amounts that have been offered by buyers interested in purchasing the artwork. The same buyer can make multiple offers for the same artwork on different dates. A request to end the auction for an artwork is generated (inserting a record into the table REQUEST AUCTION ENDING), If there was no offer for the artwork, the trigger ends with an error. Otherwise, you have to calculate the following information. (1) The final sale price of the artwork, corresponding to the highest amount offered…
Below is my RolePermission Model:@Entity@Getter@Setterpublic class RolePermission {@Id@GeneratedValue(strategy = GenerationType.SEQUENCE,generator = "Id")// @Column(name = "id", nullable = false)private Long id;//@ManyToOne(fetch = FetchType.LAZY,cascade = CascadeType.REMOVE)// @ManyToOne@JoinColumn(name = "roleId")@JsonIgnoreRole role;@ManyToOne(fetch = FetchType.LAZY,cascade = CascadeType.REMOVE)// @ManyToOne@JoinColumn(name = "permissionId")// @JoinColumn(name = "permissionId", referencedColumnName = "permission",// insertable = false,updatable = false)@LazyToOne(LazyToOneOption.NO_PROXY)@JsonIgnorePermission permission;@CreatedDate@CreationTimestamp@DateTimeFormat(iso = DateTimeFormat.ISO.DATE_TIME)LocalDateTime createdAt;@LastModifiedDate@UpdateTimestamp@DateTimeFormat(iso = DateTimeFormat.ISO.DATE_TIME)LocalDateTime updatedAt;}
Input values seat1, travel_time1 and plane_num1 are read from input, representing the seat, travel_time, and plane_num of a passenger. An element representing a new seat is also read from input as new_seat. Complete the following tasks: Assign passenger1 with an instance of Passenger with seat1, travel_time1 and plane_num1 as attributes in that order. Call passenger1's print_data(). Call passenger1's move_seat() with argument new_seat. Call passenger1's print_data() again.
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions: Transaction SQL Statement Retrieve the flight number, departure and arrival airports of all British Airways. Retrieve the name of every passenger together with their flight number and the associated company. Retrieve all flights departed from all airports in London. Retrieve the ticket numbers…
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions:1. Retrieve all rows in Airport table for all the airports in London city.2. Retrieve all British and German passengers.3. Retrieve all names of all the passengers.4. Retrieve the flight number, departure and arrival airports of all British Airways.5. Retrieve the name of every passenger together with their…
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions: Transaction SQL Statement Retrieve all rows in Airport table for all the airports in London city. Retrieve all British and German passengers. Retrieve all names of all the passengers. Retrieve the flight number, departure and arrival airports of all British Airways. Retrieve the name of…
Course: Database *(SQL)* Please excute the given SQL script (https://drive.google.com/file/d/1zxe_aOhERjVCL54_zbgSLkFTRHYQhOPW/view?usp=sharing) for accessing the data. The data is described in the following relation schemas: Airport (airportID, name, city) Passenger (ticketNo, name, nationality, flightNo, seatNo)FK: flightNo references Flight (flightNo)FK: seatNo references Seat (seatNo) Flight (flightNo, flightCompany, departAirport, arrivalAirport)FK: departAirport references Airport (airportID)FK: arrivalAirport references Airport (airportID) Seat (seatNo, flightNo, class)FK: flightNo references Flight (flightNo) #Construct the SQL statements based on following transactions: please if you could give all the sql statements needed i will appreciate that, and i promise to put thump up Transaction SQL Statement Retrieve all rows in Airport table for all the airports in London city. Retrieve all British and German passengers. Retrieve all names of all the passengers.…
displayComments a. Dependencies: getPostComments, createComments b. Is an async function c. Receives a postId as a parameter d. Creates a section element with document.createElement() e. Sets an attribute on the section element with section.dataset.postId f. Adds the classes 'comments' and 'hide' to the section element g. Creates a variable comments equal to the result of await getPostComments(postId); h. Creates a variable named fragment equal to createComments(comments) i. Append the fragment to the section j. Return the section element In JavaScript please