Scribd Logo
Upload

Welcome to Scribd!

  • 155 views

    SQL - Data Definition and Data Manipulation Exercise

    Uploaded by

    Melissa Indah Fianty
    This document provides a case study and entity relationship diagram for an e-marketplace website for photographers. It includes entities for customers, photographers, photo portfolios, events to be booked, and payments. Students will work in groups to analyze the case study and design data definition language (DDL) queries to create the tables and data manipulation language (DML) queries to insert, update, delete and retrieve data based on scenarios in the case study. They will take turns writing the SQL syntax for these queries on a whiteboard within a 30 second time limit to practice structuring the queries.

    Copyright:

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

    SQL - Data Definition and Data Manipulation Exercise

    Uploaded by

    Melissa Indah Fianty
    155 views9 pages
    This document provides a case study and entity relationship diagram for an e-marketplace website for photographers. It includes entities for customers, photographers, photo portfolios, events to be booked, and payments. Students will work in groups to analyze the case study and design data definition language (DDL) queries to create the tables and data manipulation language (DML) queries to insert, update, delete and retrieve data based on scenarios in the case study. They will take turns writing the SQL syntax for these queries on a whiteboard within a 30 second time limit to practice structuring the queries.

    Original Title

    07. SQL - Data Definition and Data Manipulation Exercise

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides a case study and entity relationship diagram for an e-marketplace website for photographers. It includes entities for customers, photographers, photo portfolios, events to be booked, and payments. Students will work in groups to analyze the case study and design data definition language (DDL) queries to create the tables and data manipulation language (DML) queries to insert, update, delete and retrieve data based on scenarios in the case study. They will take turns writing the SQL syntax for these queries on a whiteboard within a 30 second time limit to practice structuring the queries.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    155 views9 pages

    SQL - Data Definition and Data Manipulation Exercise

    Uploaded by

    Melissa Indah Fianty
    This document provides a case study and entity relationship diagram for an e-marketplace website for photographers. It includes entities for customers, photographers, photo portfolios, events to be booked, and payments. Students will work in groups to analyze the case study and design data definition language (DDL) queries to create the tables and data manipulation language (DML) queries to insert, update, delete and retrieve data based on scenarios in the case study. They will take turns writing the SQL syntax for these queries on a whiteboard within a 30 second time limit to practice structuring the queries.

    Copyright:

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

    SQL - Data Definition & Data

    Manipulation Exercise
    Session 7
    Course Sub Learning Outcomes
    (Sub-CLO)

    • Student are able to SQL Data Definition and Data


    Manipulation Exercise – (C4)
    ACKNOWLEDGEMENT

    • These slides have been


    adapted from Connolly,
    T., & Begg, C. (2015).
    Database Systems: A
    Practical Approach to
    Design, Implementation,
    and Management. 6th
    edition. Pearson
    Education. USA. ISBN:
    978-1-292-06118-4,
    Chapter 6&7
    LEARNING OBJECTIVES

    • Construct DDL Query from Case


    • Construct DML Query from Case

    vtraining-msuhandi.blogspot.com
    Case
    Information Systems E-Marketplace Photographers

    In this era, photography is the one of desirable job for several


    people. We need professional photographer to capture our special
    moments, such as pre wedding, wedding reception, corporate event,
    birthday party, and so on. Commonly to hire professional
    photographer we deal with Bridal, Wedding O 0rganizer, or directly to
    the photographer based on our relatives. According to our
    technology development, now we can do transaction by using
    internet, and interact directly with sellers. This mechanism we called
    it e-marketplace.
    Anthony is one of photographer who wants to promote her
    portfolio by using internet to attract customers, while Rebecca is one
    of clients who wants to hire professional photographer for her pre
    wedding but she has no time to go to the bridal because she is a busy
    woman with daily activities tight schedule. Based on this situation, a
    group of young entrepreneurs wants to build photographer e-
    marketplace website and wants to use Ms. SQL Server software as
    their database software.
    Photographer
    Customer
    PK PhotographerID Portfolio Album
    PK CustID
    ProtographerName PK PortfolioAlbumID
    CustName PhotographerGender
    CustGender PhotographerAddress FK1 PhotographerID
    CustAddress PhotographerEmail AlbumTitle
    CustEmail Skill CreatedDate
    Instagram Camera Photo
    Facebook Lens Description
    Twitter Equipment
    AccountNumber
    FK1 BankID
    Description

    Here is the Entity


    Relationship Modeling Bank

    that they design to Transaction


    PK BankID

    create photographer PK TransactionID


    BankName

    e-marketplace
    website: FK2
    FK1
    CustID
    PhotographerID
    EventDate
    EventTime
    Duration
    PlaceName
    Location
    BookingDate

    Payment
    PK PaymentID

    FK1 TransactionID
    PaymentDate
    AmountofPayment
    PaymentMethod
    PaymentStatus
    Exercise

    • Make group of 5
    • Analyze case study and answer DDL & DML based
    on your lecturer questions in group about 20
    minutes, but can’t write syntax in Flipchart
    • After that, each group be in line (5 persons in 1 line)
    • Each person in group has 30 second to write syntax
    at flipchart/whiteboard and continue with other
    members

    You might also like