1 / 9

9.0 MICROSOFT SQL SERVER

CHAPTER 9. 9.0 MICROSOFT SQL SERVER. 9.1 Creating Database- Sample Clinic Database . 9.2 Query Analyzer. Visual Programming. Chapter 9. 9.1 Creating Database – Open MS-SQL server as follows: Select Start->All Programs-> Microsoft SQL Server -> Enterprise Manager. Visual Programming.

lizina
Télécharger la présentation

9.0 MICROSOFT SQL SERVER

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CHAPTER 9 9.0 MICROSOFT SQL SERVER 9.1 Creating Database- Sample Clinic Database 9.2 Query Analyzer

  2. Visual Programming Chapter 9 9.1 Creating Database – Open MS-SQL server as follows: Select Start->All Programs-> Microsoft SQL Server -> Enterprise Manager

  3. Visual Programming Chapter 9 9.1 Creating Database – Sample Clinic Database

  4. Visual Programming Chapter 9 9.1 Creating Database – Sample Clinic Database

  5. Visual Programming Chapter 9 9.1 Creating Database – creating Patient table

  6. Visual Programming Chapter 9 9.1 Creating Database – creating Patient table columns (PatientNo, PatientName, PatientIC, etc.) and save as Patient

  7. Visual Programming Chapter 9 9.1 Creating Database – creating Patient table New Table – to create another table Design Table – to open the existing table and modify the structure of the table Open Table – Return All Rows – to add, edit or view data

  8. Visual Programming Chapter 9 9.1 Creating Database – Patient table – input data Key in data for all columns and data will be saved upon exit the table.

  9. Visual Programming Chapter 9 9.1 Creating Database – creating other tables • Repeat the same process from page 249 until 252 to create another table for a Clinic database. • The other table are Doctor, Medicine, Payment, and Appointment. You must also key in at least five records for each of the table.

More Related