amply, to consult a specialist, the patient needs the agreement of his treating physician; to order a prescription, the patient must have at least one valid refill, and so on. Now, what are the main database user groups? Patients should be able to access the database using a web browser to order prescriptions and make appointments. That's all patients can do in the database. Doctors and nurses can browse their patient information, write and refill prescriptions, schedule blood tests and x-rays, and more. Administrative staff (receptionists, pharmacy assistants) can schedule patient appointments, fill prescriptions and generate specific reports. Again, in real life this database would be much more complicated and have many more business rules, but our main goal now is just to give a general idea of the type of information a database might contain . The healthcare provider and order management system databases are both examples of a typical hybrid database (although the former is probably closer to an OLTP). Scientific database A database for genome research and related research areas in molecular and cellular biology can be a good example of a scientific database. It contains gene catalogs for fully sequenced genomes and some partial genomes, genome maps and organism information, and data on sequence similarities between all known genes of all organisms in the database. It also contains information about molecular interaction networks in the cell and about chemical compounds and reactions. This database has only one user group: all researchers have the same access to all information. This is an example of a data warehouse. Nonprofit Database An antique car club database can be quite simple. Additionally, such an organization usually does not have a large number of members and therefore the database will not be very large. You need to store members' personal information such as address, phone number, area of interest, etc. The database can also contain information about automobiles (make, year, color, condition, etc.). Automobiles are linked to their owners (club members). Each member may own one or more vehicles, and a vehicle may belong to only one member. The database would only have a few users – possibly the club president, an assistant and a secretary. The last two examples are not business-critical databases and do not necessarily need to be implemented on expensive enterprise software. Data should always be kept secure and should not be lost, but in the event of, for example, a hardware failure, it will likely be a day or two before the database is restored from a backup . Keep in mind: this is just an example. .Get a custom paper now from our expert writers.Get a custom essay So, using a free database, like MySQL, PostgreSQL or even non-relational Posgres is appropriate. Another good choice could be MS Access, which is part of Microsoft Office tools; If you bought MS Office simply because you want to use Word and Excel, you should know that you also get a relational database.)

Essay / amply, to consult a specialist, the patient needs the agreement of his treating physician; to order a prescription, the patient must have at least one valid refill, and so on. Now, what are the main database user groups? Patients should be able to access the database using a web browser to order prescriptions and make appointments. That's all patients can do in the database. Doctors and nurses can browse their patient information, write and refill prescriptions, schedule blood tests and x-rays, and more. Administrative staff (receptionists, pharmacy assistants) can schedule patient appointments, fill prescriptions and generate specific reports. Again, in real life this database would be much more complicated and have many more business rules, but our main goal now is just to give a general idea of the type of information a database might contain . The healthcare provider and order management system databases are both examples of a typical hybrid database (although the former is probably closer to an OLTP). Scientific database A database for genome research and related research areas in molecular and cellular biology can be a good example of a scientific database. It contains gene catalogs for fully sequenced genomes and some partial genomes, genome maps and organism information, and data on sequence similarities between all known genes of all organisms in the database. It also contains information about molecular interaction networks in the cell and about chemical compounds and reactions. This database has only one user group: all researchers have the same access to all information. This is an example of a data warehouse. Nonprofit Database An antique car club database can be quite simple. Additionally, such an organization usually does not have a large number of members and therefore the database will not be very large. You need to store members' personal information such as address, phone number, area of interest, etc. The database can also contain information about automobiles (make, year, color, condition, etc.). Automobiles are linked to their owners (club members). Each member may own one or more vehicles, and a vehicle may belong to only one member. The database would only have a few users – possibly the club president, an assistant and a secretary. The last two examples are not business-critical databases and do not necessarily need to be implemented on expensive enterprise software. Data should always be kept secure and should not be lost, but in the event of, for example, a hardware failure, it will likely be a day or two before the database is restored from a backup . Keep in mind: this is just an example. .Get a custom paper now from our expert writers.Get a custom essay So, using a free database, like MySQL, PostgreSQL or even non-relational Posgres is appropriate. Another good choice could be MS Access, which is part of Microsoft Office tools; If you bought MS Office simply because you want to use Word and Excel, you should know that you also get a relational database.)

Navigation

« Prev 1 2 3 4 5 Next »

Get In Touch