sql database administration

User Generated

fnenNyv

Programming

Description

part 1

Assignment 11 Dropbox

Attached Files:

Follow the instructions in the Assignment 11 document attached

  1. Make sure to follow all steps (Note: Tables and Columns have spaces in the document for readability, do not add spaces to your table and column name)
  2. Document your steps on a word document and take screenshots of the results, label and explain the screenshots
  3. Make sure to perform these task on your VM
  4. Due 12/02/2018 5:00PM

i will provide you a copy of my frind work please make sure u do all and do not copy her at all

part 2

Discuss real-life examples of deadlock, starvation and race. Do not use computer science or computer system environment examples for this discussion forum. Also, do not use examples already stated on the book.

Give at least ONE (1) example of each (that is, one example of deadlock, one starvation and one race example). Be as specific as possible when explaining your answers.

Additional Resources - Podcast: Deadlocks

http://web.archive.org/web/20130729203704id_/http:...

make sure u answer the question and give 2 comment this queastion

Unformatted Attachment Preview

Assignment 11 For this assignment you will create a database, tables, add test data and perform a query. 1. Create a new database that holds details for event registrations called EventsManagementDB 2. Create 3 tables: a. Attendees: here you will have attendee information i. AttendeeID (auto number) ii. FirstName iii. LastName iv. PhoneNumber v. Email b. Events: here event information will be held i. EventID (auto number) ii. EventName iii. EventDescription iv. EventAddress v. EventDate (include time) c. Event Registrations: here you will link the attendee with the event to create a registration i. EventID ii. AttendeeID iii. RegistrationDate d. Make sure to set the proper data types, primary keys for each table and create the proper relationships between the tables 3. Add test records to the tables (add at least 5 test records for each table) 4. Run a SELECT query that uses all three tables using a JOIN, and output the following: a. Attendee Full name, Phone Number, Email, Event Name, Event Date, Registration Date 5. Take screen shots of every step, label them and provide some explanation of the screen shots. Save it into a word document and submit to Assignment 11 Dropbox. 6. Make sure to complete your work on your VM Marciana Davis IT 435 Database Administration 7/18/18 Assignment 11 1. Creating a database: In this screenshot, I created the CourseManagementDB using the Query Editor. 2. Creating tables: In this screenshot, I created the tables, Students, Courses, CourseRoster using the Query Editor. a. Students b.Courses c.CourseRoster d.The Relationships: I have created an ERD to show the relationship between the tables which are two one to many relationships. I made the StudentID and CourseID foriegn keys to their respective tables instead of making them primary keys in the CourseRoster Table. Foreign Keys 3. Test Records: In this picture, I created records for all three tables. a. Students b.Courses c.CourseRoster 4. Query: I created a query that joins all three tables and includes StudentID, Student Full Name, Course Name, Course Start Date, and Registration Date.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags