Web Based Hospital Management System-Documentation

Topics: Relational database, SQL, Data modeling Pages: 61 (16141 words) Published: October 26, 2012
The Antelope Relational Database System

Datascope: A tutorial

The information in this document has been reviewed and is believed to be reliable. Boulder Real Time Technologies, Inc. reserves the right to make changes at any time and without notice to improve the reliability and function of the software product described herein. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in any form or by any means, electronic, mechanical, photocopying, recording, or otherwise, without prior written permission of Boulder Real Time Technologies, Inc. Copyright © 2002 Boulder Real Time Technologies, Inc. All rights reserved. Printed in the United States of America. Boulder Real Time Technologies, Inc. 2045 Broadway, Suite 400 Boulder, CO 80302

CHAPTER 1

Overview
Datascope: What is it? ...............................................1 Datascope: Features ...................................................2 Datascope: What is it good for?.................................3

1

CHAPTER 2

Test Drive
What is a relational database? ...................................6 dbe: a window on a database .....................................6 Viewing a table ...........................................................7 Viewing schema information.......................................7 Performing a join........................................................9 What about the join conditions?...............................10 Arranging fields in a window....................................11 Viewing data in a record view...................................12 Other database operations .......................................13 Creating a subset view..............................................14 Using dbunjoin to create a subset database .............15 Editing a database ....................................................16 Simple graphing........................................................17 Summary ...................................................................19

5

CHAPTER 3

Schema and Data Representation
Database Descriptor Files........................................21 Representation of Fields ...........................................22 Schema Description File...........................................23 Schema Statement .....................................................23 Attribute Statement ...................................................24 Relation Statement....................................................25 Datascope Views.......................................................26 Reserved Names for Fields and Tables.....................27 A word of caution regarding id fields .......................29

21

CHAPTER 4

Basic Datascope Operations
Reading and Writing Fields and Records.................31 Deleting Records ......................................................31

31

Datascope: A Tutorial

iii

Subsets ......................................................................32 Sorts ..........................................................................32 Grouping...................................................................32 Joining Tables ...........................................................32 Inferring Join Keys ...................................................34 Inheritance of keys....................................................34 Specifying Join Keys .................................................35 Speed and efficiency..................................................35 Summary ...................................................................36

CHAPTER 5

Expression Calculator
Basic Operators and Database Fields......................38 Data Types ................................................................39 String Operations .....................................................39 Logical Operators.....................................................41 Assignments...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • A Web Based Management System Essay
  • Hospital Management System Research Paper
  • Management System Essay
  • Web Based System Essay
  • Management Info Systems Essay
  • hospital management system Research Paper
  • Proposal for Web Based Ordering and Management System Essay
  • hospital management system Essay

Become a StudyMode Member

Sign Up - It's Free