Blogger Text

My Aim to Provide you quality contents, Tips & Tricks, Software, Microsoft Office, Graphic Editing (Adobe PhotoShop, After Affects, Illustrator, inDesign) Corel Draw, Corel Video Studio, Cyberlink PowerDirector, Power ActionCinema, Tutorials about Blogging and VU Assignments, Quizes & GDB Solutions and Much More... at regular Basis
                                     ***    Kindly Subscribe our Official YouTube Channel "INFOPALACESS OFFICIAL-Tuts: in this channel we upload Programming (C,C++,C# JAVA, PHP), Web Development, Graphics Editing and Microsoft Office Step by Step Tutorials from bigginer to Advance Level. We also provide free online courses at our YouTube Channel. ***   Graded Assignments/Quizes and GDB will start in Next Week. Solution ideas of All assignments, Quizes and GDB will be available here. If you have any problem regarding this then you can contact us.

CS403 Assignment No 3 Spring 2019 Solution

 Info!  Please Don't Make 100% copy of your assignment Solution. Make some changes so that your solution look differrent than other students. If you make Exact copy of then you can get marks zero.


Database Management System: Solution of CS403 Assignment No 3 2019 Due Date 20-07-2019

Solution of Assignment is Given Below;


Problem Statement:   Our third assignment is the continuation of the second assignment. In the second assignment, we convert the ERD into a relational data model. The relational data model is given below:

Role(Role_id, name)

User(User_id, name, Role_id)

Task(Task_id, title, creation_date, deadline, assigned_to)

DiscussionThread(Thread_id, Task_id, title)

Messages(Msg_id, Thread_id, message_body, sender_id)

Note:

1. You have to provide the snapshot of each task; otherwise your assignment will be graded zero.
2. You have to write different SQL Queries only in order to perform the given tasks.
3. Every Query and its execution snapshot are required in each task.

You’re required to perform the following tasks according to above relational data model.
1. Convert the above relational data model into a physical data model. For which you have to first create a database. So, write a SQL statement which creates a database. The database name should be as your student id. For example, if your student id is BC123456789, then the database name should also be BC123456789. If the database name is different from your student id, then your assignment will be graded zero.

2. After the database creation, you are required to write the SQL queries in order to create five tables in the database. You also have to apply different constraints like primary key constraint and foreign key constraints where applicable.

3. After creation of all the five tables, you are required to add the following records into the Task and DiscussionThread tables by writing the appropriate SQL Query.

4. Write a query that retrieves a record from the Task table whose Task_id is T0003.

5. Alter the table of the DiscussionThread and include the “Status” column in the DiscussionThread table.

Download Assignment file from



Solution:
Just watch the video given below and then Copy and Paste from file given below then Following Querys in MS SQL Server accordingly;

Watch the Video below for step by step guide regarding solution CS403 Assignment 3 Spring 2019



Download Solution File in MS Word File Format




How to Make Changes and Submit file

You need to submit your assignment in doc or docx. Make necessary changes before submission.To make Changes in the file Just watch the video Given above to get step by step guide.

How to Download File

To Download File follow these steps

  • Click on Download Button below in Red Color

  • A pop up window will appear Close the popup window and come back to this page and again click on Download Button.

  • Now you will go to another page in same open tab Wait for 5-6 seconds then click on Skip this Ad at top right Corner. (If again any popup window will appear then close the pop up windows and stay at same tab).

  • In next again you may see another ad again follow the Step 2.

  • That's It you have done it Now download file will come to you.



If you have any Problem regarding your assignment Solution then you can contact Us or leave a Comment below. You can also subscribe our Official YouTube Channel to get guided videos of all assignments, quizes or GDB. You can also join our Official WhatsApp Groups by Click on the links Below.

DescriptionLinks
YouTube Channel:Infopalacess Official Tuts
WhatsApp Group 1:VU Assignments Portal by Infopalacess
WhatsApp Group 2VU Assignments Portal by Infopalacess 2
WhatsApp Group 33- VU Solutions by Infopalacess

Post a Comment

0 Comments