Database Design and Development Report for Alpine Shop Ltd., Essays (high school) of Computer science

Download Database Design and Development Report for Alpine Shop Ltd. and more Essays (high school) Computer science in PDF only on Docsity!

DATABASE DESIGN & DEVELOPMENT

Assignment 1

THEL THEL THITSAR

HND 36

P

Introduction

The purpose of the report is to provide information on specific events. And the study case is related to the structure of the Alpine Shop. This report will describe implementation and development of the DBMS. In this report, I’m going to explain about User Requirement, System Requirement, ERD diagram, Normalization such as (1NF, 2NF, and 3NF), User Interface, Data Validation and the last one is the effective of this creation database.

Background

This report is going to show Alpine Shop Ltd. This company plan is to computerize the sales ordering system. Link with feasibility study and sales information and inventory management from Alpine Shop Ltd are as follow. Customers can buy basic groceries at alpine store and don't need to go to supermarkets and shops. This is also save the time because everything can order just by clicking on the phone.

User Requirements

When the user sends a request to order the product. Each order may contain a variable quantity requirement for one or more products within Alpine Shop Ltd. The Alpine Shop Ltd. contains inventory files that detail the product for each product, such as user. Including product number, product description, payment, order quantity, price, and priority shipment etc.

System Requirements

System requirements are the configurations that a system needs in order for hardware or software to function properly and efficiently. It refer to the parts that run on the system. As the administrator sees, the system needs to enter the updated data for the price list of the quantity of products and the invoice of the customer, including the address, phone number, list of orders etc. Failure to comply with these requirements can cause installation or

Normalization

Normalization is a database design approach that reduces data redundancy and eliminates unwanted functionality such as inserts, updates, and deletions of anomalies. This rule splits large tables into smaller ones and joins them together using relationships. The aim of SQL normalization is to remove redundant (duplicate) data and provide logical data storage.

Firstly, I’m going to show you without normalization and all information is stored in the table as follows:

Un-Normalized (0NF)

Here you see above columns have multiple values, now I will move into 1st^ Normal Form.

Order Record Table (Part 5)

Order Detail Table (Part 1)

Order Detail Table (Part 2)

2 nd^ Normal Form (2NF)

In 2NF, must be in 1NF format. There must be single column PK. I have divided 1NF Table into 3 Tables.

Order Record Table (Part 1)

Order Record Table (Part 2)

Order Record Table (Part 3)

Order Record Table (Part 4)

3 rd^ Normal Form (3NF)

Must be in 2NF and there has no transitive functional dependencies.

Order Record Table (Part 1)

Order Record Table (Part 2)

Order Detail Table

Product Table

Staff Table

Brand Table

Delivery Staff Table

Data Dictionary

A SQL Server Data Dictionary is a collection of database tables that store information used in a database definition. A dictionary contains information, attributes, data type, length and key.

In my Data Dictionary, I used date and time as DATETIME datatype. Tax % and Discount amount are used as FLOAT datatype, this can be used in SQL Server. Prices are used as MONEY datatype. Integers are used as INT datatype and others are used as NVARCHAR datatype.

I have already well designed the Data Dictionary of Alpine Shop in Excel.

Order Record Table

Order Detail

Product Table

Staff Table

P

Technical Documentation

Software Requirements

 Version 5.2.1 or above For Andriod Devices  Version 10 or above For iOS Devices

Hardware Requirements

 Minimum RAM 1 GB require  Minimum 250 MB storage require  For mobile, Android and iOS Devices

User Interface

In this task, I’m going to describe about User Interface (UI) that I made and will also explain Data Validation.

Windows and Mac version will be available soon.

User Interface

For End User

I’ve made UI design of the Alpine Shop. I considered about how to make a good user interface before I did it. Then I made eight components for it.

Firstly, this is the Login Page and it will be displayed when the program is opened. You have to input your Email and Password in the given area. If you forgot your password, you can touch “Forgot password?” and then the password reset code will be sent in your Email inbox.

As a new user of this Alpine Shop, you have to sign up to use its services.

Here is the Customer Page and this includes your name that you filled in the Sign up Page. And the Customer ID is provided by the System. You can view everything you ordered by touching order button. The profile button will show your profile. The address is your current address. The payment method includes pay with invoice, pay with credit card and cash on delivery, you can choose the way as you like. The vouchers will show the list of products and their costs that you ordered. About contacts us, you can contact with Alpine Shop’ CEO, Manager, and staffs etc. When you swipe left of the screen, you will see next page. If you want to sign out, you can touch log out button.

This picture represent the Main Page. There is a “Search” button and the user can search everything they want. Also I put horizontal and vertical navigation bars. The user feel freely to choose any available products. If you find something you like, you have to touch “Heart” Button and this chose product will be in “Cart”. If you want to view what you chose, you can touch “Cart” Button to view them. Next to “Cart” button is “User” button and when you touch it, you will get Custom Page.