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

Data Base

...understanding of how SQL works. •Lots of examples with SQL using MySQL that make understanding the process of contructing SQL queries easy and also using MySQL and to illustrate the mechanism of storing and retrieving information from databases. (If you find any errors, please send me an email and I'll promptly set it right. If there's something you'd like to see here let me know too.) -------------------------------------------------------------------------------- What's a database ? 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 universally adopted standard. SQL is the language used to query all databases. It's simple to learn and......

Words: 6659 - Pages: 27

Good Data Base

...1. Poor information is the quickest way to ruin a good database. 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......

Words: 553 - Pages: 3

Data Base

...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? What are the......

Words: 436 - Pages: 2

Data Base Concepts

...implementation of the database. Lookup entity: An entity used to store lookup values such as state names or zip codes. Maximum cardinality: The maximum number of instances of one entity that may be associated with each instance of another entity. Minimum cardinality: The minimum number of instances of one entity that may be associated with each instance of another entity. Naming conventions: Conventions for naming database objects in order to maintain consistency and readability. Physical design: The design of the database within a particular DBMS. The physical design takes account of file systems and disk locations as well as DBMS-specific data types. Surrogate keys: A surrogate key in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data. Triggers: A trigger is a collection of SQL commands that are executed when a database event occurs such as an INSERT, UPDATE, DELETE. Weak entities: In a relational database, a weak entity is an entity that cannot be uniquely identified by its attributes alone; therefore, it must use a foreign key in conjunction with its attributes to create a primary key. The foreign key is typically a primary key of an entity it is related to. Chapter 5 Normal forms: a defined standard structure for relational databases in which a relation may not be nested within another relation. Update anomalies: Database normalization is the process......

Words: 1477 - Pages: 6

Data Base Mgmnt

...1. 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? An example of cost saving that can be achieved by reducing data errors is that a business can save more than $250,000 annually by...

Words: 262 - Pages: 2

Data Base Inthe Wotk Place

...companies have networks composed of servers capable of storing millions of bits of data on their systems. Companies must be able to understand database fundamentals when they decide what database systems they need. When a company obtains data, it must be organized in a readable format so that company personnel can access it from their computers, as it is needed. Databases have become very common in the workplace today. Many organizations use databases to keep track of payroll, vacation time, supply inventories, and other information and for many other tasks too numerous to include in this abstract. Business use database anytime they have large amounts of data they need to search and categorized, so that it can be access later for other uses. In designing and determining the purpose of a database there are two key principles, which need to be considered. The first is duplication of information and the second is the correctness or quality of that information. Duplicate information must be minimized or avoided because it wastes space, increases errors and creates inconsistencies. The second principle, correctness, involves making sure data is entered correctly otherwise any queries and reports generated from the information will also contain incorrect information. Therefore, to ensure their database is good the company must make sure that the data is broken into subject-based tables so that duplicate data can be minimized. They also must make sure that the correct keys......

Words: 821 - Pages: 4

Data Base Esign

...Stephen Favor (CPD121) Assignment Lab 2-3 TR10 1. What is an entity? * 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? * I......

Words: 483 - Pages: 2

Data Base Design

...such as serious embarrassment or inconvenience, identity fraud, lives may even be put at risk. Even if privacy is not in itself a fundamental right, it is necessary to protect other fundamental rights. 3) What role does information security play in this scenario? 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 safeguard the customers personal information. Some of the tools that can be used are: * Campus border firewall :A system designed to prevent unauthorized access to or from a private network. * Encryption. Encryption converts data into a secure form that can be safely used. * Establish proper Guidelines and policies for the use of the data....

Words: 354 - Pages: 2

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. Visión de los Datos Un sistema de bases de datos es una colección de archivos interrelacionados y un conjunto de programas que permitan a los usuarios......

Words: 1102 - Pages: 5

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. Visión de los Datos Un sistema de bases de datos es una colección de archivos interrelacionados y un conjunto de programas que permitan a los usuarios......

Words: 1102 - Pages: 5

Data Base

...Metadata CustTable Central client register table. Statistic and setup values are defined in this table. | 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 |......

Words: 799 - Pages: 4

Data Base

...Chapter 1 Review Questions 1.1. Define the following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. Answer : 1.2. What four main types of actions involve databases? Briefly discuss each. 1.3. Discuss the main characteristics of the database approach and how it differs from traditional file systems. 1.4. What are the responsibilities of the DBA and the database designers? 1.5. What are the different types of database end users? Discuss the main activities of each. 1.6. Discuss the capabilities that should be provided by a DBMS. 1.7. Discuss the differences between database systems and information retrieval systems. Exercises 1.8. Identify some informal queries and update operations that you would expect to apply to the database shown in Figure 1.2. 1.9. What is the difference between controlled and uncontrolled redundancy? Illustrate with examples. 1.10. Specify all the relationships among the records of the database shown in Figure 1.2. 1.11. Give some additional views that may be needed by other user groups for the database shown in Figure 1.2. 1.12. Cite some examples of integrity constraints that you think can apply to the database shown in Figure 1.2. 1.13. Give examples of systems in which it may make sense to use traditional file processing instead of a database approach. 1.14....

Words: 4933 - Pages: 20

Spanner, Google Data Base

...by google. It is a distributed relational database that can distribute and store data in google’s big table storage system in multiple data centers. Spanner is Google’s scalable, multi-version, globally distributed, and synchronously-replicated database. It is the first system to distribute data at global scale and support externally-consistent distributed transactions. Spanner provides the scalability that enables you to store a few trillion database rows in millions of nodes distributed to hundreds of data centers. When you read data, spanner connects you to data center that is geographically closest and similarly when we write the data, it distributes and stores it to multiple data centers. If in case the data center we try to access has a failure we can read the data from another data center that has a replica of the data. Replication is used for global availability and geographic locality clients automatically failover between replicas. Applications can use spanner for high availability even in the face of wide-area natural disasters, by replicating their data within or even across continents. Spanner’s main focus is managing cross-datacenter. Many applications at google have chosen to use Megastore because of its data model and support for synchronous replication despite poor throughput. Applications can specify con-straints to control which datacenters contain which data, how far data is from its users how far replicas are from each other an how many replicas......

Words: 2222 - Pages: 9

Data Base Management

...1. 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. It......

Words: 689 - Pages: 3

Data Base Assignment

...orders? (a) 9 customers spent more than $500 but less than $1,000 and have at least 3 distinct orders (b) i) Create a table showing each customer’s orders: CREATE TABLE CustomerOrder AS Select CustomerID, Count(orderID) AS CountOrderID, Sum(subtotal) AS CustomerSubtotal FROM ByCustomerOrders GROUP by CustomerID; ii) Show customers that spent more than $500 but less than $1,000 and have at least 3 distinct orders: SELECT * FROM CustomerOrder WHERE CountorderID >= 3 and Customersubtotal < 1000 and Customersubtotal > 500; 5. (15 pts) What are our gross revenues per month? Perform this calculation for the eight months contained within the data set (July 1996 - February 1997). If the data set contained multiple years of order detail, what would be the code to calculate average revenues per month (for example, if the data set contained 5 years of order detail, how would you find the average revenues for January, February, March, April, etc. for those 5 years)? Gross Revenue of 8 months 1) July (a) July Monthly Revenue is 37779.85 (b) SELECT sum(subtotal) as JulyMonthlyRevenue FROM bycustomerorders as bcd left join orders as o on bcd.orderID = o.orderID where orderdate < "1996-08" and orderdate > "1996-07" 2) August (a) August Monthly Revenue is 33285.49 (b) SELECT sum(subtotal) as AugustMonthlyRevenue FROM bycustomerorders as bcd left join orders as o on bcd.orderID = o.orderID where orderdate < "1996-09" and orderdate >......

Words: 1102 - Pages: 5