Assignment-1.pdf - Assignment-1 Course Name Database...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Assignment-1 Course Name: Database Instructor: Sir Shoaib T.A: Faisal khan Weightage : 4 Deadline: 2/25/2018 Note : . Zero tolerance for plagiarism . . You will be awarded straight zero If your assignment found to be copied or someone copied your assignment . As this assignment is lengthy and carry high weightage, so please start working on assignment as soon as possible. . No submission on email. _____________________________________________________________________________________ Instruction: a. check “Datab ase_Table_Description.doc ” file .This file contain general information of databse and their model used in this assignment. Try to identify the foreign key and primary key in ERD diagram. b. First you need to create all 7 table with constraint. c. after creating table run the insert query given in “insert .txt ” table. d. How to submit: 1. You should submit your assignment in the form of two file.one is “query.txt” and another is “screen_ shot.pdf ”. 2. query.txt file contain the create,select,update and Data modification query which you run on the database. 3. screen_shot.pdf file contain screen shot of all the outputs. e.g after creating the table run describe table query on each table and take screen shot of it.for select query you should take the output of each select query and same goes for data modification. Part A: Table Creation Weightage:1.5
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Customer custno custname address Internal contact phone city state zip C100 Football Box 352200 Y Mary Manager 6857100 Boulder CO 80309 C101 Men's Basketball Box 352400 Y Sally Supervisor 5431700 Boulder CO 80309 C103 Baseball Box 352020 Y Bill Baseball 5431234 Boulder CO 80309 C104 Women's Softball Box 351200 Y Sue Softball 5434321 Boulder CO 80309 C105 High School Football 123 AnyStreet N Coach Bob 4441234 Louisville CO 80027 Employee empno empname department email phone E100 Chuck Coordinator Administration [email protected] 3-1111 E101 Mary Manager Football [email protected] 5-1111 E102 Sally Supervisor Planning [email protected] 3-2222 E103 Alan Administrator Administration [email protected] 3-3333 Facility facno facname F100 Football stadium F101 Basketball arena F102 Baseball field F103 Recreation room Location locno facno locname L100 F100 Locker room L101 F100 Plaza L102 F100 Vehicle gate L103 F101 Locker room L104 F100 Ticket Booth L105 F101 Gate L106 F100 Pedestrian gate ResourceTbl resno resname rate R100 attendant $10.00 R101 police $15.00 R102 usher $10.00 R103 nurse $20.00 R104 janitor $15.00 R105 food service $10.00
Image of page 2
EventRequest eventno dateheld datereq facno custno dateauth status estcost estaudience budno E100 25-Oct-2013 06-Jun-2013 F100 C100 08-Jun-2013 Approved $5,000.00 80000 B1000 E101 26-Oct-2013 28-Jul-2013 F100 C100 Pending $5,000.00 80000 B1000 E102 14-Sep-2013 28-Jul-2013 F100 C100 31-Jul-2013 Approved $5,000.00 80000 B1000
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern