Skip to main content

Posts

Showing posts from November, 2017

BankCorp Ltd Database Design Entity Relationship Model

Bank Corp Business Requirements BankCorp Ltd. offer Wealth Management and Investment Services to its Personal and Corporate clients. Currently, data is stored in a number of systems across the company. This leads to “double keying” and as a result inefficiencies and errors. They want to create a single database to consolidate all these details into one single source. They do not have any IT staff and they do not have the space or ability to look after any infrastructure on premise. They want you to design and develop the database only. Any data migration tasks will be taken care off in a future different project. The data model must be designed to meet 3NF (Third Normal Form) requirements. In terms of the key entities they have given you the following list: 1 Customers 2 Accounts 3 Securities 4 Associations A customer can have many accounts and an account can be secured by many securities. A customer can be associated to another customer in the bank e.g. a Property Developm

Rosslare port football club functional specification document

Project Description This project came about due to a growing need for the members of Rosslare Football club to obtain information on match fixtures, results and for general club information and announcements. Since the introduction of junior teams, parents and members have requested more information regarding the club. The new system will also allow members and non-members to purchase club merchandise and to make donations to the club. The club chairman and the committee will oversee that all objectives and they will ensure they are met. Functional requirements The main functions of the new proposed system are: Member registration and login Inserting, deleting and inspecting members details Inserting and amending match fixtures, results and club details Altering system passwords High-Level Requirements The new system must include the following: Ability to allow both internal and external users to access the application without downloading any software Ability to i

Hardware and Software Project - Uxbridge College project solution

Scenario You are a consultant for a local IT & Networking company called ‘Uxb-Com’ which specialise in providing professional solutions to various types of companies who are looking for support for their IT infrastructure. Your work mainly involves dealing with client equipment, which comes into the main ‘Uxb-Com’ office for servicing and fixing of faults.  You can also be involved with ensuring this equipment is correctly serviced ready for re-distribution to the clients. ‘Uxb-Com’ is also actively involved in promoting employment links with the local area and part of this drive involves the development of an apprenticeship scheme; providing the opportunity for a selected group to work   in their premises and to learn about their systems and procedures in relation to PC maintenance.  Some of your work may also involve ensuring this scheme runs as effectively as possible. Task 1 - Hardware Your first task involves preparing documentation for the apprenticeship s

Binary Search Tree - Playing with text file data

Program Requirements: Read a text file.  Store the words from the text file into a binary search tree.  To make the problem easier, you may assume that each line in the file contains only one word. (See extra credit below.)  Continue prompting the user for names of text files, reading from text files and adding words to the binary search tree until the user exits the program.  When the program closes, the binary search tree is discarded and when the program starts again, the tree starts in an empty state.  Upon request of the user, display the words stored in the binary search tree in alphabetical order along with the number of times each word appeared in the text file.  In addition, display the total number of words in the tree (count includes duplicates) and the total number of unique words in the tree (not including duplicates).  The words should be case insensitive. That is, "Dog" is equivalent to "doG". If both "Dog" and "doG" app

Trust dental orthodontics & ComfortableHousing Lease database design & implemenation

There are the following tasks for this project Database general concepts In your presentation/report explain the followings: What is a database? Flat file database, its advantages and disadvantages and the circumstances in which flat file database may be used giving an example Relational database, its advantages and disadvantages and the circumstances in which relational database may be used giving an example Differences between flat file and relational database Entity type and entity giving examples Attributes giving examples Types of relationships giving examples Trust dental orthodontics database design ERD & implementation The table below lists a part of dentist/patient appointment data of Trust dental orthodontics. A patient is given an appointment at a specific time and date with a dentist located at a particular surgery. On each day of patient appointments, a dentist is allocated to a specific surgery for that day. There are 5 surgeries under the management