Homework Help Question & Answers

In this assignment, you will practice what your instructor taught in Week 6.  The assignment is worth 100 points. (50 P...

In this assignment, you will practice what your instructor taught in Week 6.  The assignment is worth 100 points.

  • (50 Points)Create a new database in SSMS. This database should contain two relations with a primary to foregin key relationship.  Next, create a database diagram for these relations using SSMS as described in the lecture.  The relations can describe any reasonable business process (e.g. Employees-Dependents, Advisors-Students, Students-Interests, etc). Populate these relations with 10 records per relation.  
  • (50 points) Script your new database as described in the lecture.  Save your script (schema and data) in the following name format: “Lastname-DBCreateScript” (e.g. Davis-DBCreateScript).

   

0 0
Next > < Previous
ReportAnswer #1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

This demonstration is using SQL Server 2014.Database and Tables are created using SQL Server Management Studio (SSMS).

This database maintains records about the trainers and Training that has been taken in the different organizations.

Database :

--create database
create database Davis_DBCreateScript;

--use database to create tables
use Davis_DBCreateScript;

Tables :

1.Table Name :TrainersDetails

--1.Table Name : TrainersDetails
Create table TrainersDetails(
TID int primary key,
TName varchar(100) not null,
Experience decimal(4,2) not null check (Experience > 2),
skills varchar(100) not null,
address text
);

/*Inserting records into TrainersDetails*/
insert into TrainersDetails values(1,'Rohan',3.3,'MS Azure','Berlin');
insert into TrainersDetails values(2,'Ganesh',18,'DBMS','US');
insert into TrainersDetails values(3,'Mahesh Sabnis',18,'Angular 7','Chennai');
insert into TrainersDetails values(4,'Ajinkya Rahane',5.6,'MongoDB','Hyderabad');
insert into TrainersDetails values(5,'KL Rahul',2.2,'Responsive web Design','Bangluru');
insert into TrainersDetails values(6,'Sanju Samson',2.2,'Node.js','Kochi');
insert into TrainersDetails values(7,'Eoan Morgan',7.7,'Node with ExpressJS','Jaipur');
insert into TrainersDetails values(8,'Hardik Pandey',4.4,'Full Stack','Badoda');
insert into TrainersDetails values(9,'Virat Kohli',3,'Cricket coaching','Pune');
insert into TrainersDetails values(10,'Savroav',15.1,'DBA','Kolkatta');

/*selecting records*/
select * from TrainersDetails;

Screen in SSMS :

100% Messages Results TID TName Experience skills address 1Rohan 1 3.30 MS Azure Berin 2 Ganesh 18.00 DBMS US Mahe... 18.00 A

*****************************

2.Table Name :TrainingsDetails

/*2.Table Name :TrainingsDetails*/
create table TrainingsDetails (
TDID int primary key,
TDName varchar(100) not null ,
TID int not null,
Client varchar(20) not null,
Availability char(4) not null,
TrainingDate date,
foreign key (TID) references TrainersDetails(TID)
);


/*insert records into TrainingsDetails table*/
insert into TrainingsDetails values (101,'JavaScript Basics',1,'NCA Bangluru','NO','02/10/2018');
insert into TrainingsDetails values (102,'MongoDB',1,'Fujitsu Pune','Yes','03/11/2018');
insert into TrainingsDetails values (103,'Mean Stack',9,'HCL Chennai','NO','02/12/2017');
insert into TrainingsDetails values (104,'Getting Started with Angular 7',3,'Microsoft USA','Yes','12/05/2019');
insert into TrainingsDetails values (105,'Cricket Speech',2,'NCA Bangluru','No','01/05/2019');
insert into TrainingsDetails values (106,'Docker Contrainer',10,'JP Mogran Mumbai','Yes','04/02/2019');
insert into TrainingsDetails values (107,'.NET',7,'Sama Software Nashik','Yes','06/06/2019');
insert into TrainingsDetails values (108,'Database',8,'SKS Software Pune','Yes','02/10/2018');
insert into TrainingsDetails values (109,'Angualr 5',2,'NCA Bangluru','Yes','05/05/2019');
insert into TrainingsDetails values (110,'Full stack Development',1,'C2L Solutions','Yes','07/07/2019');

/*selecting records*/
select * from TrainingsDetails;

Screen in SSMS :

100% Results Messages Availability TDID TDName TID Client Training Date NCA Bangluru 2018-02-10 1 101 JavaScript Basics 1 NO

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.

Know the answer?
Add Answer of:
In this assignment, you will practice what your instructor taught in Week 6.  The assignment is worth 100 points. (50 P...
Your Answer: Your Name: What's your source?
Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • python 3 question Project Description Electronic gradebooks are used by instructors to store grades on individual assignments and to calculate students’ overall grades. Perhaps your instructor uses gr...

    python 3 question Project Description Electronic gradebooks are used by instructors to store grades on individual assignments and to calculate students’ overall grades. Perhaps your instructor uses gradebook software to keep track of your grades. Some instructors like to calculate grades based on what is sometimes called a “total points” system. This is the simplest way to calculate grades. A student’s grade is the sum of the points earned on all assignments divided by the sum of the points available...

  • Draw an E-R diagram that captures the information about the “Academic

    x.øi5SPRING SEMESTER 2009DATABASE MANAGEMENT SYSTEM (CS403)MODULE: 02Marks: 20©Virtual University of Pakistan1OBJECTIVES:1. Development of Conceptual Database design in E-R Data model.2. Preparing the students for implementing and realizing the system forExternal view of Database.3. Finding of Entity Types, their attributes, Cardinalities, Relationships b/wthem, Roles in ER in System.4. Understanding of Normalization process.I NSTRUCTIONS:1. You are allowed to consult the online material2. Do not copy and paste other wise your case shall be submitted to unfairmeans committee. Copy and pasted material from...

  • cs403

    x.øi5Objectives:Development of physical Database design.Understanding of DDL and DML SQL commands.Understanding of mapping of logical design to physical design.Functions in SQLI NSTRUCTIONS:You are required to read roles &responsibilities of each entity mentioned in previous CS403_spring2009_module2.You are allowed to consult the online materialDo not copy and paste other wise your case shall be submitted to unfair means committee. Copy andpasted material from any source will be awarded zero marks.Please use a 12-point font in Times New Roman or Arial.The Assignment includes...

  • cs403

    x.øi5Objectives:Development of physical Database design.Understanding of DDL and DML SQL commands.Understanding of mapping of logical design to physical design.Functions in SQLI NSTRUCTIONS:You are required to read roles &responsibilities of each entity mentioned in previous CS403_spring2009_module2.You are allowed to consult the online materialDo not copy and paste other wise your case shall be submitted to unfair means committee. Copy andpasted material from any source will be awarded zero marks.Please use a 12-point font in Times New Roman or Arial.The Assignment includes...

  • Data base management System

    x.øi5strong>Objectives:Development of physical Database design.Understanding of DDL and DML SQL commands.Understanding of mapping of logical design to physical design.Functions in SQLI NSTRUCTIONS:You are required to read roles &responsibilities of each entity mentioned in previous CS403_spring2009_module2.You are allowed to consult the online materialDo not copy and paste other wise your case shall be submitted to unfair means committee. Copy and pasted material from anysource will be awarded zero marks.Please use a 12-point font in Times New Roman or Arial.The Assignment includes...

  • Hello, Thanks for the response I got the idea now for the teaching practices but what would be an example for 3 teaching practices that undermine academic achievemtn

    Hello, Thanks for the response I got the idea now for the teaching practices but what would be an example for 3 teaching practices that undermine academic achievemtn. ThanksEditor's Choice: Valuing Diversity—Student-Teacher Relationships that Enhance Achievement Community College Review, Summer, 2000 by Linda Olson JacobsonBased on experience as a developmental writing teacher, the author describes strategies for promoting student success within diverse groups of learners. After discussing how teachers can innocently contribute to student failure, the author describes specific ways...

  • Hello, Thanks for the response I got the idea now for the teaching practices but what would be an example for 3 teaching practices that undermine academic achievemtn

    Hello, Thanks for the response I got the idea now for the teaching practices but what would be an example for 3 teaching practices that undermine academic achievemtn. Thanks Editor's Choice: Valuing Diversity—Student-Teacher Relationships that Enhance Achievement Community College Review, Summer, 2000 by Linda Olson JacobsonBased on experience as a developmental writing teacher, the author describes strategies for promoting student success within diverse groups of learners. After discussing how teachers can innocently contribute to student failure, the author describes specific...

  • objective The Milestone Assignments are based on the Projects and Cases for use with the Systems Analysis and Design Methods textbook by Whitten & Bentley

    objective The Milestone Assignments are based on the Projects and Cases for use with the Systems Analysis and Design Methods textbook by Whitten & Bentley. There are six (6) parts to the Project, consisting of twelve (12) milestones. During Weeks 2-7, you will be required to complete two (2) milestones. Each milestone is worth 40 points. Milestones 5 and 10 are included as already completed work, so you only need submit them as part of the assignment. Guidelines Be sure...

Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
Share Your Knowledge

Post an Article
Post an Answer
Post a Question with Answer

Self-promotion: Authors have the chance of a link back to their own personal blogs or social media profile pages.