فطامي93

عضو جديد
التسجيل
22/4/14
المشاركات
2
الإعجابات
0
#1
مرحبا ملايييين احد يسااعدني بلييز ف حل اساايمنت داتا بيس
بليييييييييييييييييييييييييييييييييييييييييييز..:frown::confused:
إلي تخصصه كمبيوتر انجنيررنج او علوم الحاسوب يساعدني

لازم اضبط هاي قاعدة بيانات ل تنظيم رحلات حسب التااسك وارسم ER diagram و اكتب ع SQL >>

يالله دخيلكم .. ولو تسااعدوني شوي ع الاقل افهمم:239::239::239:..
غربلني هلأسايمنتت...
ولو انه طويل بس تساعدوني ولو شوي بكون شاكرره لكم كل الشكررررر..

task:
consider the following set of requirements of a database.
the bus traveling Agency needs to computerize its reservation database systems. the corporation has 18 buses spread over 20 routes to various destinations in florida. there are two types of buses: regular and super deluxe. it has 10 regular buses with a seating capacity of 48 and eight super deluxe buses with a seating capacity of 36. for each bus the following information is stored in the database: bus number, capacity, and type. the buses travel certain routes. For each route , the following information is recorded: route identification number, city of origin, and city of destination. customers usually book trips that do not necessarily have to correspond to bus routes. A trip begins in one of the cities that is visited by a route (not necessarily the city of the destination of the route). for every trip a customer books his or her ticket for,the following information is recorded: trip identification number, city of origin,city of destination, departure time, and arrival time. a bus is assigned to a particular route , which passes through the origin and destination cities of one or more tripes.many buses can pass through a particular route.
For the given database perform the following tasks.
1.draw an ER diagram for the given database stating assumptions used if any. use concepts of keys,aggregation,genergalization , cardinality etc. in a proper way. transform the ER diagram into respective relations with proper keys.

2. derive functional depency set by considering the relationship between attributes.
apply normalization to the relations derived until you cannot deccompose the relations further. state the reasons behind each decomposition.

3. create the database in oracle with approprite constraints. construct any five relevant queries involving SQL operatios in oracle and print the result. you will need to link the tables together by using the primary and foreign keys. print the queries results.

4. create any two views stating the purpose and show the results.
5. identify any two scenarios which need triggers to be built. create and execute those triggers by performing insert/delete/updata operation on the database.

يعييييييييييييييين الله
 

فطامي93

عضو جديد
التسجيل
22/4/14
المشاركات
2
الإعجابات
0
#2
:832::832::832::832::832::832::frown::frown::frown::frown::frown: no one
 

أعلى