Creative.docx - Lab Directions Lab 3 1302333 Database...

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
Lab Directions: Lab 3 1302333: Database Systems LAB 3 Group Work with MS SQL Server 2016 Objectives : Practice group work skills. Practice self-learning skills. Practice knowledge summary From researching Practice tracking knowledge about technology with self-learning. Group members list : ( three students per each group ) Group name: Creative 1. Student name kerkchai chotthaisong id 5931302001 Computer-Science 2. Student name peemapod neamkur id 5931302021 Computer-Science Self - study to answer the following questions : 1. What is Microsoft SQL Server 2016? explain 2. How to install Microsoft SQL Server 2016? explain 3. How many database(s) can be created in SQL Server 2016? explain 4. How to create database in Microsoft SQL Server 2016? explain and give one example 5. How many user(s) can be created in SQL Server 2016? Explain 6. How to create user in Microsoft SQL Server 2016? explain and give one example 7. How to create table in Microsoft SQL Server 2016? explain and give one example 8. How to make relationships among table in Microsoft SQL Server 2016? explain and give one example 9. Where is the database stored and why keep in that place? explain Group Answers Question 1: What is Microsoft SQL Server 2016?
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Answer: SQL Server 2016 is a version of Microsoft's relational database management system ( RDBMS ) that first became available in preview releases during 2015, with general availability on June 1, 2016. SQL Server 2016 is a SQL -based database designed to support a mix of transaction processing, data warehousing and analytics applications in enterprise environments. Question 2: How to install Microsoft SQL Server 2016? explain Answer: This article presents the form of installation SQL 2016. From a media or * .iso run the installation file. 1.Locate the Setup file and run. 2.Yes confirm the beginning of the installation process. 3.Start New SQL Server stand-alone installation or add features to an existing installation. 4.Wait for the start of the installation. 5.The next step aims to define authenticity and product licensing - Next. 6.Enable option - "I accept the license terms" and Next. 7.Wait for the installation requirements - Next. 8.You can choose to use the update to check security. Enable according to their way of working. 9.Wait for the installation process. 10.Select the features that will be used. 11.If a problem occurs on the requirements it will be informed during the installation
Image of page 2
12.Clicking on the link Failed detailed information is displayed. 13.In this example it lacked the requirement. 14.So it is recommended to abort the installation go to the manufacturer's website, download Java and perform the requisite installation. After this process start SQL 2016 installation again. 15.Set the type of instance to be used. You use the default instance name. Or an instance according to your need.
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern