13-09-2012, 12:01 PM
Online Mobile shopping
mobile shop database design.docx (Size: 43.22 KB / Downloads: 178)
DATABASE DESIGN DOCUMENT
Database Description
Database description describes all the databases used in the software to store all the records. The database in turn is further described in detail giving all the fields used with their data type, constraints available to them and description. Constraints include primary key, foreign key, etc. Which allow the entities to be uniquely identified. Project code is available in www.studentprojectcode.com and complete project report is available in www.freestudentprojects.com .
Purpose
In this database description we describe all ten databases which are used to store the all the records of the products, the customers and billing calculation of store.The term database design can be used to describe many different parts of the design of an overall database system.It also be used to apply to the overall processs of designing,not just the data structure but also the forms and queries used as part of the overall database application.
System Overview
We are creating the application for smartcode company.
• System Title: Online Mobile shopping
• System Category: RDBMS(Relational Database Management System) Short for Relational Database Management System, RDBMS refers to a relational database plus supporting software for managing users and processing SQL queries, performing backups/restores and associated tasks.
• Operational Status: Under development status
• Undergoing Major Modification: Data will be stored in the database after the development.
Acronyms and Abbreviations
• secqustn: Security Question
• mobno: Mobile number
• Qty:Quantity
• amt:Amount
ER diagram
An entity-relationship (ER) diagram is a specialized graphic that illustrates the interrelationships between entities in a database. ER diagrams often use symbols to represent three different types of information. Boxes are commonly used to represent entities. Diamonds are normally used to represent relationships and ovals are used to represent attributes
An entity-relationship model (ERM) in software engineering is an abstract and conceptual representation of data. Entity-relationship modeling is a relational schema database modeling method, used to produce a type of conceptual schema or semantic data model of a system, often a relational database, and its requirements in a top-down fashion. Project code is available in www.studentprojectcode.com and complete project report is available in www.freestudentprojects.com .