Q1\ if your database has the nformation in figure below make the database easy to update and modified by using Normalization *
Q: How can a key unique index be created?
A: The CREATE UNIQUE INDEX command forms a exclusive index on a table where no duplicate values…
Q: Create a database Stored procedure for the following situations: CUSTOMER(CUST CODE…
A: Stored procedure in database Create command is used to create tables and databases. A stored…
Q: PLZ help with the following use oracle or oracle sql live problem is in image the database CREATE…
A: The complete answer is given below.
Q: Create a PL/SQL anonymous block to insert a new project in DoGood Donor database. Create and use a…
A: Given data, Create a PL/SQL anonymous block to insert a new project in DoGood Donor database. Create…
Q: Create a PL/SQL a cursor program that will increase the employee salary to 25% who are having the…
A: By increasing all salaries from the employees and over the age of 40 by 25%. Determining the…
Q: Please provide an example of this database key in the following: Super Key
A: Let us see the solution step by step:- keys:- A key in DBMS is an attribute or set of attributes…
Q: Q1\ if your database has the information in figure below make the database easy to update and…
A: Normalization
Q: Write following SQL Queries:A simple database composed of the following tables: PATIENT, DOCTOR,…
A: Note since your question contain multiple sub part but we can answer only three subpart at a time…
Q: DataBase Use EMP and DEPT tables, in the Live SQL, to perform the following operations. Upload your…
A: Hey there, I am writing the required solution(query) based on the above given question. Please do…
Q: Using MongoDb do the following activities Create database named First. Create a collection named…
A: 1. use First 2. db.createCollection("dbase6211")
Q: access databases Normalization Exercise Represent this table as a collection of tables in 3NF:…
A: The key for the given relation is (StudentNumber, CourseNumber) The partial functional dependency…
Q: You're dealing with a database table containing invoice information. Columns in the table include…
A: Explanation: To eliminate duplicate entries from either the result-set, are using the…
Q: 2. Create a trigger that will maintain the correct value in the membership balance in the MEMBERSHIP…
A: The query for trigger is: CREATE OR REPLACE TRIGGER trg_mem_balance AFTER UPDATE OF Detail_DueDate,…
Q: Create the following tables in your database with the following schema: Table: Employee +- | Column…
A: Here are all the queries asked in above:
Q: Q.Normalize the following table upto 3NF. Also create tables and forms in Oracle and insert the…
A: First normal form A relationship is the first normal form if and only if each attribute's domain…
Q: plz help with the following use oracle sql or sql live The procedure should satisfy the following…
A: Answer is given below .
Q: Vrite and execute a query that returns the maximum or highest list price roduction.Product table…
A: Lets see the solution.
Q: Create the following table in your database with the following schema: Table: orders | Column Name 1…
A: Here are all the queries:
Q: Create a PL/SQL anonymous block to insert a new project in DoGood Donor database. Create and use a…
A: Answer below ?:-
Q: QUESTION : 1. Write a PL/SQL PROCEDURE that will list the project names given the course ID.…
A: --Following is the code as required. Compile the procedure first and then execute the anonymous…
Q: Retrieve all borrowers (their attribute values) who reserved any single library item. Retrieve the…
A: -1 I would like to get all the members who returned the borrowed books late. I have a borrowing…
Q: You are required to create the following tables in a database named SICKLEAVE: EMPLOYEES EMPLOYEE_ID…
A: To create a database we use - CREATE DATABASE <dbname> To create a table we use - CREATE TABLE…
Q: A select operation in a relational database is used to cut down on the size of a table by deleting…
A: Given: In a relational database, a select operation is used to reduce the size of a table by…
Q: how to Create two or more MySQL VIEWS using the Pizza Store Database. Each of the Views must have a…
A: Given: Create two or more MySQL VIEWS using the Pizza Store Database. . Conditions: Each of the…
Q: From the database scheme write the query(all tables are empty) 1) Insert your name and your phone…
A: The given diagram is a logical model for the rent of apartments where the apartment has a building…
Q: Create a database trigger for the following situations: update the…
A: A block of SQL or PL/SQL code that is automatically triggered, by the DBMS when some specific data…
Q: 1) Create table 2) Insert employee 3) Update employee 4) Delete employee 5) Delete table.
A: Integrate Python Database Connectors with SQLite3 For this assignment, I will like you to do the…
Q: 1. Display all customers whose email is null or ends with 'fiu.edu’ 2. Display the number of orders…
A: Use LIKE to match the ending of email USE IS NULL to check whether value is null or not SELECT *…
Q: List the trip IDs and trip names for each pair of trips that have the same start location.(You will…
A: WHERE Statement : "WHERE" statement is used limit the number of rows. For example: Consider a table…
Q: Create a form to insert/update/delete medicine details into the database. in c# (. Pharmacy Store)
A: Answer :
Q: Write the sql ddl statments for books relational database. Specify data types, also keys and…
A: Creating a basic table involves naming the table and defining its columns and each column's data…
Q: that
A: The correct answer to the given question is option (d)"GRANT"
Q: All parts of this question use the following database schema: Flights(flno, from, to, distance)…
A: SELECT MIN(salary),e.ename FROM Aircraft a JOIN Certified c ON a.aid=c.aid JOIN Employees e ON…
Q: Write SQL update statements to do the following on the database schema shown in Figure 1. i. Insert…
A: Answer: We need to write here some SQL command based on given question one if the insert the value…
Q: in sql An index is automatically created for a FOREIGN KEY constraint. Select one: a. True b.…
A: b) False
Q: use national join plz Consider the education database with student and scho ,where the primary keys…
A: We have created student and school tables, where the primary keys are underlined. Using below Given…
Q: Q. Normalize the following table upto 3NF. Also create tables and forms in Oracle and insert the…
A: Normalization is defined as a database that organize the particular data in multiple tables. For the…
Q: 2.Create anonymous block to retrieve and display data for all pledges made in a specified month. One…
A: Solution: Only for question 2, answer is mentioned below. PL/SQL code
Q: cted from employ salary your task is to show this problem in sql emp table. Find out employ annual…
A: Database System Create in SQL and Attach Screenshots . In July 2014 salary of employees increase…
Q: Why this give me an error The INSERT statement conflicted with the FOREIGN KEY constraint…
A: Answer: Because you donot insert any rows into the Suppliers table
Q: 10. Insert the following records to BOOKS table: BookID Category Title Price Writer 1 IT SQL 50…
A: Solution : Here, in BOOKS table there 5 columns. The books details are shown in table. In above…
Q: SQL Using the World database, update the life expectancy of the Cocos (Keeling) Island country to…
A: The UPDATE statement is used to modify the existing records in a table. Syntax: UPDATE table_nameSET…
Q: Execute the following statements using MYSQL: 1. Insert a row with the values (005, "Your name", ,…
A: 1. Insert a row with the values (005, "Your name", , "Your Dept", 50000, 40) 2. Create a trigger…
Q: Subject: Database Write the SQL statements for following modification tasks: a) Add constraint to…
A: According to the provided information: We need to create SQL query for the addition of a primary…
Step by step
Solved in 2 steps
- Write Mysql code for: The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule for Feb 1, 2020 with the lesson date/time, student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date/time, then by the horse's registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results. Hint: Perform a join on the LessonSchedule, Student, and Horse tables, matching the student IDs and horse IDs.Write Mysql code The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule with the lesson date/time, horse ID, and the student's first and last names. Order the results in ascending order by lesson date/time, then by horse ID. Unassigned lesson times (student ID is NULL) should not appear in the schedule. Hint: Perform a join on the Student and LessonSchedule tables, matching the student IDs.Q2: A-Given the following tables: Student Subject Std_ID 001 002 003 004 Fname Smith Smith Beal Thomson Lname Jolin Susan Fred Marie Std_ID 001 001 002 002 003 Semester 004 Falls03 Spro4 Falls03 C_ID Eng01 Ger01 Eng01 Ger01 Ger01 CSection Spro4 Spro4 Spro4 1. For each table in the database, identify the primary key and the foreign key(s). 2. Do the tables exhibit entity integrity? Explain your answer? 3. Do the tables exhibit referential integrity? Explain your answer? Ita01 ZZZZZZ IN 2N IN 2N IN CName English IN German English German German Italian Grade A B A B A B
- using php We run a dog grooming shop, there are new 4 breeds that are being registered to our system. Please add their names, breeds, and ages to the database, also display the new inputs with non-prepared statements Requirement 1: Require the programmer to insert rows Requirement 2: Require the programmer to display the rows after they have been changed Requirement 3: Require use of a non-prepared statementThe following database will be used in this question: SALESREP SalesRepNo 654 734 345 434 RepName Jones Smith Chen Johnson HireDate 01/02/2005 02/03/2007 01/25/2004 11/23/2004 CUSTOMER CustNo 9870 8590 7840 4870 CustName Winston Gonzales Harris Miles Balance 500 350 SalesRepNo 345 434 654 345 800 100Find the Primary Keys and P3,6 for the database: Make Model Engine ID Ford Mustang Ford Fiesta Chevy Camaro Chevy Caprice Olds Cutlass Olds Cutlass Volvo P1800 Volvo 240 Volvo 760 Year 1972 A1222 1989 C54322 1991 754342AH 1989 442355CC 1992 ANDU33 1992 ANGH28 1969 44325XX 1986 53526PD 1992 578868R Vehicle ID FO13579 FO24245 CH172389 CH156738 OL64332 OL61998 V044526 VO64690 V083529 Color Black Yellow Black Yellow Blue White White Black Blue
- Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…Database Schema The schema for the Ch07_FACT database is shown below and should be used to answer the next several problems. Click this image to view it in its own tab. FIGURE P7.56 THE CH07_FACT ERD CHECKOUT PATRON PK Check Num PK Pat ID FK1 Book_Num FK2 Pat_ID Check_Out_Date Check_Due_Date Check_In_Date >0-----H- Pat_FName Pat LName Pat_Type BOOK AUTHOR PK Book_Num PK Au ID Book_Title Book_Year Book_Cost Book_Subject FK1 Pat_ID Au_FName Au_LName Au_BirthYear WRITES PK,FK1 Book Num PK,FK2 Au ID The CIS Department at Tiny College maintains the Free Access to Current Technology (FACT) library of e-books. FACT is a collection of current technology e-books for use by faculty and students. Agreements with the publishers allow patrons to electronically check out a book,QUESTION 21 Code a chain of MongoDB methods that retrieves documents from MondoDB collection named WEB322 the only documents that are selected are the ones with value 211 in the semester field the only fields of the selected documents that are retrieved are firstName and lastName make sure the _id field is NOT retrieved sort the selected documents by lastName in ascending sequence store the result to an array named result assume the connection between the program and database had already been established and the name of the database object is db
- Observe the HOMETOWN REALESTATE database: SELLER SellerID SellerName RealtorID S111 Paul R1 S222 Carly R1 S333 Ang R2 S444 Charlotte R2 S555 Aidan R3 C666 Eric R1 C777 Christina R1 REALTOR RealtorID RealtorName R1 Claire R2 Kate R3 Cliff R4 William If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between SELLER and REALTOR in the HOMETOWN REALESTATE database, what will be the outcome after a user tries to delete the last record (R4, William) from REALTOR? O SELLER will have 7 records, REALTOR will have 4 records O SELLER will have records, REALTOR will have 3 records O SELLER will have 7 records, REALTOR will have 3 records O SELLER will have 6 records, REALTOR will have 4 records O SELLER will have 3 records, REALTOR will have 3 recordsHELP IN DATABASE THIS DID NOT WORK CREATE OR REPLACE PROCEDURE PRC_INV_DELETE (W_IN IN NUMBER) ASBEGINIF W_IN IS NOT NULL THENDELETE FROM INVOICE WHERE INV_NUM = W_IN;END IF;END;Part A: MySQL Query/Exec Create StudentsDB database in MySQL server with the following table: Table: Students uid int, Primary Key, Auto Increment studentID varchar(8), Unique name varchar(50) major varchar(50) passedCredits int CGPA float Implement the following PHP scripts as required below: php: the script should display student’s info (StudentID, name, major, credits passed and CGPA) in HTML table with appropriate title for each column. Student cells/rows should be highlighted as follows: Condition Highlight Color Student At Risk: CGPA < 2.0 Red for CGPA Cell Expected to graduate: Passed Credits >=115 Yellow for Passed Credits Cell Outstanding Student: CGPA = 3.5 or above Green for the entire Student Row php: This script should display all students’ names and major. Each student will be identified by a checkbox (define the checkbox name as a numeric array holding the uid). The…