Create the SQL code necessary to create an entity that reflects the following table. Make the ID a primary key. Run that code untit runs without error. Note, no data is necessary for this question. Take a snip of the sqldeveloper screens that show both the codeand the result of running it and attach that snip as your answer.Student IDStudent NameStudent Street Address4411Ramona Garrett233 POOL Alley3068Roberto Mendoza73192 KENSINGTON Rd.Bradley PierceLeigh Freeman438393691 SOLIDARITY Rd.497563759 EASTGATE Rd.4799Candace Washingtoi 6144 POOL Dr.HTML EditorВ IU A• A -x, E E曲。V K E T T.12ptParagraphO worcIII

In SQL, tables are defined with CREATE TABLE command. When a table is created, its fields name, data…

Create the SQL code necessary to create an entity that reflects the following table. Make the ID a primary key. Run that code unt t runs without error. Note, no data is necessary for this question. Take a snip of the sqldeveloper screens that show both the code and the result of running it and attach that snip as your answer.

Create the SQL code necessary to create an entity that reflects the following table. Make the ID a primary key. Run that code unt t runs without error. Note, no data is necessary for this question. Take a snip of the sqldeveloper screens that show both the code and the result of running it and attach that snip as your answer.

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

Execute a SQL statement to add a new field 'status' as char(10) to order_db with the default value 'available'.
Please answer as many questions as you can!
the charts are to be in sql. Need some help around the primary keys and foreign keys CREATE TABLE Countries ( PRIMARY KEY() CountryID int, CountryName varchar(100), Leader varchar(100), Population int, WarSide varchar(10) MilitaryStrength int, CasualitiesLost int, WarOutcome varchar(30) ); --the two sides to the war CREATE TABLE Allies ( CountryID CountryName WarSide TotalStrength BattlesWon BattlesInvolved WarResult TotalCasualties int, ); CREATE TABLE Central ( CountryID int, CountryName WarSide TotalStrength BattlesWon BattlesInvolved WarResult TotalCasualties int, ); --many to many for countries and battles CREATE TABLE CountyBattles ( id int NOT NULL, CountryID int, BattleID int, PRIMARY KEY (id), CONSTRAINT fk1 FOREIGN KEY (CountryID) REFERENCES Countries(CountryID), CONSTRAINT fk2 FOREIGN KEY (BattleID) REFERENCES Battles(BattleID) ); CREATE…
Based on the following relational schemas, write the SQL commands to answer all the questions given bellow: WORKSHOP (WSCode, WSName, StartDate, StartTime, VenueNum, SpeakerID) VENUE (VenueNum, VenueDesc, VenueLoc, VenueCapacity) SPEAKER (SpeakerID, SPName, SPSex, SPPosition, SPPhone, SPAddress) Note: VenueDesc = venue description, VenueLoc = venue location, SP = speaker a) Display the names of speakers that name begin with ‘Nurul’ and address in Perak. b) List workshop details for all workshops that are handled by speaker Dr Nurhaliza Kamil. c) Using subquery, list venue details for all venues that have not been used for workshop. d) Calculate how many workshops are handled by speaker Encik Amran Kassim. In output, display speaker’s name and total workshop that he/she handled. Replace calculated column name using TOTAL WORKSHOP. e) Display the workshop name, start date, venue description and location for all workshops that are run in venue with a capacity greater than and equal to…
ies in relational algebra. Find the username of users who are from ‘Muscat’. Find the IDs of pictures which scores more than 2000 likes. Find IDs of pictures which descried as landscape. b. Write SQL queries for the following statements. Display all the picture’s details in the decreasing order of their scores. Count and display the number of pictures posted by each user. Add the given new user’s data into the Users table. userId userName userCity 2536 User2021om Muscat
(a) Write the sql syntax to create a table name Client with the following restrictions; Client(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary key. cname do not accept null values. Payment_mode accepts only cash or credit entries. The default address is “vacoas". client is at least 25 years old. Salary is above Rs 30000. (b) Consider the schema of Customer table in part(a) and write SQL statements for the following queries. i. Using SQL, write the command to add a new column in the client table with the following data definition; (Column “gender" of char data type and field size of 1). ii. Using SQL, write the command to insert the values in the Client table. cid address age occupation salary Payment_mode gender cname 123 sam vacoas 31 manager 60000 cash m 124 david flacq 38 administrator 45000 credit m iii. Write the SQL query to display the cid of all employees. iv. Write the SQL code to list all administrators whose salary is greater than Rs…
Thank you for helping! Write the SQL code to produce the total number of hours and charges for each of the projects represented in the ASSIGNMENT table. The result is shown as below. Write the SQL code to display the information of employees who are working as either programmer or system analyst. Write the SQL code to produce job_descriptions(job_title) of employees who are working at project ‘Evergreen’.
Create multiple records of the application and related entities and then insert them with some different values of Affiliation, funding sources. Run a query to find out if there is affiliation risk or funding concentration risk (defined as when the company has more than 3 countries associated with listed countries of concern or if more than 60% of their funding is from countries of concern) in SQL code and please run the code. please ignore the question the information in the charts are needed to run a query in SQL coding to see which company of the 3 has more affiliation risk.
Where do you think student and tutor information such as name, address, phone, and e-mail should be kept? Write the necessary SQL commands to capture this information.
Write a SQL statement to create a stored procedure called Calc_Average based on the Semester_Marks table created in Table 2: Semester_Marks table structure. The stored procedure should update the total marks, no of courses and calculate the average mark for each student. (Note: Average mark = total_mark divide by the number of courses for the student.). Control the flow of your code should an error occur (e.g. number of courses enter is zero). Use exception handling to avoid zero being entered for the number of courses. Table 2: Semester_Marks table structure Semester_Marks Column Name Datatype Allow Nulls PK Stud_Reg_No int First_Name char(20) Last_Name char(20) Total_marks int No_Courses int Student_Average_Markint
Based on the ERD below, write the SQL statement to change the job description of “Database Designer” to “Database Developer”. After completing this task examine the results with a select statement. (Hint: Use an Update Statement.)