Ashraf Zalgaonkir
Pearson Cape Town Campus
Introduction to Databases project
Student Number: MB2014-0413
Teacher: Andrew Davies
Due Date: 23/09/2016
2
Contents Page
Page 1…………………………………………..Cover Page
Page 2……………………………………………Contents Page
Page 3-5…………………………………………….Question 1
Page 6-12……………………………………………Optional Access Screenshots
Page 13-18………………………………………….Question 2
Page 19…………………………………………………References and Bibliography
3
Question 1
1.1)
Database
Database is defined as a set of related data in many tables and uses links through something called foreign keys. In a Database product you can create and modify several databases.
DBMS
It stands for Database Management System, it is a concept of rules that all the latest and major database systems follow. So most databases systems follow these rules but some only follow specific rules.
To summarize, a database is an organized data collection or information that happens to be easily accessible, changed or updated. A DBMS is a type of software that may manage and control databases on a PC.
1.2)
Event: Going to the doctor for a check-up.
Database Event: In going for a check-up, the secretary will first see your old computerized records on her PC. She will thus update the record as I go for the
4
check-up. The doctor may check the database records to show him what illnesses or medical problems the patient has been through the previous time the patient went to the doctor. The computerized records will have information such as:
Previous date
Amazon believes in keeping its marketing plan simple in order to be effective. Consequently, their marketing plan is based upon the 4 P’s (product, price, place, and promotion). Amazon’s product is to provide an unparalleled selection of any item that exists on the planet. Its prices are extremely competitive and often lower than traditional stores and it is more convenient for people to shop on the internet (place) than it is in a physical location. Finally, its promotion emphasizes big ideas, innovation, technology, and customer centricity, enabling it to market itself as the most convenient place for consumers to shop and satisfy their needs (Kerin & Hartley, 2015). This strategy targets
A database administration framework (DBMS) is a PC programming application that connects with the client, different applications, and the database itself to catch and dissect information. A universally useful DBMS is intended to permit the definition, creation, questioning, upgrade, and organization of databases.
Regulation placed upon the healthcare system only seek to improve safety and security of the patients we care for. The enactment of the Health Insurance Portability and Accountability Act (HIPPA) and the enactment of Meaningful Use Act the United States government has set strict regulations on the security of health information and has allotted for stricter penalties for non-compliance. The advancement of electronic health record (EHR) systems has brought greater fluidity and compliance with healthcare but has also brought greater security risk of protected information. In order to ensure compliance with government standards organizations must adapt
Abstract- This research documents a comprehensive evaluation of the emerging graph databases along with a benchmark study to compare it to the existing relational model. With the ease of the graphical representation brought in with Neo4j, we saw the opportunity to attempt getting details about the various attributes in the dataset and analyze this data to present a statistical view along with its popular counterpart, MySQL. The ultimate goal of this study is to determine whether a traditional relational database system like MySQL, can be replaced completely in production, by a graph database, such as Neo4j.
Database, it is a place use to store lots of data. It can be seen as a filing cabinet. And database management system (DBMS) is software that specificity designs for managing the data in database such as create, update or delete them. General is including security, retrieval and backup features. User also allows using the data to create a report or share data with multi-user.
Except where indicated, use MySQL Query Browser to perform each operation and print the results.
1) Many small business owners have found it financially advantageous to purchase their own building. As one owner remarked upon his retirement, “We did well with the business, but we made our real money by buying the building.” Explain why this might be so.
Example 1 – Consider the following relational database for the Super Baseball League. It keeps track of teams in the league, coaches and players on the teams, work experience of the coaches, bats belonging to each team, and which players have played on which teams. Note the following facts about this environment:
In order to obtain peer reviewed research articles related to the impact of the psychological contract on job satisfaction in community mental health care workers it is important to review research that has been completed in a variety of researchers and in different settings. The databases that were selected to locate peer reviewed articles for this paper where Academic Search Complete and ProQuest Psychology. Tutorials were available for each of these databases and ProQuest was used to learn how to navigate through the data base since it was not a familiar data base to this author.
Few companies today can exist without an IT department. The IT department contains many of the company’s technology experts. Almost all companies rely on computers to some degree whether it is an international conglomerate or a small startup company. Some companies are very dependent on computer systems while others use them only for accounting for payrolls and everyday computer tasks. Most organization, even the smallest company have people whose job is to make sure that the computer system is up and running or an emergency contact to call when the computer systems goes down. In the future, I want to take the head of a database administrator of an IT department whether the size of the company is small or enormous.
Three types of maintenance plans include: preventative, corrective, and adaptive maintenance which improve the data quality. Activities to improve data quality include database backups, integrity checks, optimizing the index. Preventative maintenance incorporates creating and continuously maintaining daily and/or weekly backups for data loss prevention, corrective maintenance ensures system errors are corrected. One activity associated to corrective maintenance includes resolving deadlocks, which occurs when two or more tasks permanently block each other. Adaptive maintenance includes enhancing system and database performance via based on utility assessments and optimized queries to improve performance. (Coronel, Morris, & Rob., 2013).
Personal privacy today is a controversial and complex topic, which is influenced by a number of factors. There is an integral role that databases play in this highly debated topic. The fact that many people now carry out their transactions electronically is another important factor. There is also pressure on personal privacy for increased national security around the world to combat terrorism. In addition, personal privacy is even threatened by commercial factors and the Internet.
Briefly explain following designing requirements that are required when designing the Hardware and Software infrastructure:
What is database management system? Database Management System is a database program. The DBMS manage incoming data, organize it, and provided ways for the data to be modified or extract by users or other programs. This cause, most database software comes with an Open Database Connectivity (ODBC) driver that allows the database to integrate with other databases. For example, common SQL statements such as SELECT and INSERT are translated from a program's proprietary syntax into a syntax other databases can understand. Some DBMS examples include PostgreSQL, MySQL, SQL Server, Microsoft Access, Oracle, FileMaker, RDBMS, dBASE, Clipper, and FoxPro. It is a software system that uses a standard method of retrieving, and running queries on data.
-if appropriate storage is not there our whole database will crash due to less storage because