Exam 1 - 2009-2010

من طرف **SiteAdmin** الخميس يوليو 08, 2010 12:21 pm

Exam 1

Q1- refer to the following yahoo emails table :

Data base file name : YahooMails

Table name : YM

#mail	password	location	DOB	TotalM	ReadM	UnreadM	Active
Ehab_ragab	eftahyasemsem	egypt	21-06-1974	250	225	10	Yes
saraehab	Lovedady&mum	egypt	10-06-2003	100	100	1	Yes
tstwx	12365415	england	20-10-1960	150	120	50	Yes
largepig	wFRy@125SOS	israil	01-01-1980	10	0	10	No
semsemlover	hahahaha	iraq	25-09-1965	90	0	10	No
copka	helahopa	iran	15-21-1940	150	105	20	Yes

1-1-Write SQL statement : ( we recommend write the result too )

1-1-1- create abovementioned table . 1-1-2- delete any mails to any one from israil .

1-1-3- correct unreadM fields (recalculate it). 1-1-4- add column Gender to the table .

1-1-5- create database file . 1-1-6- select mail to any person less than 18 years old .

1-1-7- number of mails from Egypt . 1-1-8- deactivate any mails from iran .

1-1-9- register yourself ( use your true data if you don’t – guess any data استخدم بياناتك الحقيقية اذا لم يكن لك ايميل افترض اى بيانات )

1-2-Write the result of the following SQL statements :

1-2-1- select mail from YM where location =’ira_’

1-2-2- select location, sum(totalM) from YM where totalM >100

1-2-3- select AVG(TotalM) from mail where DOB < 01-01-1980

1-2-4- drop table YM 1-2-5- delete * from YM

1-2-6- select mail from YM where mail between (r,y)

1-2-7- select sum(totalM) AS mails from YM

1-2-8- select mail from YM where password=’%@%’

1-2-9- select mail, location,YM,DOB from YM where totalM >5000

1-2-10- select count(mail) from YM where location=’spain’

1-2-11- select mail,distinict(location) from YM where location =’e%’

1-2-12- select location,DOB,* from YM where readM in (100,120,105).

1-2-13- select mail,location,TotalM from YM where active=’No’

Q2-Answer the following :

2-1-State network type between you and yahoo . 2-2- explain what is ( LAN – WAN – CLIENT/SERVER-AIS ) mean

2-3- define information system and it’s component . 2-4- define documentation and its importance .

Q3- refer to graphic in computerized accounting book part 3 page 23 answer point 1-B-1 , 1-B-3 and:

3-1- state is this DFD is true or false and why ? 3-2- draw document flow chart ?

Q4- Answer :- ( Don’t read questions answer , answer questions or try to answer , then read questions answers and compare it with yours )

4-1- All Q1 in page 31 . 4-2- Q1 in page 55 points 1-1 and 1-2 .

4-3- All Q1 in page 93 . 4-4- All in page 115 .

4-5- all Q1 in page 177 .