Preview

Relational Database Paper

Satisfactory Essays
Open Document
Open Document
547 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Relational Database Paper
A relationship is an important component of a relational database. A relationship exists between two tables when one or more key fields from one table are matched to one or more key fields in another table. The fields in both tables usually have the same name, data type, and size. It also helps to further refine table structures and minimize redundant data.
The purpose of a query is to retrieve information from a table or tables, which can be based on some type of criteria. To put it simply, a query is designed to get you an answer from data already stored in the database.
I think a few of the most important concepts in a relational database design are: Primary Key (PK) - A column with a unique value for each row. From a design perspective a PK is a requirement. Primary Keys allow you to quickly and easily associate data from multiple tables that are related. Foreign Key (FK) - When you want a row in one table to be linked to a row in another table, you place a FK column in the child table and use the value of the parent row's PK as the value of the FK field. One-To-One
…show more content…
It is important that people understand what they are expected to do, and what role people are expected to fill.
The Project Team can consist of staff within one functional organization, or it can consist of members from many different functional organizations. The Project Team Members are responsible for executing tasks and producing deliverables as outlined in the Project Plan and directed by the Project Manager, at whatever level of effort or participation has been defined for them. This includes the analysts, designers, programmers, etc.
The Analyst is responsible for research and analysis functions which may include budget tracking and financial forecasting, project evaluation and monitoring, maintaining compliance with corporate and public regulations, and performing any data analysis relevant to the

You May Also Find These Documents Helpful

  • Better Essays

    It Management Mgt2 Task 3

    • 4060 Words
    • 13 Pages

    The team member responsible is everyone on the project, with the PM as the lead.…

    • 4060 Words
    • 13 Pages
    Better Essays
  • Satisfactory Essays

    PT2520 Unit7Labs Tramil

    • 330 Words
    • 1 Page

    3. What is a foreign key? This primary key becomes a foreign key when it is repeated in another table to create a link between the tables.…

    • 330 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    I think this relates to database development in a number of ways. One is how it starts, gathering information and finding the intent of the system. Next you must plan out how to set up the database, which is the vital information? What are the minor details? Then you set up your database fill in some test information insure it works properly and make needed adjustments. Finally you implement your database design where in it works properly you merely maintain and fix any errors.…

    • 317 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    8. What is a relational database? A data base that organizes data into overlapping tables. They follow a set of very specific rules that ensure data contained in the database will be consistent.…

    • 421 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    07

    • 4772 Words
    • 25 Pages

    5) The SQL keyword CONSTRAINT is used in conjunction with the SQL keywords PRIMARY KEY and FOREIGN KEY.…

    • 4772 Words
    • 25 Pages
    Good Essays
  • Satisfactory Essays

    Entity-relationship Model

    • 411 Words
    • 2 Pages

    6. One-to-One Relationship - . A one-to-one relationship specifies that for each row in the primary entity, there can be one and no more than one related record in the secondary entity. In a one-to-one relationship, the primary key of the first entity is often the primary key of the second entity.…

    • 411 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    One theme or topic; something of importance to a user that needs to be represented in a database. In the entity-relationship model, entities are restricted to things that can be represented by a single table. An example of this is in the EMPLOYEE table; data about the entity (the employee) is in the table rows and data about the entity’s attributes are in the rows.…

    • 805 Words
    • 4 Pages
    Good Essays
  • Powerful Essays

    In this document there will be an illustration of how to make tables and connecting them with the relationship in a diagram. This information will be worked in MySQL and below will have screenshots to help understand the process. Also throughout this document that will be data types listed some of these are Bit, Int, VarChar, Decimal, and Date (Kinter, 2012).…

    • 2177 Words
    • 9 Pages
    Powerful Essays
  • Good Essays

    Database Paper

    • 672 Words
    • 3 Pages

    Whatis.com (2004) defines a database as "a collection of information that is organized so that it can easily be accessed, managed, and updated." In my current job at Wellco Tank Trucks, Inc., we do not use any type of databases in the daily operations of our business. My only job that involved regular use of a database was at Chilcutt Direct Marketing (CDM) in Oklahoma City, Oklahoma. From February 2003 to June 2004, I was an Account Executive of Brokerage at CDM. CDM is a direct marketing company that manages and brokers customer mailing lists for companies across the United States.…

    • 672 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Project is a temporary attempt to achieve a goal with a start and an end. The output of the project can be a product or a service. Every project will have a team or multiple teams depending on size and tenure of project. To achieve successful output all members of team should possess healthy bonding among each other. Team should foster a collegial environment where individual views are respected and honest dialogue is expected.…

    • 341 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    Database Exam Paper

    • 4799 Words
    • 20 Pages

    TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false. 1) With the introduction of the computer the need for automated tools for protecting files and other information stored on the computer became evident. 2) There is a natural tendency on the part of users and system managers to perceive little benefit from security investment until a security failure occurs. 3) There are clear boundaries between network security and internet security. 4) The CIA triad embodies the fundamental security objectives for both data and for information and computing services. 5) In developing a particular security mechanism or algorithm one must always consider potential attacks on those…

    • 4799 Words
    • 20 Pages
    Powerful Essays
  • Satisfactory Essays

    Studies Matters

    • 609 Words
    • 3 Pages

    In the relational model, ____ are important because they are used to ensure that each row in a table is uniquely identifiable.…

    • 609 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Relational Algebra

    • 3731 Words
    • 15 Pages

    • The basic set of operations for the relational model is known as the relational algebra. These operations enable a user to specify basic retrieval requests.…

    • 3731 Words
    • 15 Pages
    Satisfactory Essays
  • Better Essays

    • In total there are eight operators are found in relational theory, namely SELECT, PROJECT, JOIN, INTERSECT, UNION, DIFFERENCE, PRODUCT and DIVIDE. • Minimally speaking, a DBMS implementation is said to be relational if it supports at least the key relational operators, namely SELECT, PROJECT, and JOIN. •…

    • 1097 Words
    • 5 Pages
    Better Essays
  • Good Essays

    SQL-an analysis

    • 1258 Words
    • 5 Pages

    Although the relational model and relational databases are extremely powerful and flexible - when the programmer knows how to use them, for many, there have been several issues or features that these solutions never…

    • 1258 Words
    • 5 Pages
    Good Essays