CS409 Assignment 2 Solution and Discussion


  • Cyberian's Gold

    Assignment No. 02
    

    SEMESTER FALL 2019
    CS409- Introduction to Database Administration
    Total Marks: 20

    Due Date: 29/11/2019
    Instructions
    Please read the following instructions carefully before solving & submitting assignment:
    It should be clear that your assignment will not get any credit if:
    o The assignment is submitted after the due date.
    o The submitted assignment does not open or the file is corrupt.
    o The assignment is fully or partially copied from (other student or ditto copy from handouts or internet).
    o The student ID is not mentioned in the assignment File or name of file is other than student ID.
    o The assignment is not submitted in .doc/docx format.
    Uploading instructions
    Your submission must include:

    • Assignment should be in .doc/docx format.
    • Save your assignment with your ID (e.g bx020200786.doc/docx).
    • Assignment submission through email is NOT acceptable

    Objective

    The objectives of this assignment are,

    • To give students the idea of the most commonly used RDBMS for designing physical database systems i.e. SQL Server.
    • To build and manage tables in SQL Server.
    • To apply constraints e.g. Primary Key and Foreign Key on attributes.

    Lectures Covered: This assignment covers topics discussed in Week # 04-05

    Deadline
    Your assignment must be uploaded/submitted on or before 29/11/2019.

    Task Description:

    This Assignment is related to Development phase and in this assignment you will focus only on the tasks given below:
    Consider the following ER Diagram and perform the given tasks;

    97ecee5b-8090-44e8-abbb-d4792f9d1d85-image.png

    Tasks:

    1. Follow the procedure explained in audio lectures to open the SQL Server and create a database with the name “Events”.
    2. You are required to transform all entities into tables by using design view method.
    3. You have to transform all entity attributes into columns.
    4. Define appropriate data types of each attribute.
    5. Apply necessary constraints on attributes.
    6. Take screenshots of every step and paste them in your solution file (.doc/docx file).

    For any query about the assignment, contact at [email protected]

    GOOD LUCK


  • Cyberian's Gold

    This Assignment is related to Development phase and in this assignment you will focus only on the tasks given below:
    Consider the following ER Diagram and perform the given tasks;
    97ecee5b-8090-44e8-abbb-d4792f9d1d85-image.png
    Tasks: Solution

    Creating Database
    b975f726-020f-4c1d-b30c-6c41227dae97-image.png ab7e294c-1143-4720-8da5-9627ab0f1984-image.png

    Creating Tables

    1. Client Table
    36537b81-d04c-457a-b541-812ff1083377-image.png
    2c334d37-c5dd-42a0-a989-75b0eb90410f-image.png

    2. Event Table
    365d56ba-6d4b-4dae-9aca-cb6fae482c1f-image.png aee523b1-86c0-4ada-a24a-286247fc3ece-image.png

    3. Venue Table
    4191e19d-4f86-429e-80ca-d8c18b6639ef-image.png 91c55585-fcfb-4ba1-9165-669f871562d3-image.png b46ac29e-9b67-4695-b774-2c75d4d4f488-image.png


  • Cyberian's Gold

    This Assignment is related to Development phase and in this assignment you will focus only on the tasks given below:
    Consider the following ER Diagram and perform the given tasks;
    97ecee5b-8090-44e8-abbb-d4792f9d1d85-image.png
    Tasks: Solution

    Creating Database
    b975f726-020f-4c1d-b30c-6c41227dae97-image.png ab7e294c-1143-4720-8da5-9627ab0f1984-image.png

    Creating Tables

    1. Client Table
    36537b81-d04c-457a-b541-812ff1083377-image.png
    2c334d37-c5dd-42a0-a989-75b0eb90410f-image.png

    2. Event Table
    365d56ba-6d4b-4dae-9aca-cb6fae482c1f-image.png aee523b1-86c0-4ada-a24a-286247fc3ece-image.png

    3. Venue Table
    4191e19d-4f86-429e-80ca-d8c18b6639ef-image.png 91c55585-fcfb-4ba1-9165-669f871562d3-image.png b46ac29e-9b67-4695-b774-2c75d4d4f488-image.png



Quiz 100% Result Quiz 100% Result
| |