Question 2Launch MSSQL program from YOUR computer and ensure command line interface is active. Create a database and name it MyFirstDatabase.Create two tables name Biodata and Contacts, choosing column names, datatypes primary keys and foreign key to link to tables.Insert twenty (20) into each tableTake screenshot of the two tables, each showing all the records and save in a folder (Your name followed by index number).Obtain the ER diagram and save it in the above folder.

Answered: Image /qna-images/answer/2130b5ad-df43-468d-b5fc-21114f4d3776.jpg

Answered: Launch MSSQL program from YOUR computer…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

100%

Question 2

Launch MSSQL program from YOUR computer and ensure command line interface is active. Create a database and name it MyFirstDatabase.
Create two tables name Biodata and Contacts, choosing column names, datatypes primary keys and foreign key to link to tables.

Insert twenty (20) into each table

Take screenshot of the two tables, each showing all the records and save in a folder (Your name followed by index number).
Obtain the ER diagram and save it in the above folder.

Expert Solution

Step by step

Solved in 2 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions