StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Introduction to Databases - Assignment Example

Cite this document
Summary
It is unaccepted to drop a column that has a primary key constraint which is referenced by any foreign key. For example, dropping the primary key employee_id from the employee table would be unacceptable because it is…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER95.7% of users find it useful
Introduction to Databases
Read Text Preview

Extract of sample "Introduction to Databases"

Introduction to Databases Introduction to Databases Caution must be taken while dropping primary keys of tables. It is unaccepted to drop a column that has a primary key constraint which is referenced by any foreign key. For example, dropping the primary key employee_id from the employee table would be unacceptable because it is being referenced by foreign key employee_id on the job_history table. Secondly, primary keys cannot be defined on columns that accept null values nor duplicate data. Finally, a single table should only have one primary key at most.

A possible solution is to use CASCADE operation while dropping the primary key. This means the DROP operation will be performed not only on the primary key but also on all referencing foreign keys. Secondly, to avoid having null values as primary keys, always specify the primary key to auto increment whenever the database is populated. One foreign key from a table can only refer to a single primary key on another table. Moreover, it is unacceptable for the same foreign key to refer to multiple primary keys.

For instance, department_id on the employee table refers to the primary key department_id on the department table and not the department_id on the job_history table. The data type and values of foreign key that are used in the database schema must match with the data types and values of primary key or unique columns for that matter. The data values of country_id on countries table, say 11, should be the same as that of country_id on the locations table. Similarly, the data type should also be same.

If region_id in the regions table is an integer, then region_id on the countries table must also be an integer and not a double or float.REFERENCESBressan, S., & Catania, B. (2005). Introduction to database systems. Singapore: McGraw-Hill.Way2DB | Constraints - Way2DB. (n.d.). Way2DB - Way2DB. Retrieved August 19, 2012, from http://www.way2db.in/oracle-constraints.html#PrimaryKeyPrimary & Foreign Key Constraints | Database Solutions for . (n.d.). Retrieved August 19, 2012, from http://www.

databasedev.co.uk/primary_foreign_key_constraints.html

Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Introduction to Databases Assignment Example | Topics and Well Written Essays - 250 words - 4”, n.d.)
Introduction to Databases Assignment Example | Topics and Well Written Essays - 250 words - 4. Retrieved from https://studentshare.org/information-technology/1601820-introduction-to-databases
(Introduction to Databases Assignment Example | Topics and Well Written Essays - 250 Words - 4)
Introduction to Databases Assignment Example | Topics and Well Written Essays - 250 Words - 4. https://studentshare.org/information-technology/1601820-introduction-to-databases.
“Introduction to Databases Assignment Example | Topics and Well Written Essays - 250 Words - 4”, n.d. https://studentshare.org/information-technology/1601820-introduction-to-databases.
  • Cited: 0 times

CHECK THESE SAMPLES OF Introduction to Databases

An Introduction to Database Technology and Database Management

An introduction to Database Technology and Database management Author Institution Data, information and knowledge, are correlated and can be defined in terms of each other (Amidon, 1997).... An introduction to Database Technology and Database management Data, information and knowledge, are correlated and can be defined in terms of each other (Amidon, 1997).... databases are used in banks, health facilities and education institutions to provide relevant information about the clients, employees, assets, materials among others....
3 Pages (750 words) Essay

What Databases Are and How They Are Used

hellip; The article provides an overview of what databases are, how they are used, and their advantages and disadvantages.... Table of Contents Abstract 1 Introduction 3 Types of databases 3 databases Management Systems 4 Use and Roles of databases in Organisations 5 References 7 databases Introduction Different experts define the term database differently.... In this sense, Stephens include filing cabinets, the brain and notebooks as databases....
4 Pages (1000 words) Essay

Introduction to Biometric Identification Database

The term "biometrics" is derived from the Greek words "bio" (life) and "metrics" (to measure).... Biometrics is an evolving field of science which deals with establishing the identity of a person based on his/ her biological, anatomical and physiological features like face, fingerprints, handwriting, voice, iris structure, retina, veins, DNA etc....
11 Pages (2750 words) Essay

The Implementation of Databases in a Business

Organizations operating across the globe find it important to use databases and huge computer networks to link their work around the world.... hellip; Every organization looks for the best technology that is available to them according to their needs. Organizations have a fight going on in between each other to reach the top and become the best in the business, this is called competition and leads organization to implement a database to give them an edge over their counterparts. Organizations can't survive with working in international markets with out the help of databases and computers....
3 Pages (750 words) Essay

Are DNA Databases Crossing the Line

This paper "Are DNA databases Crossing the Line" discusses issues that are hotly being contested as regards the moral obligations as well as the technicalities involved in the processes of development of a DNA database to and as it is applicable to a criminal investigation.... hellip; It has concisely and succinctly evaluated the ideas of the pro and con DNA database as the issues have been revolved around and around....
9 Pages (2250 words) Essay

Relational database solution

When you want to add information, such as updating a customers information, you have to reenter all of the information in a new record in the flat file databases table.... The key to success is in the foundation of the databases design.... The many advantages of relational databases can easily be summed into one major advantage: relational databases are dynamic.... In another example, some databases can be locked away from others to ensure that not all information is recalled when accessing a record....
2 Pages (500 words) Essay

Implementing and Managing Large Databases

The paper "Implementing and Managing Large databases" establishes that size of a company's database influences its selection of a DBMS and the database design.... databases ensure that computer programs, select pieces of data in an organized manner.... databases are managed through database management systems (DBMS).... Database technologies are evolving to address the issue of handling large databases.... Many purveyors are addressing the need for databases that support huge amounts of data; usually in the petabyte range (> 1,000 terabytes) (Kavanagh, 2004)....
7 Pages (1750 words) Essay

Introduction to Database Systems

Stored procedure is an SQL code or object that is executed like a query several times in order to achieve different functions or purposes.... hellip; procedures are usually precompiled and can be simple selection query or complex ones to do several tasks like selection, joins, insertion or deletion simultaneously....
1 Pages (250 words) Essay
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us