Write a 200 word summary comparing and contrasting what you saw in terms of time to execute each step from 1-3, and why you think this is so. Next (not part of the aforementioned 200 words) state a situation in which you think each may be appropriateAppend 10 records to the Student table of your own design – this means you will be creating 10 records to insert into the tableThis is accomplished via an Insert Into Student Values(1,2,3,etc….) You can model your queries off of the samples within Module 1, but bear in mind you now have indexes built and will not be able to duplicate rows so make sure you don’t use an ID in the student table that is already in use.Truncate and Replace the Sections table the truncate statement conveyed in the lecture slides, and then insert the data from Module 1 (note you do not want to run the create table portion again, as you’ve truncated the table it keeps the structure in place and just deletes the records). eCnl0CONNECTIONS✓ SERVERS> AZUREΘΟΔΟIIlocalhost, (sa)DatabasesSystem DatabasesAShahbaindbo11Tables@ 06 % @dbo.addressdbo.coursedbo.departmentdbo.enrollmentdbo.facultydbo.sectiondbo.studentColumnsBID (int, null)KeysYUName_First (varchar(2...Name_Last (varchar(2...Birth_Dt (varchar(255)...Major (varchar(255), n...Advisor_ID (int, null)Address_ID (int, null)ConstraintsTriggersIndexesStatisticsDropped Ledger TablesViewslocalhost:AShahbain1234567SQLQuery_2 - localhost.AShahbain (sa)4Run Cancel Disconnect ChangeDatabase: AShahbainEnable Actual Plan✓ ParseEnable SQLCMD: To NotebookINSERT INTO dbo.student (ID, Name_First, Name_Last) VALUES (56932, 45146, 86187)INSERT INTO dbo.student (ID, Name_First, Name_Last) VALUES (56952, 45246, 82687)INSERT INTO dbo.student (ID, Name_First, Name_Last) VALUES (58932, 45346, 86827)INSERT INTO dbo.student (ID, Name_First, Name_Last) VALUES (56992, 457446, 84687)INSERT INTO dbo.student (ID, Name_First, Name_Last) VALUES (50932, 45546, 8587)INSERT INTO dbo.student (ID, Name_First, Name_Last) VALUES (56922, 45646, 86687)INSERT INTO dbo.student (ID, Name_First, Name_Last) VALUES (76932, 45746, 87687)INSERT INTO dbo.student (ID, Name_First, Name_Last) VALUES (50932, 45846, 88687)INSERT INTO dbo.student (ID, Name_First,Name_Last) VALUES(56972, 45946, 86987)78910Messages5:40:58 PMScreen Reader Optimized Ln 9, Col 73SQLQuery_2 - localh...in (sa)Started executing query at Line 1(1 row affected)(1 row affected)(1 row affected)(1 row affected)(1 row affected)(1 row affected)(1 row affected)(1 row affected)(1 row affected)Total execution time: 00:00:00.079Spaces: 4dbo.studentSUTF-8 LFEstimated Plan0 rows MSSQL 00:00:00 localhost: AShahbain15370Coc08Dstallotsot11 PMot66 PM 2002 @-fault> (sa)abasesdressursepartmentrollmentcultyctionudentnnsnt, null)ne_First (varchar(2...ne_Last (varchar(2...n_Dt (varchar(255)...or (varchar(255), n...sor_ID (int, null)ress_ID (int, null)traintsYOUerses=ticsed Ledger TablesSQLQuery_3 - localhost.AShahbain (sa)localhost:AShahbainSQLQuery_3 - localh...in (sa)Run Cancel Disconnect Change Database: AShahbainEnable Actual Plan✓ ParseEnable SQLCMD: To Notebook1 TRUNCATE TABLE dbo.sectionMessages6:04:04 PMStarted executing query at Line 1Commands completed successfully.Total execution time: 00:00:00.061SQLQuery_2 - localh...inEstimated Plan08

In the database management, the efficiency and speed of various operations play a crucial role in…

Write a 200 word summary comparing and contrasting what you saw in terms of time to execute each step from 1-3, and why you think this is so. Next (not part of the aforementioned 200 words) state a situation in which you think each may be appropriate Append 10 records to the Student table of your own design – this means you will be creating 10 records to insert into the table This is accomplished via an Insert Into Student Values(1,2,3,etc….) You can model your queries off of the samples within Module 1, but bear in mind you now have indexes built and will not be able to duplicate rows so make sure you don’t use an ID in the student table that is already in use. Truncate and Replace the Sections table the truncate statement conveyed in the lecture slides, and then insert the data from Module 1 (note you do not want to run the create table portion again, as you’ve truncated the table it keeps the structure in place and just deletes the records).

Write a 200 word summary comparing and contrasting what you saw in terms of time to execute each step from 1-3, and why you think this is so. Next (not part of the aforementioned 200 words) state a situation in which you think each may be appropriate Append 10 records to the Student table of your own design – this means you will be creating 10 records to insert into the table This is accomplished via an Insert Into Student Values(1,2,3,etc….) You can model your queries off of the samples within Module 1, but bear in mind you now have indexes built and will not be able to duplicate rows so make sure you don’t use an ID in the student table that is already in use. Truncate and Replace the Sections table the truncate statement conveyed in the lecture slides, and then insert the data from Module 1 (note you do not want to run the create table portion again, as you’ve truncated the table it keeps the structure in place and just deletes the records).

Systems Architecture

7th Edition

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Stephen D. Burd

Chapter3: Data Representation

Section: Chapter Questions

Problem 3RP

See similar textbooks

Similar questions

Create ERD for Real-estate database: There are Many Cities in each State There are Many Zip Codes in each City Many Houses belong to each ZipCode Each House can be one of HouseTypes ( Town House, Residential, Condo, Single Family) Each House can be Sold multiple times. ( entity Sales
Create a new database (named MyUniversity) Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer) Department (did: integer, dname: string(30 chars), capacity: integer) Course (cid: integer, cname: string(50 chars), credit: integer) Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. Using SQL create these relations under the MyUniversity database. Place the constraints (e.g., default values, check, primary keys) you find appropriate:
Create a new database (named MyUniversity) Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer) Department (did: integer, dname: string(30 chars), capacity: integer) Course (cid: integer, cname: string(50 chars), credit: integer) Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. Using SQL, develop and execute the following queries: For each student with GPA between 2.5 (included) and 3.5 (included), display the student’s name, GPA,and his/her department ID. Sort the results by the students’ IDs in descending order. For each student who joined the Computer Science department between 2018 (included) and 2020(included), display…
connect sql with this code class DiplomaProgram: def __init__(self): self.listCourse = set() def addCourse(self, course): self.listCourse.add(course) def removeCourse(self, course): self.listCourse.remove(course) def listPassedStudent(self): listStudent = set() for course in self.listCourse: for student in course.listStudent: if student not in listStudent and student.isPassed(): student.printInfo() listStudent.add(student) def listDistinctStudent(self): listStudent = set() for course in self.listCourse: for student in course.listStudent: if student not in listStudent and student.isDistinct(): student.printInfo() listStudent.add(student) class Course: id = 1 def __init__(self, name, assignments): self.name = name self.id = Course.id…
Create a new database (named MyUniversity) Student (sid: integer, sname: string(100 chars), GPA: real, dateOfBirth: date, Did: integer, FirstYear: integer) Department (did: integer, dname: string(30 chars), capacity: integer) Course (cid: integer, cname: string(50 chars), credit: integer) Enroll (studentID: integer, courseID: integer, departmentID: integer, enrollmentDate: date, finalGrade: real) studentID, courseID, and departmentID in Enroll are foreign keys referencing the primary keys of the student, course, and department relations, respectively. Did in Student is a foreign key referencing the primary key of the department relation. Using SQL, insert (random but meaningful) data records in the above tables. Create at least four different courses that include Operating Systems (3 credit hours), Data Bases (4 credithours), and Marketing (5 credit hours) courses – consider one more course. Create three departments that include a Computer Science department and a Business department…
A key for this database is {Departure Time}. Enter a different key for the database. Airline Flight Number Gate Destination Departure Time FlyRight 221 34 Denver 08:27 JetGreen 222 13 Anchorage 08:43 JetGreen 199 22 Honolulu 08:46 JetGreen 322 34 Anchorage 09:36 FlyRight 122 33 Honolulu 09:45 FlyRight 323 22 Detroit 09:50 FlyRight 222 33 Denver 09:55 Key: { Ex: Gate
Salesforce Assignment: Write a Salesforce Object Query Language for finding the account Record in ascending order.
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
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.
An index may speed up queries, but it's usually a terrible idea to create an index for every property or combination of properties that might be used as search keys. I'd want to know more about this.
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.
Alternate keys: Identify at least five keys (not already listed as PK or FK) needed by end users. These indexes would be considered Alternate or Secondary keys and are mostly used for queries and quick reporting. They may contain multiple columns.