1. Consider the following schema:Record#plvIdPlayerplyld plyNameHilalTarekSultanSalimSportspldsp NameFootballTennisSwimmingCycling#evCode place111El1E6433E21.44E51EventevCodeEl3.ЕЗE8328#spId evPlayes4evTitleE4E73Mini Foot FestIbri TourOman OpenArab Sea Race751541E24E3E423236Muscat CyclingDhofar FestIndoors CupSuhar OpenE5448Еб115E7332B864Note: primary keys are underlined, foreign keys have #.Answer the following questions : (after executing theSQL command, copy the command and screen shot ofthe result in a word file. Do not forget to indicate thequestion number, save the file with your studentnumber and send it by email)Q1. Create the tables above. Include primary keys and foreign.keys

create table Player(plyId int primary key, plyNmae varchar(20)); create table Sport(spId int primary…

1. Consider the following schema: Player plvld plyName |Hilal Tarek Sultan Salim Sport spld Record sp Name Football Tennis Swimming Cycling #plvId #evCode place 1 1 1 El 3 1 E6 4 4 E2 2 ES 1 Event 3. ЕЗ 32 3 ev Code evTitle #spld evPlayes 4 ES E4 El E2 Mini Foot Fest 75 1 4 E7 1 Ibri Tour 4 15 E3 Oman Open 2 32 36 E4 Arab Sea Race 3. Muscat Cycling Dhofar Fest Indoors Cup Suhar Open ES 4 48 E6 1 115 E7 3 32 B8 2 64 Note: primary keys are underlined, foreign keys have #. Answer the following questions : (after executing the SQL command, copy the command and screen shot of the result in a word file. Do not forget to indicate the question number, save the file with your student number and send it by email) Q1. Create the tables above. Include primary keys and foreign keys

1. Consider the following schema: Player plvld plyName |Hilal Tarek Sultan Salim Sport spld Record sp Name Football Tennis Swimming Cycling #plvId #evCode place 1 1 1 El 3 1 E6 4 4 E2 2 ES 1 Event 3. ЕЗ 32 3 ev Code evTitle #spld evPlayes 4 ES E4 El E2 Mini Foot Fest 75 1 4 E7 1 Ibri Tour 4 15 E3 Oman Open 2 32 36 E4 Arab Sea Race 3. Muscat Cycling Dhofar Fest Indoors Cup Suhar Open ES 4 48 E6 1 115 E7 3 32 B8 2 64 Note: primary keys are underlined, foreign keys have #. Answer the following questions : (after executing the SQL command, copy the command and screen shot of the result in a word file. Do not forget to indicate the question number, save the file with your student number and send it by email) Q1. Create the tables above. Include primary keys and foreign keys

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

1.1 tblMembers The tblMembers will be used to store the details of the Gym Members MemberID, Name, Surname, DateOfBirth, ID,Contact, DateJoined MemberType (Annual: R200/year, Monthly: R50/month)1.2 The tblPayments table will be used to keep track of payments made by Members. PaymentID, Date, Amount. The tblPayments should be related to tblMembers accordinglyUsing Java and the jdbc API , create a startup frame that will be used navigate the application. The frame should have 3 buttons.1.3 The first button will open aa frame that can be used to add, update and delete Gyjm Members. 1.4 The second button will open a frame that will be used to collect the payments made by students.1.5 The third button will display a frame that calculates the current age and the balances, and displays a summary report in a table, as follows for an example:Order # is the sequence number of the member in tblMembers table. Should a member be deleted the system should adjust the sequence as well.- Age is the…
13. As a UI view controller is created, the default function viewDidLoad() is defined. Unless the function is overridden, it can be inherited from its superclass ___________________. Fill in the blank. 14. Assume that user credentials may be available. One of the implementation methods for iPhone access control is to enable or disable UI objects depending on the user's credential. __________ var button: UIButton! @IBAction func _________ {_ sender: Any) { // do a sequence of actions }
//2. createSelectOptions //a. Test users JSON data available here: https://jsonplaceholder.typicode.com/users//b. For testing (not in function) you may want to define users with the test data.//c. Receives users JSON data as a parameter//d. Returns undefined if no parameter received//e. Loops through the users data//f. Creates an option element for each user with document.createElement()//g. Assigns the user.id to the option.value//h. Assigns the user.name to the option.textContent//i. Return an array of options elements This is what I have so far passes a, c, d fails rest help please function createSelectOptions(users) { return users.map((x) => x.option); }
I NEED a general outline of what THIS PARTICULAR javascript file would do or control. NOT a general description of a Javascript file // Ionic Starter App // angular.module is a global place for creating, registering and retrieving Angular modules// 'starter' is the name of this angular module example (also set in a <body> attribute in index.html)// the 2nd parameter is an array of 'requires'// 'starter.controllers' is found in controllers.jsangular.module('CITC', ['ionic', 'CITC.controllers','CITC.services']).run(function($ionicPlatform,$rootScope, $ionicLoading) { $ionicPlatform.ready(function() { // Hide the accessory bar by default (remove this to show the accessory bar above the keyboard // for form inputs) if (window.cordova && window.cordova.plugins.Keyboard) { cordova.plugins.Keyboard.hideKeyboardAccessoryBar(true); cordova.plugins.Keyboard.disableScroll(true); } if (window.StatusBar) { // org.apache.cordova.statusbar required…
Android Studio : An application that intends to receive an intent often needs to associate itself with this entity. This can be done using XML in the AndroidManifest.xml, and it can also be done dynamically by constructing this class in code? A. BroadcastReceiver B. Bundle C. Intent Filter D. Activity
Complete this javascript file according to the individual instructionsgiven in the comments. *** DO NOT CHANGE any of the code that you are not instructed to. */ ////////////////////////// NOTE: Use the API endpoints available at// https://jsonplaceholder.typicode.com/// to get the data required in these exercises.// HINT: Read the documented Resources and Routes.// Also the guide:// https://jsonplaceholder.typicode.com/guide//////////////////////// Create a function named "getComments".// This function needs to accept a "postID"// parameter.// Use Fetch with Async/Await to request// all the comments for the postID that// is passed in as a parameter.// The function should return all the// comments for the requested postID// as JSON data.
1Explain the following code in detail: app.post("/outerspace/ufo", (req, res) => { var placeholderValues = { phusername: req.body.name, }; res.render("rocketship", { data: placeholderValues });}); 2 Explain the following line of code: clientObj.hasOwnProperty("Batman") && (clientObj["Batman"] = "Dormant"); 3 Utilize a JSON method to turn a JavaScript object named Seneca into a JSON stringreplace the value of the courseCode property to "WEB322"insert indentation by multiple of 5 spaces
can you please explain this code which is written to perform these tasks: The list of projects that each employee worked on. The average award received by each employee. The maximum and minimum monthly awards are received by each employee. The project id and language in which each employee received the maximum award for working on that project. The employee name that received the maximum awards within 10 years. The number of projects that each employee did not work on it. code: import pandas as pd import numpy as np URL = "https://bit.ly/38zhU5T" df=pd.read_csv(URL) arr=df.to_numpy() employee_notworked=[0,0,0,0] #Array to store the number of projects each employee did not work employee=[[]]*4 #list of projects worked by employees. min_award=[0,0,0,0] #Array to store minimum award received by employees. max_award=[0]*4 #Array to store maximum award received by employees. avg_awards=[0]*4 #Array to store the average award received by employees. maxaward_employee=0 project_id=[None]*4…
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,…
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
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…