Scribd Logo
Upload

Welcome to Scribd!

  • 3 views

    Question Set 10

    Uploaded by

    viduthulo03

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Question Set 10

    Uploaded by

    viduthulo03
    3 views1 page

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    3 views1 page

    Question Set 10

    Uploaded by

    viduthulo03

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 1

    Question Set 10

    Kebithigollewa Central college was the only active school in the area during the war season. There were only 15 students
    in the school. Also, there were only 5 teachers and one of them was the principal of the school. The principal decided to
    add all students' details in a student’s attendance marking system so he would be able to mark the attendance after the
    main morning assembly at once. Think you are a reputed database engineer and the principal requested to make a
    database while another developer is developing the system. The details have been given below.

    student
    No. Name Birthday Grade Village Transportation method
    1 Saman Kumara 2005/03/12 6 1 1
    2 Amal Perera 2007/05/26 4 2 2
    3 Thilak Chandana 2009/11/02 2 3 3
    4 Nadini Premadasa 2008/06/04 3 4 4
    5 Harin Fernando 2006/08/08 5 5 5
    6 Sitha Kanchana 2010/10/30 1 6 2
    7 Piumi Hansamali 2009/04/15 2 2 1
    8 Renuka Mahinda 2006/09/22 5 3 3
    9 Wathsala Shani 2010/12/24 4 4 2
    10 Sunil Rajapaksha 2008/05/06 3 5 4
    11 Amarabandu Rupasinghe 2007/06/23 4 4 2
    12 Himali Siriwardana 2005/07/14 6 1 1
    13 Saliya Uduwella 2010/08/03 1 2 4
    14 Hasindu Bimsara 2008/02/14 3 1 2
    15 Harindu Damsara 2010/04/13 1 2 1

    Grade Village transport


    Transportation
    Id Grade Id village Id
    method
    1 6 1 Padaviya 1 Bus
    2 7 2 Bulnewa 2 foot
    3 8 3 Medawachchiya 3 Motor bicycle
    4 9 4 Mihintale 4 Bicycle
    5 10 5 Nochchiyagama 5 School van
    6 11 6 Palugaswewa

    Create a database named “kebithigollewa_school” and insert these data to tables graphically.

    After you created the database, the principal wanted to check your database for bugs. He has given you some
    scenarios. Read them carefully and write queries to get results.

    1. Select all students who study in grade 06. (Use join query)
    2. Select birthdays of the students who come from padaviya by bus.
    3. Select names of the students who study at grade 09 and come from Mihintale on foot.

    You might also like