Студопедия

Главная страница Случайная страница

КАТЕГОРИИ:

АвтомобилиАстрономияБиологияГеографияДом и садДругие языкиДругоеИнформатикаИсторияКультураЛитератураЛогикаМатематикаМедицинаМеталлургияМеханикаОбразованиеОхрана трудаПедагогикаПолитикаПравоПсихологияРелигияРиторикаСоциологияСпортСтроительствоТехнологияТуризмФизикаФилософияФинансыХимияЧерчениеЭкологияЭкономикаЭлектроника






Objectives of the system






1. Use a graphical user interface to provide a user-friendly operation.

2. Provide automatic operations as adding new records, updating or changing flat records, deleting records, selling and viewing records.

3. Provide automatic storage and management of data.

4. Avoid the problem of duplication of data.

5. Provide data verification and validation to reduce the entry error as small as possible.

6. Prevent redundant process in the original system.

7. Efficient and fast operation of system.

8. Simplify the original method by connecting some operations of different tables.

9. Automatically calculate the total price of a flat when a new record is entered.

These objectives are based on the interviews and my suggestions after observing the current system. Mr W…, Ms Z… and I have agreed on these objectives. Through these objectives, I got a clear direction of developing the new system using my programming ability.

Examiner Comment: these objectives were signed and agreed.

Entity relationship diagram:

According to my investigation of the current system in J… X… Real Estate, I start to design the new system from following Entity Relationship Diagram. From my observation, one supplier can supplier many flats and one buyer can buy more than one flats, so the relationship between supplier and flat is one-to-many, and the relationship between flat and buyer is many-to-one. Therefore, this ERD is already normalized.


Proposed File, Record and Data Structure:

The following three tables will be used in the new system, and the details of data information are listed as follows.


Поделиться с друзьями:

mylektsii.su - Мои Лекции - 2015-2024 год. (0.006 сек.)Все материалы представленные на сайте исключительно с целью ознакомления читателями и не преследуют коммерческих целей или нарушение авторских прав Пожаловаться на материал