Premium Essay

Data Base

In: Computers and Technology

Submitted By Drunkenfrog
Words 4347
Pages 18
Database Design

Table of Contents
CHAPTER 1 .............................................................................................................................................. 2 INTRODUCTION ................................................................................................................................... 2 DATABASE MANAGEMENT SYSTEMS .................................................................................................. 2 Database ......................................................................................................................................... 2 Database Management System (DBMS) ......................................................................................... 2 Schemas, Instances and Data Independence.................................................................................. 3 DATA MODELS..................................................................................................................................... 3 Hierarchical Model .......................................................................................................................... 3 Network Model ............................................................................................................................... 4 Relational Model ............................................................................................................................. 5 CHAPTER 2 .............................................................................................................................................. 5 ANALYSIS AND DESIGN........................................................................................................................ 5 Requirements .................................................................................................................................. 5...

Similar Documents

Free Essay

Data Base

.... | Field name | Data type | Field description | AccountNum | NUMBER(5,0) | Unique identifier of a customer | Name | VARCHAR2(50) | Name of the customer. This name is printed on documents, such as invoices and account statements. | InvoiceAccount | NUMBER(5,0) | Invoice account, to which the customer is linked. The invoice account is the account to which the invoice amount is debited. In the event there is not a specific invoice account, the customer’s account is used in this field. | CrediMax | NUMBER(8,0) | Maximum amount that the selected customer is allowed to have as an outstanding account balance.This amount is always stated in the default currency of the customer. | CountryRegionId | INTEGER | Country/region of the customer address. | Address1 | VARCHAR2(100) | First part of street or postal address line | Address2 | VARCHAR2(100) | Second part of street or postal address line | City | VARCHAR2(50) | City of the customer address | ZIpCode | VARCHAR2(5) | Postal/ZIP code of the customer address. This code is often used for searching and sorting. | State | VARCHAR2(2) | State of the customer address. This field is often used for searching and sorting. | Telephone | VARCHAR2(20) | Customer’s contact telephone number | PaymMode_Typical | INTEGER | Stored, typical payment mode of the customer. Related to PaymMode table | LineOfBusinessID | INTEGER | Customer’s type of business. Used for reporting....

Words: 799 - Pages: 4

Premium Essay

Data Base

...ΣΤΑΥΡΟΠΟΥΛΟΣ ΒΑΣΙΛΕΙΟΣ-ΟΡΕΣΤΗΣ (ΑΜ : 3070249) ΕΡΩΤΗΜΑ Α 1. SELECT FirstName,LastName FROM Employees WHERE SUBSTRING ( LastName, 1 , 1 )>= 'F' AND SUBSTRING ( LastName, 1 , 1) = 2; 2. SELECT City, COUNT(DISTINCT EmployeeID) AS NumberOfEmployees FROM Employees WHERE Title = 'Sales Representative' GROUP BY City HAVING COUNT(EmployeeID) > = 2 ORDER BY NumberOfEmployees ΕΡΩΤΗΜΑ Γ 1. SELECT o.OrderID, n.ContactName, e.FirstName AS EmployeeFirstName, e.LastName AS EmployeeLastName, o.OrderDate FROM Orders o JOIN Employees e ON (e.EmployeeID = o.EmployeeID) JOIN Customers n ON (n.CustomerID = o.CustomerID) WHERE o.OrderDate > '1998-03-01' ORDER BY n.ContactName; 2. SELECT COUNT(DISTINCT Employees.EmployeeID) AS NumberOfEmployees, ISNULL(Employees.Country, 'None.') AS Country, COUNT(DISTINCT Customers.CustomerID) AS NumberOfCustomers, Customers.Country FROM Employees RIGHT JOIN Customers ON Employees.Country = Customers.Country GROUP BY Customers.Country, Employees.Country ORDER BY NumberOfEmployees DESC, NumberOfCustomers DESC; ΕΡΩΤΗΜΑ Δ 1. SELECT Address, Code, Country FROM Suppliers UNION SELECT Address, Code, Country FROM Customers UNION SELECT Address, Code, Country FROM Employees ORDER BY Country; 2. SELECT AVG(OD.Quantity) AS AverageQuantity, SUM(OD.Quantity * OD.UnitPrice) AS TotalOrderAmount, DATEDIFF(yy, e.BirthDate, e.HireDate) AS HireAge FROM [Order Details] OD JOIN Orders o ON ( OD.OrderID =O.OrderID) JOIN......

Words: 298 - Pages: 2

Free Essay

Data Base

...Week 1 Relational Database Creation Anita A Basdeo XACC/210 November 9, 2014 DONNA TENNYSON In this paper I will be creating a relation database from Scratch, it will show you the table that have common keys filed. Referring to chapter Four In order to create a relation database we have to make sure that we “enables designers to identify relationships at the time the database is first created, or later, as users discover new informational requirements in the future”. Furry Friend Foundation has been keeping its records on 4 × 6 cards. Over the years, the foundation has had requests from contributors for year-end statements that document their donations to the Foundation for tax purposes. (Usually, donations are given with a particular type of animal in mind—for example, ‘‘for dogs.’’) Now that the number of contributors exceeds 500, the president has decided to develop a database to handle the foundation’s accounting and reporting needs. The following is a sample of some of the records at FFF Table 1 | FFF CONTRIBUTOR FILE | | | LAST NAME | FIRST NAME | STREET ADDRESS | CITY | STATE | Basdeo | Anita | 97 14 129 Street | Richmond Hill | NY | Smythe | Jonathan | 1845 Backpack Lane | Franktown | NV | Lawewnce | Marie | 9190 Teepee Road | Doolittle | NV | Funky | Robert | 5815 Pearly Gate Lane |......

Words: 382 - Pages: 2

Premium Essay

Data Base

...University of Phoenix Material Determining Databases and Data Communications Read Scenario 1 and Scenario 2 below. Write a paper of no more than 1,500 words in which you respond to the questions designated for both scenarios. Scenario 1: You are a marketing assistant for a consumer electronics company and are in charge of setting up your company’s booth at trade shows. Weeks before a show, you meet with the marketing managers and determine what displays and equipment they want to display. Then, you identify each of the components that need to be shipped and schedule a shipper to deliver them to the trade show site. You then supervise trade show personnel as they set up the booths and equipment. After the show, you supervise packing the booth and all the equipment as well as schedule its shipment back to your home office. When the equipment arrives, you check it into your warehouse to ensure that all pieces of the booth and all the equipment are returned. If there are any problems due to shipping damage or loss, you handle those problems. Your job is important; at a typical show you are responsible for more than a quarter-million dollars of equipment. • In Scenario 1: o You need to track data about booth components, equipment, shippers, and shipment. List typical fields for each type of data. Provide an example of two relationships that you need to track. o Do you need a database system? If not, can Excel® handle the data and the output?...

Words: 436 - Pages: 2

Free Essay

Data Base

...Fundamentos Base de Datos 1. Aplicaciones de los sistemas de datos: Las bases de datos son muy usadas y las mas significativas son: • Banca • Líneas aéreas • Universidades • Producción • Recursos humanos • Telecomunicaciones • Tarjetas de crédito • Finanzas • Ventas El uso de base de datos en estas áreas es esencial y hoy la mayoría de las empresas tienen base de datos. Desde los inicios del internet, una de las cosas mas importantes es tener bases de datos porqué te reduce trabajo y hace mejor las cosas, como por ejemplo las librerías, las consultas de estados de cuenta en un banco, etc. 2. Sistemas de Base de Datos Frente a Sistemas de Archivos Para poder cambiar y modificar la información, el sistema debe tener ciertas aplicaciones de un sistema operativo convencional que permite crear nuevos archivos o modificarlos, y para este proceso de almacenamiento se necesita mantener la información en un sistema de procesamiento. Los inconvenientes son : • Redundancia e inconsistencia de datos • Dificultad de acceso a los datos • Anomalías en el acceso recurrentes • Aislamiento de datos • Problemas de integridad (restricciones de consistencia) • Problemas de atomicidad (sujetas a fallo) • Problemas de seguridad 3....

Words: 1102 - Pages: 5

Premium Essay

Data Base

...A database is a collection of data organized in a particular way. Databases can be of many types such as Flat File Databases, Relational Databases, Distributed Databases etc. -------------------------------------------------------------------------------- What's SQL ? In 1971, IBM researchers created a simple non-procedural language called Structured English Query Language. or SEQUEL. This was based on Dr. Edgar F. (Ted) Codd's design of a relational model for data storage where he described a universal programming language for accessing databases. In the late 80's ANSI and ISO (these are two organizations dealing with standards for a wide variety of things) came out with a standardized version called Structured Query Language or SQL. SQL is prounced as 'Sequel'. There have been several versions of SQL and the latest one is SQL-99. Though SQL-92 is the current...

Words: 6659 - Pages: 27

Premium Essay

Data Base Concepts

...Jonathan Hindman PT2520 Chapter 4 10/18/13 Cardinality: Cardinality refers to the number of allowed instances of a relationship. In the usual cardinality of one to many, for instance, each record on the one side can have zero to any number of records on the many side. Cardinality can be more specific however. Each patron at a library can have only 20 items checked out at once. This has a cardinality of 0 to 20. Composite keys: In database design, a compound key is a key that consists of 2 or more attributes that uniquely identify an entity occurrence. Each attribute that makes up the compound key is a simple key in its own right. Crow’s feet notation: A type of notation for entity relationships in entity relation diagrams that depicts the many side of a relationship with a three-pronged end called a “crows foot.” This type of notation provides more information about the cardinality of a relationship than the arrow notation for relationships. Domain entities: Those database entities that relate directly to the business problem under consideration. Entity relation diagrams: A diagram that shows entities, their attributes, and the relationships among them. Linking entity: An entity used to resolve a many-to-many relationship into two one-to-many relationships. Logical entity: The design of a database without regard to the physical implementation of the database. Lookup entity: An entity used to store lookup values such as state names or zip codes. Maximum......

Words: 1477 - Pages: 6

Premium Essay

Data Base Project

...Abstract In this paper, it will define personal motivation of each employee of the organization or business. The discussion is a brief description of both situations and why he or she would be motivated or unmotivated. The next part of the paper defines how the situation aligns with the various motivational theories. Then the next part defines the specific motivational technique (if any) was at play in the motivational situation. In the case of an unmotivated situation and what technique should be implemented to correct the issue. Personal Motivation A personal motivation starts out with the employer or the organization, which that he or she works for. The personal motivation various theories are about people who have good or bad attitudes about the organization or workplace. Personal motivation is “fundamental to his or hers personal success both in sales and in general life. Given its obvious importance he or she think that people would be experts on motivating themselves wouldn’t people” (Ingram, 2007, p. 1). Motivated and Unmotivated The first topic to explain is a brief description of both situations and motivated and unmotivated. The word motivated means to set goals for the workplace so the employees can look forward to something at the end of the year or quarter. In any business trying to motivate employees could be a difficult task because some employees in general work hard for the...

Words: 977 - Pages: 4

Premium Essay

Good Data Base

...The case says that data visualization is used for contextualizing the data. Companies will use data visualization to give the date they are showing emotional impact. One place where data visualization is currently being used to is monitor what is being talked about on social media. Digg is a populat website right now delivers the most talked about new stores. You are able to read news stories and shoare them at your computer, on your phone, or tablet. You also get daily emails with popular stories. Stack is a program that creates a data visualization of the stories that are on Digg. Stories drop into a graph and as the topic gets more hits, the bar on the graph grows. Below is an picture of Stack. All Stack is showing is what topics are being looked at, and the amount of times a topic is being accessed. This give the viewer of this data visualization information about what people are interested in currently. This is helpful data that is easy to read. If the devlopers of this program would of put poor inofmation, or unneeded information into this data visualization, it would have become much more confusing, and it would no longer be a beneficial to the viewer. This data visualization is quick and easy to view and come to a conclusion on. Poor data just confuses the person who is using the visualization to gain information. At my last job my bosses loved seeing an overview of the different departments....

Words: 553 - Pages: 3

Premium Essay

Data Base Mgmnt

...How important are accurate data for on-line businesses? Accuracy of data is very important for on-line businesses because if the data is at risk it is difficult to manage or handle .The data should be accurate, complete, easily accessible, consistent and relevant as all these characteristics of data promote revenues for the businesses. For example in the case of Media Tech Direct Works it uses the customer contact information i.e. addresses, phone numbers and e-mail addresses to establish points of contacts with its customers and these links has provide sales opportunities and profits for the company. 2. Is technology sufficient to guarantee that data errors will not occur? If not, then what other factors should a business need to consider? Technology helps the organizations to manage their data but it is not sufficient to guarantee that the data errors will not occur because the data degrades over the period of time. In the case of Media Tech they faced the same problem, the customer data was degrading as it was incomplete or obsolete. The factors that a business need to consider is data –scanning and data –matching, with this system the company would be able to identify redundant, fragmented and incorrect data and clean them from the data warehouse. 3. Provide examples of cost savings that can be achieved by reducing data errors?...

Words: 262 - Pages: 2

Premium Essay

Data Base Administrator

...Chapter 1 | | stare decisis | A common law doctrine under which judges are obligated to follow the precedents established in prior decisions. | adjudicate | To render a judicial decision. In the administrative process, adjudication is the trial-like proceeding in which an administrative law judge hears and decides issues that arise when an administrative agency charges a person or a firm with violating a law or regulation enforced by the agency. | administrative agency | A federal or state government agency established to perform a specific function. Administrative agencies are authorized by legislative acts to make and enforce rules in order to administer and enforce the acts. | administrative law | The body of law created by administrative agencies (in the form of rules, regulations, orders, and decisions) in order to carry out their duties and responsibilities. | administrative law judge (ALJ) | One who presides over an administrative agency hearing and has the power to administer oaths, take testimony, rule on questions of evidence, and make determinations of fact. | administrative process | The procedure used by administrative agencies in the administration of law. | Bill of Rights | The first ten amendments to the U.S. Constitution. | binding authority | Any source of law that a court must follow when deciding a case. Binding authorities include constitutions, statutes, and regulations that govern the issue being decided, as well as......

Words: 1324 - Pages: 6

Free Essay

Data Base Esign

...* An entity is something about which we want to keep data. There are physical entities; something physical in our universe (e.g., a person, place, thing, etc.). There is also a logical entity; something non-physical (e.g., a relationship).Three examples of an entity could be a gun, Airline, and a camera. 2. What is a relationship? * A relationship is a logical connection between records from two or more tables. All relationships can be categorized as one-to-one, one-to-many, or many-to-many. An example of a one-to-many relationship would be a pet store owner and the pets. The Pet Store owner (parent) represents the one, and the pets (children), represent the many. That is given the assumption that the store is owned by a single entity. The Pet Store can have many pets, but the pets can’t belong to many stores. * An example of a many-to-many is brand names-to-cookies. There are many brand names and there are many types of cookies. A brand can make many types of cookies and a cookie type can be made by many different brands. 3. What is an attribute? * An attribute is a property or characteristic of an entity. Three entities and their attributes are (A) gun (make, model), (B) airline (name, model), and (C) A camera (make, type). Part Two 3. What column or columns should be selected as the primary key to best meet the desired properties for a primary key in exhibit 2-17?...

Words: 483 - Pages: 2

Free Essay

Data Base Management

...Data dependence Data illustration incorporates with the requisition function. If there is alteration in the Data, then also there is a difference in the application function. Data independence Data depiction incorporates with operation function. If there is a transition in the Data, it won’t cause a shift in the application program. 2. Structured data It is established data which could efficiently be reclaimed and reserved in the databases as well as warehouses. It assign to the substantial case of the user's situation such as phenomenon and development. Unstructured data It consists of combined use of several media data like pictures, sounds, and video clips. Then, it is reserved as the element of the user's field situation 3. Data It is the illustration of articles and episode which are reserved and acknowledged in the system. It persists in a array of form such as numeric, symbols, 3RQ variables, and so on. For example, database in dr's clinic will have information such as patient name, address, diagnosis, symptoms, and phone number. Information These are the refined data which elevates the information of the specific using it. Data are worthless in their current prospective from so it is pre-refined and illustrated as the information to the user 4. Repository It is the rationalised reserved area for data meaning, table, data relationships and other parts of data system....

Words: 689 - Pages: 3

Premium Essay

Data Base Design

...Information Security refers to the processes and methodologies which are designed and implemented to protect print, electronic, or any other form of confidential, private and sensitive information or data from unauthorized access, use, misuse, disclosure, destruction, modification, or disruption. For the scenario , in the above video I feel that different Information security tools must be used by the company to...

Words: 354 - Pages: 2

Free Essay

Data Bases (Spanish

...Fundamentos Base de Datos 1. Aplicaciones de los sistemas de datos: Las bases de datos son muy usadas y las mas significativas son: • Banca • Líneas aéreas • Universidades • Producción • Recursos humanos • Telecomunicaciones • Tarjetas de crédito • Finanzas • Ventas El uso de base de datos en estas áreas es esencial y hoy la mayoría de las empresas tienen base de datos. Desde los inicios del internet, una de las cosas mas importantes es tener bases de datos porqué te reduce trabajo y hace mejor las cosas, como por ejemplo las librerías, las consultas de estados de cuenta en un banco, etc. 2. Sistemas de Base de Datos Frente a Sistemas de Archivos Para poder cambiar y modificar la información, el sistema debe tener ciertas aplicaciones de un sistema operativo convencional que permite crear nuevos archivos o modificarlos, y para este proceso de almacenamiento se necesita mantener la información en un sistema de procesamiento. Los inconvenientes son : • Redundancia e inconsistencia de datos • Dificultad de acceso a los datos • Anomalías en el acceso recurrentes • Aislamiento de datos • Problemas de integridad (restricciones de consistencia) • Problemas de atomicidad (sujetas a fallo) • Problemas de seguridad 3....

Words: 1102 - Pages: 5