BCSL-034- Ignou Assignment Guru 2017-2018 PDF

Preview

Summary

Download BCSL-034- Ignou Assignment Guru 2017-2018 PDF

Description

BCA MCA BA MA BDP B.COM M.COM B.SC

IGNOU ASSIGNMENT GURU Page-

1

http://www.ignouassignmentguru.com

/IGNOUASSIGNMENTGURU

BCA MCA BA MA BDP B.COM M.COM B.SC

http://www.ignouassignmentguru.com

Q.1. A.1.(I) ER diagram

Ans 1.(II)

SIZE

description

CUSTID NAME PER STREET PER CITY PIN CODE PER STATE PER PH NO

NUMBER TEXT TEXT TEXT NUMBER TEXT NUMBER

20 50 50 50 25 50 20

OFF STREET OFF CITY OFF PIN CODE OFF STATE OFF PH NO E.MAIL ID

TEXT TEXT NUMBER TEXT NUMBER TEXT

50 50 25 50 25 50

Customer id Name Present street Present city Pincode Present state Present phone number Office street Office city Office pin code Office state Office phone number Email id

BRAND NUMBER AMOUNT

NUMBER CURRENCY

20 20

Brand number Amount

/IGNOUASSIGNMENTGURU

IGNOU ASSIGNMENT GURU Page-

PRIMARY KEY: CUSTID FIELD NAME DATA TYPE

2

TABLE NAME: ACCOUNT HOLDER DETAILS

BCA MCA BA MA BDP B.COM M.COM B.SC

http://www.ignouassignmentguru.com

DATE

DATE/TIME

10

Date

TABLE NAME=NON ACOUNT HOLDER DETAILS PRIMARY KEY: NONMEMBERID

Description

FIELD NAME DATA TYPE NON MEMBER ID TEXT FROM NAME TEXT FROM SREET TEXT FROM CITY TEXT FROM STATE TEXT PH NO NUMBER BR/FR NO NUMBER DATE DATE/TIME NAME=COURIER DETAILS Primary key: courier id DATA TYPE NUMBER TEXT TEXT TEXT TEXT TEXT NUMBER TEXT NUMBER DATE/TIME NUMBER CURRENCY

SIZE 20 50 55 50 50 50 20 50 20 20 20

Nonmember id From name From sreet From city From stste Phone number Br /Fr number Date

TABLE

Description Courier id Member nonmember id BR/ FR number To name To street To city To pin code To stste To phone number Date Weight Rate

IGNOU ASSIGNMENT GURU Page-

3

FIELD NAME COURIER ID MEM/NM ID BR/FR NO TO NAME TO STREET TO CITY TO PIN CODE TO STATE TO PH NO DATE WEIGHT RATE

SSIZE 55 50 50 50 50 20 20 10

TABLE NAME=COURIER RETURN DETAILS Foreign key: courier no FIELD NAME COURIER NO RETURN DATE

DATA TYPE NUMBER DATE/TIME

SIZE 20

Description Courier number Return date

/IGNOUASSIGNMENTGURU

BCA MCA BA MA BDP B.COM M.COM B.SC

http://www.ignouassignmentguru.com

20 50

TABLE NAME=EXPENCES DETAILS Primary key: expensesid FIELD NAME DATA TYPE expensesid TEXT PETTY EXP CURRENCY TRAVEL EXP CURRENCY REPAIR EXP CURRENCY E DATE DATE/TIME TABLE NAME=STAFF DETAILS Primary key: staff no

FIELD NAME STAFF NO STAFF NAME STREET CITY PIN CODE STATE PH NO QUALIFICATION DESIGNATION RIGHTS SALARY

DATA TYPE TEXT TEXT TEXT TEXT NUMBER TEXT NUMBER TEXT TEXT TEXT CURRENCY

TABLE NAME=BRANCH DETAILS FIELD NAME DATA TYPE BRANCH NAME TEXT BRANCH NO TEXT FIELD NAME DATA TYPE BR/FR NO TEXT EACH _OVER CURRENCY COURIER RECEIVED NUMBER COURIER DISPATCH CURRENCY DATE DATE/TIME

Branch number Reason

SIZE 10 20 20 20 20

Description expenses id Petty expenses Travel expenses Repair expenses Expenses date

SIZE 55 50 50 50 20 50 25 50 50 55 45

Description Staff no Staff name Street City Pin code State Phone no Qualification Designation Rights Salary

SIZE 50 55 SIZE 55 45 20 25

Description Branch name Branch number Description br/fr no Each day turn over Courier received Courier dispatch Date

4

TEXT TEXT

Ans 1. (III)

/IGNOUASSIGNMENTGURU

IGNOU ASSIGNMENT GURU Page-

BRANCH NO REASON

BCA MCA BA MA BDP B.COM M.COM B.SC

IGNOU ASSIGNMENT GURU Page-

5

http://www.ignouassignmentguru.com

/IGNOUASSIGNMENTGURU

BCA MCA BA MA BDP B.COM M.COM B.SC

http://www.ignouassignmentguru.com

IGNOU ASSIGNMENT GURU Page-

6

Ans 1(IV)

/IGNOUASSIGNMENTGURU...