Databses

In: Computers and Technology

Submitted By ndivho
Words 273
Pages 2
NWUUser
North-West University [Company address]
[Document title]
NWUUser
North-West University [Company address]
[Document title]

CONTENT PAGE

Database Initial Study 1. Analysis of the company situation 2. Define problems and constraints
Problems
Constraints * Each value in a column must not be null * Values in specified columns must be unique for each row in a table e.g. pens can be distinguished by their respective I.DS. * Primary Key- These are unique and are used to identify individual records e.g. patient_id will return records about a specific patient only. * Foreign Key – Values in specified columns must reference an existing record in another table (via its primary key) e.g. treatment_num from the table treatments can appear as a foreign key value in the pet treatment table

3. Define the system Objectives * Develop a system that cost effective * Understand the way the current system works, and enhance its future performance * Ensure the delivery of a high quality system * External entities must be able to comprehend and manoeuvre the system * Incorporate changes easily and quickly * Share data amongst users * Improve accuracy & consistency * Reduce data redundancy as much as possible * Provide data security from unauthorised access * To always ensure the validity of data

4. Define Scope & Boundaries
Scope
* The database should be able to generate reports * The database should be able to provide information on how a pet company conducts its day to day business processes * The database directly deals with staffing, pet owners, pets, and medication * The database will keep track of the financial transactions of the business * The database will keep track of all resources available in all branches of…...

Similar Documents

Difference Between Truncate and Delete

...which includes database name names and locations of datafiles and online redo log files. timestamp of database creation check point information current log sequence number. Redo log files: This files saves all the changes that are made to the database as they occur. This plays a great role in the database recovery. Datafiles:datafiles are the physicalfiles which stores data of all logical structure. Physical component of Database are:- Controlfiles , Datafiles , redologfiles , init file (Parameter file) Archived files, Password file(That is also physical in nature) 24. What are the components of logical database structure of Oracle database Tablespace, segments, extens, data Blocks. A logical unit of storage of databse is called Tablespace. Segments is a space alloocated for a specific logical storage structure within a tablespce. Extents: Space allocated to a segments. Datablocks: Oracle server manage the storage space in the datafiles in units is called data blocks or oracle blocks. 25. What is a datafile It is the file where actual data are stored. It is the physical part of the database Datafile is the physical storage unit of oracle database. It's contains actual data in the database. This is the repository for schema object data. 26. What is an index and How it is implemented in Oracle database An index is a database structure used by the server to have direct access of a row in a table. An index is......

Words: 3117 - Pages: 13

Object Orient Databse

... Relational Database Management Systems Object Oriented Databases The database world is in a constant change! New techniques for concurrency control, cloud platforms, object databases, and service platforms are all being changed and talked about in the industrial and academic world. OODB has been around since the seventies when object oriented programming was first being developed. That being said; companies have only started using object oriented databases in the last ten to fifteen years. In the early 1980’s a Microelectronics and Computer Technology Corporation employee begins ORION. ORION is able to handle schema evolution and complex object looking. During the late 1980’s the first wave of commercial OODMS hits. In this time period we get the beginning of Graphael, which later becomes Matisse. Designed to benefit all perspectives of object oriented databases, Matisse combines native support for SQL, Object and XML all in a single database. Next we get the GemStone Systems, the earliest OODB that supports object identity, inheritance and encapsulation. On into the late 1980’s France starts the development of O2. It is C++ compatible and supports multiple inheritances. Later on Vbase was produced, which use the language COP. COP is changed into a C++ based system that supports encapsulation, ability to construct complex objects, and inheritance. (“Short History”, 2005) Once we get into the 1990’s the first standard is released, ODMG 1.0. During this time frame a common......

Words: 837 - Pages: 4

Art Museum Database

...the word art only in two names. ArtTitle Artist (You should only use the word artist so that you can avoid naming something such as ArtName which could misconstrue for the name of the Art instead of the artist) Objective- The goal of the databse is so that art information can be stored and retrieved. More specifically in this scenario, the database want to be able to call upon the name of an art, the artist who created it and where it can be located in the museum. Any of the extra information is there for asthectic and potential insurance purposes. Scope and Boundries- As stated above, the database in this situation is simble and complex at the same time. The complex part is the actual work that goes into it. The simple part however is what is coming our of it in the end. “The designer must recognize the existance of two sets of limits: scope and boundries. The systems scope defines the extent of the design according to the operational requirements.” And also consider, “Has any designer ever been told “We have all the time in the world or “Use an unlimited budget and use as many people needed to make the design come together”? Boundaries are also imposed by existing hardware and software.” (Rob/Coronel) The databse isn’t for some fortune 500 company, so it needs to be kept in mind that it does not nee a ton of money and resources thrown at it just a few workers and a well though out plan. A visual aid of what the design would take them miles in the creation......

Words: 671 - Pages: 3

Database

...DATABASE ASSIGNEMENT ONLINE STORE DATABSE TABLE NAME * STUDENT/CUSTOMER * ENROLLMENT * COURSES * CATEGORY * ORDERS * ORDER DETAILS * PAYMENT * PRODUCT * SHIPPERS * SUPPLIER/COMPANY TABLES ATTRIBUTES STUDENT/CUSTOMER STUDENT table contain attribute such as: * STUDENT ID-PRIMARY KEY * FIRST NAME * LAST NAME * ADDRESS * POSTAL CODE * CITY * STATE * COUNTRY * PHONE * EMAIL * PASSWORD * CREDIT CARD * CREDIT CARD TYPE ID * BILLING ADDRESS * SHIP ADDRESS * DATE ENTERED ENROLLMENT ENROLLMENT table contain attribute such as: * STU ID-PRIMARY KEY * COURSE ID-PRIMARY KEY * SEMESTER-PRIMARY KEY * INTAKE COURSES COURSE table contain attribute such as: * COURSE ID-PRIMARY KEY * COURSE NAME * FACULTY CATEGORY CATEGORY table contain attribute such as: * CATEGORY ID-PRIMARY KEY * CATEGORY NAME * DESCRIPTION * PICTURE * ACTIVE ORDERS ORDERS table contain attribute such as: * ORDER ID * STUDENT ID * PAYMENT ID * SHIPPER ID * ORDER NUMBER * ORDER DATE * SHIPDATE * REQUIRED DATE * SALE TAX * TIME STAMP * TRANSACTION STATUS * FULFILED * DELETED * PAID * PAYMENT DATE ORDER DETAILS ORDERDATAILS table contain attribute such as: * ORDER IDs-PRIMARY KEY * PRODUCT IDs * ORDER NUMBER * PRICE * QUANTITY * DISCOUNT * TOTAL * IDSKU ......

Words: 289 - Pages: 2

Sustainable Energy

...significantly contributing in economic development and emission. • Sustainable Mining Communities (a) Scoping Paper on, ‘Analysing the socio economic impact of mining activities in Bowen and Surat Basin Regions- A time-series and cross sectional analysis with a longitudinal perspective.’ Objectives: • Identifying the socio-economic impacts of mining activities in Bowen and Surat basin regions; • Comparing the socio-economic implications between the regions; • Devising possible policies for developing and restoring greater sustainable mining communities in these regions. Sustainable Mining Communities Socioeconomic designs Education and skill perspectives: Opportunities and threats Cont. Infrastructure and supplies Databse management and publications Analysing the Socio-Economic Impact of Mining Activities in Bowen and Surat Basin Regions Health and safety issues The systems approach and scopes of the overall project performance. Demographic implecations Community contributions and concerns Envionmental and ecological sustainaility Sustainable Mining Communities (b) Proposal on, ‘Developing socio-economic, demographic and behavioural profile of the mining communities based on their perception of mining activities in Surat and Bowen Basin Regions.’ Objectives: • Segmenting mining communities based on their perception and involvement in mining activities; • Developing socio-economic, demographic and behavioural pattern of the segmented......

Words: 704 - Pages: 3

Intro to Databse Systems Ch1

...1. Data is raw facts that have not been processed to reveal their meaning to the end user. Field is a character or group of characters that has a specific meaning and is also used to define and store data. Record is a logically connected set of one or more fields that describes a person, place, or thing. File is a collection of related records. 3. Date independence exists when you can change the data storage characteristics without affecting the program’s ability to access the data. Data independence lacks in file systems because any program that accesses a file system's file must tell the computer not only what to do, but how to do it. Each program must contain lines that specify the opening of a specific type of file, its record specification, and its field definitions. Data dependence makes the file system very difficult from the point of view of a programmer and database manager. 5. Structural independence is exists when you can change the file structure without affecting the application's ability to access the data. Structural independence is important because it would be very difficult to make changes to an existing file structure, resulting in going through a number of steps and producing errors. 7. The role of a DBMS is to serve as the intermediary between the user and the database. The DBMS receives all application requests and translates them into complex operations required to fulfill those request. The advantages of a DBMS are the following: *...

Words: 424 - Pages: 2

Databse Amnagement System

...1. What is a transaction? What are its properties? Why are transactions important units of operation in a DBMS? As defines by the Elmasri and Navathe, Transaction is a sequence of operations that performs logical unit of operations on a database which include one or more operations as insert, delete, update and modification, Transaction is a executing program, the boundaries of a transaction is define as the explicit begin of transaction and end of transaction. Read-only transaction performs only retrieve data from the database and the Read- write operation includes both retrieving and updating transactions. (Elmasri and Navathe 2010 p.745) The properties of a transaction is define as ACID properties as below, Atomicity, Consistency, Isolation and Durability Transaction is the executing program that executes the operations on the database as read(x), write (x) ,so the transactions plays a vital role among database operations. 2. Draw a state diagram and discuss the typical states that a transaction goes through during execution. Figure1. State Diagram of a Transaction Source: Author Begin transaction: This indicates the beginning of a transaction Active phase: in this phase the running of the database operations or write sql queries for perform the tasks is done Partially committed: After performs the needed operations the transaction indicates end state and come to the phase partially committed and store in the buffer but not permanently. Committed: If the transaction......

Words: 5571 - Pages: 23

Mdss

...phones with their ratings and compare between phones features. There are six features from which user can get the data. Feature comparison 1. Battery 2. RAM 3. Operating system 4. Processor 5. Camera 6. Memory The comparison is so designed that user gets to select the price range in which he/she wants to view the mobiles. Excel Features used: 1. Dynamic Charts 2. Slicer 3. Tabs for all other pages. The slicer is a tool that lets the use filter the results according to his / her choice. The price of the mobile is the feature we have used in the slicer. The price range is as follows 1. Below 10K 2. 10K to 18K 3. 18K to 25K 4. 25K to 35K 5. More than 35K All the phones in the databse have been classified into one of these ranges and when the user selects a particular range of price all the mobile phones that belong to that range are selected and a chart is drawn for each of the above mentioned feature. These charts provide the user with information about the phone. The ratings for each of the phone is taken from a well-known website www.gsmarena.com this website has a rating system on 10 for all the above mentioned feature. Once the slicer is applied the data present for only that price range is selected from the database and a chart for the all the ratings is dynamically made and displayed to the user. Comparison Charts If the user wants to slice and dice the data to find a specific phone to buy then this......

Words: 631 - Pages: 3

Databse

...CIS 592 Special topics Quantitative Methods & Project Management Green Computing Project Initiation and Research Management Group Assignment 1 As a Project Manager, you are given the opportunity to submit a Project Proposal to senior management (the instructor in this case) for consideration during the project selection process. Your responsibility is to prepare a project proposal, which should be at least 5 pages in length, but no more than 8 printed pages in total, double space and a font of 12 points. All supporting documentation (resumes, financial analysis, budget details, schedules/milestones, etc) should NOT count toward the number of pages required for the proposal. Generally speaking, your proposal should include a section for each of the following: 1. Natures of your project – what will this project accomplish? This can be presented as a project charter based on your research of green computing and projects that have been done or are being done by large organizations such as IBM, Dell, HP and Google. Refer to www.greener-computing.com and similar sites or library research to identify potential projects for the green computing portfolio. Use the project.charter.doc template for the project charter. 2. Prepare a weighted decision matrix using the template provided to evaluate and select a potential project from the green computing portfolio. You may reference the wtd_decision_matrix.xls provided by the instructor. 3. Prepare the financial......

Words: 846 - Pages: 4

Database

...struktur file database. • Database merupakan kumpulan data yang terkait satu sama lain. Atau sekumpulan data yang terintegrasi yang diorganisasi untuk memenuhi kebutuhan pemakai untuk keperluan organisasi. • Dalam database pastinya mengenal istilah DBMS (Databse Management System) yang mana merupakan suatu koleksi dari program yang mana pengguna bisa mengcreate dan memaintain suatu database. Dalam DBMS terdiri atas proses-proses yang harus dilakuka nyaitu defining, constructing, manipulating dan sharing. Komponen-komponen DBMS yaitu terdiri atas hardware, software, data, prosedur, people. Fungsi dari defining yaitu DBMS harus dapat mengolah pendefinisian data. Fungsi dari manipulating DBMS harus dapat menangani permintaan-permintaan dari pemakai untuk mengakses data. Fungsi dari constructing yaitu DBMS harus mengontrol proses pengiriman data ke penyimpanan medium. Fungsi dari sharing yaitu database memperbolehkan banyak orang dan program untuk mengakses database. • Meta data: informasi terstruktur yang bertujuan untuk mendeskripsikan, menjelaskan, menemukan atau menjadikan informasi mudah ditemukan atau lebih singkatnya seperti dictionary / database catalog. • Database catalog : terdiri atas meta data yang mana definisi dari databse objects seperti table, visual table. • Database system : bersatunya database dan DBMS software. • Program data independence : suatu struktur dari data files yang dikirim di DBMS catalog secara terpisah dari access programs. • Definisi......

Words: 1618 - Pages: 7

Milestone

...Year Milestone or Event Impact on Human Services 1996 Amber Alerts • Provides an online integrated national database for missing children • Initiates a widespread alert when a child goes missing 2000 Family Watchdog Provides an online databse of sex offenders This lets citizens to find the lastest information on all sex offenders in there area and other areas. 1992 First smartphone It included a calculator, note pad, and could send and receive faxes, e-mail. This made it easy for them to get information when they are away from their office. 1994 Online banking I made it easy to be able to view your balances, pay bills, make transfers, and deposit checks. You could elect to receive an e-statement this reduces the risk of identity theft. 2013 Emergency Weather Text Alerts It delivers emergency alerts to any cell phone of severe weather. These alerts can be sent out anytimes there are bad weather in the area.These alerts are sent out to enhance public safety. and even a National emergencies like a terrorist attacks of 9/11. This helps to make a game plain to no where all your clients will be. 1995 Online shopping This allows customers to shop for merchandise or services from the comfort of their own home. They could use there credit or debit cards. This helps if you have to get suppys for a client and they are sold out in the store and it can be shipped right to there door. 1993 New information technology for human service workers Success of the new human......

Words: 478 - Pages: 2

Spanner, Google Data Base

...with number of replicas, were randomly distributed among the zones. Two questions were answered with respect to True-time. Our machine statistics show that bad cpu’s are 6 times more likey than bad clocks. Those are lock issues, relative to much more serious problems. Spanner started being experimentally evaluated during 2011, under google’s advertising backend called F1. This was originally based on MYSQL databse that was manually shared many ways. The last resharding to this spanner took over 2 years of time. The F1 team chose to use spanner for several reasons. There were several steps which need to carried out First, spanner removes the need to manually re-shared, second, spanner provides replication, failover was difficult. The F1 team also needed secondary indexes on their data and was bale to implement their own consistant global ideas using spanner related transactions. In conclusion, Spanner uses ideas from two communities database community and semi-relational interface transaction, an SQL- based query language from systems was used. Spanner shouldalso focus on databse features that bigtable was missing. And an another aspect of the spanner design stands out is that it is possible to build the distributed systems with much more stronger semantics and when tighter bounds stronger semantics decreases. As a community we should no longer depend on loosely synchronized clocks and weak api’s in designing distributed algorithms. There has constant work going on......

Words: 2222 - Pages: 9

Star Schema University Attendance Databse

...You must create a Star Schema University Attendance database for the following situation: The database must record attendance of students in classes, the time of the lecture, the lecturer who taught the class, the room that was used and the subject for that lecture. For each subject you must record the total number of classes timetabled for the semester – this will be used to calculate Student attendance percentage and Lecturer attendance percentage. An attendance fact must always contain a valid lecturer-id; we assume if one lecturer is absent then another will take his/her place. You may assume maximum room usage is 11 X 5 = 55 periods a week. You can work out the primary key of the fact table from the above specification. The following criteria must be met: 1) This is an individual assignment. 2) You must write SQL statements to enter the data; Try not to repeatedly enter the same thing for one class. 3) You will need reports to provide: a) % usage of rooms b) % attendance of students c) % attendance of lecturers d) At least 2 other reports of interest 4) You must enter at least 30 fact records (this is a factless fact table); in all 10 students, 5 different lecturers, 3 different rooms, 2 subjects and 10 date/time slots as your initial prototype system. 5) (Optional). You must load your fact table from an operational database in batch mode – e.g. a file with values St No Lect –Id Room Subj Date Time 1 1 1 2 20110718 1130 2 1 1 2 20110718 1130 6......

Words: 328 - Pages: 2

Computers

...Assignment #1: Give a short definition for each of the following terms: * Database management system (DBMS): A software package that controls. * Entity: Idea for which you want to store or process data, it can also be a person, place, object, and event. * Attribute: A single data item related to a database object. * Column: Vertical line of characters going from the top to the bottom of the screen. * Field: Single piece of information * Integrity: Data that’s that entered are valid and accurate. * Integrity Constraints: In the database rules that the data must follow. * Redundancy: When unnecessary duplicate of data is in the database. * Data Independence: The form of databse management that keeps the data separate from programs that use the data. Answer the following: 1. What is the relationship between an entity and an attribute? The data related to person, object, or event. 2. What is a database? A structure that can store information about multiple types of entities. 3. What are the advantages and disadvantages of a database (provide 3 each)? Advantages are controlling redundancy, sharing data, and expanding security. Disadvantages are larger file size, increased complexity. 4. What is relational algebra? Identify four different commands and their purpose. A formal system for manipulating relations. Four different commands are Selection whose purpose is to pick rows according to a certain criteria. Projection’s purpose is to......

Words: 253 - Pages: 2

Nursing

... Journal of Culture Diversity, 15(1), 44-50. Retrieved from CINAHL Plus with Full Text database. Liaschenko, J., & Peter, E. (2004). Nursing Ethics and conceptualization of nursing: profession, practice and work. Journal of Advanced Nursing, 46(5), 488-495. Retrieved from CINAHL Plus with Full Text database Sand-Jecklin, K., Schaffer, A. (2006). Nursing students’ perceptions of their chosen profession. Nursing Education Perspectives, 27(3), 130-135. Retrieved from CINAHL Plus with Full Text database. Yam, B. (2004). Professional issues. From vocation to profession: the quest for professionalization of nursing. British Journal of Nursing (BJN), 13(16), 978-982. Retrieved from CINAHL Plus with Full Text databse....

Words: 794 - Pages: 4