E-R Diagrams & Database of Mobile Shop MCA Project

Oracle Database Table Description for Mobile Store Java Project Report

Tables: Login

Description: Stores the information of User Id and password

  Field    Type    Size    Key Description
Username Varchar 30 Not null Admin Identification
Password Varchar 20   Password

Tables: newcustomer_details

Description: Stores the information of Customer.

  Field    Type    Size    Key Description
Cid  Int 4 Not null Customer Identification
Cname Varchar  20     Customer Name
Pdate Date     Purchase Date
Paidamt Int 7   Paid Amount
Balamt Int 7   Balance Amount
Refid Int 3   Reference Id
Date Of Birth Date     Date of Birth
Age Int 3   Age
Gender Varchar 7   Gender
Dno Varchar 10   Door No
Street Varchar 15   Street
City Varchar 20   City
State Varchar 20   State
Phno Bigint 15   Phone Number
Mob_Purchase Varchar 2000   Mobiles Purchased

Tables: newmobile_details

Description: Stores the information of Mobile Phones.

  Field    Type    Size    Key Description
Phone_Id  Varchar 20 Not null Mobile Phone Id
Mobile_model Varchar 15   Mobile Phone Model
Mobile_name Varchar 20   Mobile Phone Name
Pcolor Varchar 10   Mobile Phone color
Imeino Varchar 20   IMEI No.
Mdate Date     Manufacture Date
Accessories Varchar 55   Accessories

 Tables: newbill

Description: Stores the information of Mobile Related Bill Details.

  Field    Type    Size    Key Description
Bid Int 4 Not null Bill Id
Bill Date Date     Bill Date
Cname Varchar 20   Customer Name
Price Int 7   Total Price
Amtpaid Int 7   Amount Paid
Mob_purchased Varchar 2000   Mobiles Purchased
Mob_Name Varchar 20   Mobile Name
Mob_Price Int 8   Mobile Price
Mob_color Varchar 10   Mobile Color
Mob_imei Varchar 20   Mobile Imei

Entity Relationship diagrams of Mobile Shop MCA Project

E-R Diagrams & Database of Mobile Shop MCA Project

Related Academic Project: Shop Management System

  • In this application, a user (Admin), can log in as an Admin or Staff to perform different activities.
  • By using this application the admin user can maintain the Staff and Customer Bill records and also manipulate it.

Methods of Software Development:

  • Rapid application development for making the user interface screens.
  • Prototyping Model used for development

Operating System and Languages:

  • Shop Management System is designed in .net.
  • Admin Or staff can Manage Products and Bill. The application is connected with Database using JDBC architecture.

One Reply to “E-R Diagrams & Database of Mobile Shop MCA Project”

Leave a Reply

Your email address will not be published. Required fields are marked *