SOLVED CS409 Assignment 2 Solution and Discussion

[zareen]

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;

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

[zareen]

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;

Tasks: Solution

Creating Database

Creating Tables

1. Client Table

2. Event Table

3. Venue Table

[zareen]

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;

Tasks: Solution

Creating Database

Creating Tables

1. Client Table

2. Event Table

3. Venue Table