Example Of Primary Key Computer Science Essay

typesetters case Of master(a) Key Computer Science EssayDatabase is a structure that is largely divided in two respects, namely a flat entropybase and a relational database. Relational database easier to understand than the flat database. Because relational database has a simple formula and it is easy to do data operations. Database also has a relational structure found in display panels to store data. On each defer is it consists of editorials and run-ins and a tug to define the type of information that should be more thanoverd. Basic solelyy the database is very useful when the time to retain the information that will be categorized logically. For theoretical account, if you want to save the information on the data, the database enterprise or school, it stand be in a group with matters in business become more sidesteps. In the database thither is some relationship, the relationship is as 1 to one, many to many, one to many,Primary KeyThe constitute is a set of colu mns that preserve be use to notice or memory access a cut officular row or rows. Identified key explanatory mesas, indexes, constraints or reference. The same column pot be part of more than one key.A quaint key is a key that is constrained so that no two values argon the same. Unique key columns cannot contain NULL values. For example, the column number of employees can be defined as a quaint key, because each value in column identifies altogether one employee. No two employees can have the same number of workers.The mechanism used to enforce uniqueness of the so-called index unique key. Unique index table is a column, or a collection of ordered columns, each of which identifies value (specify function) unique rows. A unique index can contain NULL values.The key is one unique key defined on the table, but was selected as the first significant key. There can be only one primary key on the table.A primary index is automatically created for the primary key. The main index use d by the database manager for efficient access to table rows, and allows the database manager to enforce the uniqueness of the primary key. (You can also specify non-primary index key columns efficiently access the data when processing the query.)If the table does not have a natural unique key, or if the order of arrival is a method used to eliminate unique rows, use a time stamp as part of the key can help.Example of Primary KeyPROJNO (Primary Key)PROJNAMEDEPTNOMA2100Weld Line mechanisationD01MA2110Weld Line ProgrammingD11Example 1If each column in the table contains duplicate values, it cannot determine the key with just one column. A key with more than one column is a entangled key. The combination of column values should define a unique entity. If a composite key cannot be easily defined, it can also be considered to create a new column with unique values.EMPNO(Primary Key)PROJNO(Primary Key)ACTNO(Primary Key)EMPTIMEEMSTDATE(Primary Key)000250AD3112601.01982-01-01000250AD3112 6051982-02-01000250AD31127051982-02-01Foreign KeyA foreign key is a line in a table corresponding relationship with the early(a) candidate key table. Foreign keys can be used to cross-reference table.For example, suppose we have two tables, node that includes all customer data, and the order table that includes all customer orders. Intention here is that all orders must be associated with a client who is in the customer table. To do this, we will place a foreign key in the order table and it relates to the key customer table.Identifying foreign key column or set of columns in a table that refers to a column or set of columns in another table. Column in the table must reference the key pillars or other crack key in the referenced table. Value in a reference column line must occur in a single row in the referenced table. Thus, a row in the reference table cannot contain values that do not exist in the referenced table (except potentially null). In this way a reference can be made to link information together and it is an important part database normalization. Various rows in the table reference may refer to the same row in the referenced table. Most of the time, it reflects a (parent table or reference table) to many ( shaver table, or referencing table) relationship.Example Foreign KeyBelow is an example of the relationship betwixt the Company and also schedules, Contact. Tables in the company is the parent of a link. In child contact schedule, Field CompanyID the table to show the contact contacted the company owned.The role of the Son (Multiplicity)Diversification foreign key defines how many records in the child table can link to records in the master table. In the above example the childs diversity since a company can have any number of contacts.ExamplePrimary Key Foreign Key RelationshipIt have a Primary Foreign Key, in this figure it have a relationship between this two keys. e.g.One to One , One to Many , Many to Many.Primary key.This is indicated by the Primary Key field equivalent to the schedule. this shows that the field that identifies a unique record. For example, Product_ID product and ORDER_ID for Order the values that are normally produced by the field is Auto-rise. they do not have any intrinsic meaning and only integers are automatically generated one by one.Primary Key and Foreign Keys.This indicated that the PF with the field in the table.In this case, the field is also created as a key example of this attitude in the Schedule of Key, Primary Key in Table Customer_Orders_Products is a composite key, consisting of two fields. The product_id is the Primary Key in the table Products, and ORDER_ID is the Primary Key in the table Customer_Orders.One-to-Many Relationship.One-to-Many very common in the real world, and it is very easy to read that A Parents can have a broadcast of children. In this figure shows that, One Product can be attributed to Customer_Orders_Products the Many. The line between product and Custom er_Orders_Products is continuous line (not small dotted lines). This means that the product_id field is the Primary Key in Table Customer_Orders_Products. A dotted line will show the existence of a Foreign Key.Many-to-Many Relationships.Relationship Many-to-Many very important in the real world, and being able to see them all around us every day. For example, many customers may order the same product. Many products can be ordered by the same customer. This is called Relationship Many-to-Many. It can not be implemented directly in the Database Table relationships. The solution is to create an talk terms table that records all the combinations that exist between the Customer and Product. For example, if a customer who ordered three products, then there will be three records for that customer in an intermediate table. Low key combination to be a parent table primary key intermediate in this table. We also command to allow for comments like Make it stronger,. If we get to the right da tabase structure, then it is very easy to extend it.Question 2Explain the main characteristics and advantages of the following terms.a ) Relational Databaseb) prey Oriented Databasec) Object Relational DatabaseRelational DatabaseCan be connected to a database with a collection of data items is strongly recommended as a set and the name of the Minister of Finance official explained from Any data easily accessible. A database was created use the prototype relations relationship. The software used in database relations database management system called Relations. A relationship database is the preferred choice in storing data, as compared to other models such as the hierarchical database model or network model. The first database is been commenced in 1970, namely by Edgar Codd.Advantages of Relational DatabaseAvoid ErrorThere is only a single storage repair for any piece of information, sodata update is easy without having to change the same information in 15 different files.info i s always up to date there is no chance of remaining old data in some forgotten file.Number and dateno typos such as 10, 10, 10, not 10.avoid problems such as data type in Excel dreaded syndrome.avoid unwanted textual matter-to-date conversion like November 12 to be November 12 1900.Error checking data as they are enteredvalidated data on data entry, to filter the im workabledata can be cross-checked against real information.Manipulate DataWith databases it can combine different data easily. No more error-prone cut-and-paste to force data into different formats. Do away with all intermediate Excel spreadsheet that is often generated when manipulating data. (And which you often darent delete just in case they contain important information.)Data manipulation is done by using a query. This means Structured Query Language, SQL, to merge, update and manage data, but most users do not need to know any SQL to perform complex tasks. In Microsoft Access, for example, Visual Query Builder p rovides a simple, intuitive interface makes most queries.Visualize DataA database is being adjusted can endanger new areas for investigation to present large quantities of data in an intuitive form.Often the patterns become apparent only by flicking through data. With this special database it is possible in new ways data from many different sources can be brought together and displayed quickly and and fast.Integrate with analysisEnds with an Excel file to a multi-analysis, each subtlety different? Never sure that the correct file is not delete any, just in case.With a relational database, this is the dilemma of the past. Your data set for analysis is created using queries stored in the database. No copy is made of data, but instead you link to query directly from the statistics.Object Oriented Database trim down MaintenanceThe main intent of the object-oriented development is a guarantee that the system will enjoy a longer life while having maintenance be much less. This is becau se most of the processes in the system contained, behavior that can be reused and will be included in the most recent behavior. The ultimate goal is for the new object-oriented developmentReal World ModelingObjects operational system is very prone to model the real world in a more complete fashion than do traditional methods. Objects that have been organized into a class of objects, object-related behaviors. Based on the object, rather than on data and processing onlyImproved Reliability and FlexibilityObject-oriented system to be far more reliable than traditional systems, especially in the new behavior can be built from existing objects. Because objects can be dynamically called and accessible, new objects can be created at any time. New objects can inherit data attributes from one, or many other objects. Behavior that can be inherited from the super-class, and novel behavior can be added without performing the functions of the existing system.Object Relational DatabaseDatabase Ob ject capabilities can be expanded with additional ties and new data types, access methods and functions available in object oriented programming. it can add character mountain chain with alpha-numeric data types. Complex data types can combine features of data types that already exist in the database. here it is able to determine the data type of text containing desired time or with the number of bytes used to create user defined data types can be opaque or own. it can also add user-defined virtual processors.EncapsulationBy using encapsulation of database object you want to contact in the form of a table. For example, Table 1 includes the name, address, phone number and email address for contact. Through class encapsulating Contacts, it just combines all this information in a table on this one. So when you query the database for this information, you generate a field of study in a style designed to include all of this information.AppendixPROJNO (Primary Key)PROJNAMEDEPTNOMA2100W eld Line AutomationD01MA2110Weld Line ProgrammingD11EMPNO(Primary Key)PROJNO(Primary Key)ACTNO(Primary Key)EMPTIMEEMSTDATE(Primary Key)000250AD3112601.01982-01-01000250AD31126051982-02-01000250AD31127051982-02-01