Creating a new database
This presentation is the property of its rightful owner.
Sponsored Links
1 / 4

Creating a New Database PowerPoint PPT Presentation


  • 58 Views
  • Uploaded on
  • Presentation posted in: General

The Sister Cities Database Development Project. Creating a New Database. If you came to this presentation via a web browser, right-click and choose “F u ll Screen” before proceeding. Click mouse or press space bar to continue.

Download Presentation

Creating a New Database

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Creating a new database

The Sister Cities Database

Development Project

Creating a New Database

If you came to this presentation via a web browser,

right-click and choose “Full Screen” before proceeding.

Click mouse or press space bar to continue.

  • This presentation was prepared by Professor Steve Ross, with the advice of other MIS Faculty, for use in MIS Classes at Western Washington University. Please contact Dr. Ross for permission to use in other settings..


Logging into the dsci student dbms

Logging into the DSCI Student DBMS

Before you can log in, your instructor will need to create your account.

  • Open Management Studio and connect to the database engine

  • Enter the DBMS (server name) as shown in the illustration

  • Click Connect


Creating a new database1

Creating a New Database

  • Open Management Studio and connect to the database engine

  • Right-Click Databases, choose New Database…

  • Enter Database name

  • Click OK


Assign users to dbo role

Assign Users to DBO Role

(Note: students no longer have the required permissions to carry out the following steps. Your instructors will do this for you at the beginning of the lab. However, in the meantime, you can continue to work on the project, if the student who created the database is logged in.)

  • Expand Security; then Logins

  • Right-click user name, choose Properties

  • On User Mapping page

    • Select the database

    • Select db_owner role


  • Login