D427 Practice Test 1 with Answer Key

PHP script

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.

Table is necessary

Write an XML file that describes information of students in a class. The following table has the students' details: Name ID Ahmed 1000 Muhammad 2000 Note that the root element start and end tags are provided

Create a MySQL Database called “CSC306Class”. Create three (3) tables in the database called “studentInf”, “IntructorInf”, and “LikedAndDisliked”. Each table should consist of five columns that are relatable to the table name. Insert at least five row of data in each table. The data can be any information as long as it is related to the table name. If you were able to download and setup an php server on computer. Try to create the database, tables, and rows. Then upload a screenshot and code. Please help me with the practice problem I have created.

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.

Web Application Development

University of Kerbala College of CS & IT Information Technology department First Exam Time: one hour Database lab Q-Design a system for airline reservation database, should have at least tables. In addition to build schema, the required is: 1- write all instruction's to do this structure. 2- Make new field with titles notes to first table has data type integer. 3- Edit the new field to be character data type. 4- Remove any column from any table. Good Luck!

table not copied

To get credit for this assignment, perform the instructions below and enter the code you get from the instructions below here (Hint: starts with 360)    Instructions First, create a MySQL database or use an existing database (make sure to use a UTF8 character set, like utf8mb4) and then create a table in the database called "Ages": CREATE TABLE Ages ( `name` VARCHAR(128), age INTEGER ); Then make sure the table is empty by deleting any rows that you previously inserted, and insert these rows and only these rows with the following commands: DELETE FROM Ages; INSERT INTO Ages (`name`, age) VALUES ('Deelan', 37); INSERT INTO Ages (`name`, age) VALUES ('Denver', 33); INSERT INTO Ages (`name`, age) VALUES ('Rona', 23); INSERT INTO Ages (`name`, age) VALUES ('Kodi', 29); INSERT INTO Ages (`name`, age) VALUES ('Seaan', 18); Once the inserts are done, run the following SQL command:SELECT sha1(CONCAT(`name`,age)) AS X FROM Ages ORDER BY X; Find the first row in the resulting record set and…

1-Write the syntax to insert into a relational table called students the address column references an object table called addresses that was created using an address_type.  Other columns exist in the students table, but you are only inserting into the ones below. Aliases used should be the first letter of the table name, eg students would be s, addresses would be a Relational Table Name students attribute student_id attribute surname attribute address

I was hoping you could provide some light on the role that the data dictionary plays in the DBLC method.

1. The rows in the JOBS table store a minimum and maximum salary allowed for different JOB ID values. You are asked to write code to ensure that employees' salaries fall in the range allowed for their job type, for insert and update operations.

How does indexing work with columns that store JSON data in PostgreSQL?

What's "metadata"? Metadata in a dataset: Metadata from a result set—useful?

For this assignment I need to perform the instructions below and enter the code you get from the instructions below here (Hint: starts with 143)

1.6   Using SQL Server (Not Oracle)

Write an XML file that describes information of students in a class. The following table has the students’ details: Name ID Ahmed 1000 Muhammad 2000 Note that the root element start and end tags are provided <class>