|
(2007, 950 words)
This project first creates the SQL tables required for the bookshop, according to the structure of the database that was given. Then SQL scripts are written for populating the database. Then SQL scripts are written for these specific relational database operations: Selection/Projection, Union, Set Difference, Intersection, Cartesian Product, Equijoin, Natural Join, Outer Join, Self join, Division as well as the SQL arithmetic operations of sum, count, average, minimum and maximum. The SQL scripts are written to create views, together with a description of whether they are updateable or not, and why. Each of the scripts of relational database operation, arithmetic operations and views are formulated to simulate a real-world operation.
(2007, 1207 words + prototypes)
This project first evaluates the menu of the given database system, then produces a report on the prototype. A detailed update plan is developed to thoroughly test the prototype to flesh out any flaws. Then, using Oracle Form Builder 6.0, the prototype is redeveloped, addressing the issues identified in the evaluation. The redeveloped canvases are then incorporated in the report, and with an explanation of how each of the issues identified in the evaluation is addressed. A user manual is then produced for the users of the database system.
(2006, 3000 words)
The paper examines Data Warehouse (DW), a store of integrated company's data used to support the process of decision-making. DW infrastructure is analysed; the framework for its implementation is described. The nature and benefits of business intelligence (BI)/ data mining (DM) are discussed highlighting the main BI/DM vendors available in the market.
(2006, 1000 words)
The paper reports on a project of developing a piece of reusable software between an engine and a library to support the development of card games, involving the choice of a programming language, rules, operations, etc. Theoretical approaches to feasibility study are reviewed; the plan of building a database of resources for potential card game developers is outlined.
(2006, 4000 words)
The paper examines the creation, development and completion of a DVD collection for a bibliographic and publisher database modelled as an XML DTD. Two software packages are reviewed showing the applications of XML\XSLT in order to assist the users of the programme.
(2005, 13900 words + MS Access Database,)
The manager of Branson Pizza Parlour, Mr Branson has decided that although the restaurant is operating well it is still lacking in efficiency and also that as the orders are all done manually it is taking a lot of time which can be better used elsewhere. Therefore he wants a computerised system, to take over food ordering and carry out other work related functions such as bill calculations, stock reports, etc
(2006, 1500 words)
This paper examines the security considerations for the transfer of secure data over the internet. It discusses how the protection of databases are confined against security threats, how data integrity is safeguarded and examines some of the major security approaches for this. It focuses upon areas such as firewalls, authentication, use of passwords and protocols and discusses the advantages and disadvantages of the use of different security measures.
(2005, Database,)
The Holloway Health Centre Database is created for the NHS group GP practice. This Database was created to help keep details of patients, doctors, hospitals, appointments, treatments, prescriptions and payments. There are six entities and six tables. Further it was produced six forms, which created to input details of patients, doctors, appointments, treatments, payments and hospitals. Furthermore, database is loaded. It was created one that minimises the database window and opens the switchboard form. The Main Menu was created using Accesss Switchboard add-in, and has the following menus: Patients Menu, Doctors Menu, Payments Menu, and Treatments Menu. The main menu will appear automatically, and the main window will be hidden, when the application is loaded. Also the project includes Data Flow Diagrams at high level, level 1, level; design an appointment card, prescription, and an invoice as three reports of the system and the menu structure that will help the Clinics staff use this system.
(2005, 3000 words)
The paper reports on the project of creating a movie database that is accessible using palmtop technology. An overview of existing movie databases is given; technical specifications, database decisions and issues related to palmtop technology development are examined. Conclusions are made about the best database applications.
(2005,)
The BecksBits Database is created for the company, which is a small software development company that specialises in creating information systems for client organisations. This Database was created to help keep details of staff, projects, and staff skills and companies name. There are seven entities and seven forms for data entry. All forms show four-command button: Add Record, Find Record, Delete Record and Return to Main Menu. Furthermore, there are six reports, which based on a query and three macro. It was created one that minimises the database window and opens the switchboard. The Main Menu was created using Access Switchboard add-in and has the following menus: Staff Menu, Project Menu, Company Menu, Report Menu. Also the Database has Mail merge facility that was created using fields from a table hold in an Access database. Also the project includes user manual and guide.
(2004, 3000 words)
This report has been written to answer the following task: Bridging the gap between Relational and Object Oriented Databases: There has been a great deal of interest in migrating relational databases to object oriented databases. Explore the issues involved in mapping a relational database design and implementation to an object oriented "equivalent". Show, with examples of types and their usage, how an object-oriented approach can be used to enhance the database produced in the group assignment
(2003, 10000 words)
The paper presents a project proposal and final project aimed to develop integrated Database using iterative life cycle
(2004, 3000 words)
The report analyses what involved with migrating relational databases to object oriented databases; what relational databases and object oriented databases are and how they are used; mapping from a relational database to an object oriented relational database, and how this enhances the database.
(2004, 2500 words)
This essay aims to analyse and assess the impact and consequences of computerised record keeping (databases) on society. Essay looks at the two different points of view (libertarian perspective Vs Statism) and draws various arguments of positive and negative impacts of computerised record keeping (databases) on society.
(2004, 2000 words)
This report is looking at the Distributed Databases and comparing those with Centralised Database Systems. Report outlines the basic concepts of distributed databases; the advantages and disadvantages of distributed databases and comparison between of distributed databases and a centralised database system is drawn. The impact of distributed systems on the working environment and the implementation issues is then considered. The report concludes with a summary of distributed databases.
(2003, 7600 words+Access database,)
The database system has been created for a restaurant to help automate their processes. It allows waiters to take order using the system, and the orders are sent to the kitchen/bar. It also allows managers to add/remove food items, update stock levels, work out accounting information etc.
(2003,)
The Piano Cruisers Database is created for the company, which operates fleet of hire cruisers on the River Thames.
This Database was created to help keep details of customers, staff, boats and customer payments.
There are eleven entities in the database and the eleven tables; also there are 5 forms for data entry. Furthermore, there are few reports, which based on a query and one macro that will execute automatically as soon as the database is loaded. It was created one that minimises the database window and opens the switchboard form.
The Main Menu was created using Access's Switchboard add-in, and has the following menus: Customer Menu, Mechanic Menu, Boat Menu, and Payment Menu. The main menu will appear automatically, and the main database window will be hidden, when the application is loaded.
Additionally, the database is password protected.
(2003,)
The Database was created for Estate Agency in order to help keep details of customers, owners and properties.
There are four entities and four tables.
Also there are four forms, which created to input details of customers, owners and properties. One of these forms was created to update property for rental table. All forms show four-command button: Add a Record, Delete a Record, Find a Record, Close Form.
Further, there are also four reports in Database, which based on four queries. Two macros were created in this database, one of them is for opening a form and another is for closing form.
(2003,)
Abstract:
In this assignment Online-Booking system for cinema was implemented. This system is fully functional and works under IIS and PWS servers. Coding was done on ASP and the system uses Access database via ODBC connection. DNS-less connection is also described in the report. Apart from server-side programming, client-side programming (JavaScript and DHTML) was used as well. The following main functions were implemented: Registration of Customers, Customer Login, Search by Date, Search by Title, Logoff, and Ticket purchasing. CSS were in use for laying out visual elements. User's guide and codes are provided.
This assignment paper consists of three parts. In the first one, some ASP coding has been done; there are implemented CSS and DHTML features described in the second one. The actual report itself is in the third part, which is followed by Conclusions, References and Appendices. Screenshots with descriptions are also given.
This assignment is both technical and theoretical nature and was marked a high mark.
(2003, 1200 words)
This paper looks broadly towards the advantages and disadvantages of database
system for the medium size business.
(2003,)
The Database was created for Dental Surgery Clinic in order to help keep details of patients, dentists, surgeries and appointments.
There are four entities and four tables. Also there are few reports, which based on eight queries. Further it was produced eight forms for easy inputting and editing records. On each form a command button was made to close it after use.
The Main Menu was created using Access's Switchboard add-in. The first three items on the main menu will open submenu forms.
The main menu will appear automatically.
The database is password protected.
Page 2>
|
