هل اجد المساعده هذه المره ؟

مغلق

بدأه jtrainee في 26 مايو 2002 · 4 رد · 614 مشاهدة · في قواعد بيانات Oracle

#126 مايو 2002 في 00:58 صاحب الموضوع

السلام عليكم

مطلوب مني اعمل اربع tables في سكربت واحد

انا لاابحث عن الحل الكامل ولكن الطريقه ارجومساعدتكم

اقتباس
Create a single script called h3a which creates, constrains, and populates the following tables: mountains, climbers, expeditions, and members. The semantics are:

An expedition is an attempt to climb a mountain.
Each mountain can have multiple expeditions.
Each climber can be a member of multiple expeditions.
Each expedition consists of many climbers

The structure of your tables is:

Mountain {name, height, location}
Climber {name, gender, birthday}
Expedition {expid, expname, mountainname, start_date, summit_date}
Member{expid, climbername, height_achieved, obit}

Constrain your tables with all appropriate Primary Key, Foreign Key, and Check constraints. Remember:

#226 مايو 2002 في 03:57

السلام عليكم ورحمة الله وبركاته

الاخ jtrainee المحترم

الى فهمته من سؤالك انك تبغى تعمل ملف واحد ومن خلال

تنفيذ هذا الملف من داخل الSQL فسوف يتم إنشاء 4 جداول

ولعمل ذلك قم بإنشاء ملف جديد عن طريق الNotebad

وقم بإختيار إي اسم لهذا الملف الجديد وإحفظه على هيئه SQL

وليكن إسم الملف الجديد TEST.SQL

بعد ذلك أضف السطرين التاليين في بدايه الملف

SET TERMOUT OFF

SET ECHO OFF

بعد ذلك قم بكتابه الاكواد التى تريدها مثل

إنشاء وحذف و تعديل Users - Views - Roles -

Tables - Constraints -Trigger - Synonyms.... إلخ

إدخال بيانات - منح صلاحيه - سحب صلاحيه ...... إلخ

وبعد الانتهاء من كتابه الاكواد التى تريد تنفيذها في هذا الملف

قم بكتابه السطرين التاليين :-

SET TERMOUT ON

SET ECHO ON

وبالنسبه للجداول الاربعه التى تريد إنشاءها سيكون محتوي الملف هكذا

SET TERMOUT OFF                                                              



SET ECHO OFF



CREATE TABLE Mountain

(

name VARCHAR2(50),

height NUMBER(4) NOT NULL,

location VARCHAR2(20)

);

CREATE TABLE Climber

(

name VARCHAR2(60) NOT NULL,

gender NUMBER(1) NOT NULL,

birthday DATE

);

CREATE TABLE Expedition

(

expid NUMBER(6),

expname VARCHAR2(30),

mountainname VARCHAR2(50),

start_date DATE NOT NULL,

summit_date DATE NOT NULL,

);

CREATE TABLE Member

(

expid NUMBER(6),

climbername VARCHAR2(30),

height_achieved NUMBER(4),

obit VARCHAR2(35)

);



SET TERMOUT ON

SET ECHO ON

ولتنفيذ هذا السكربت قم بتشغيل الSQL بواسطة مستخدم لديه صلاحيات

إنشاء جداول كالتالي :-

قم بوضع ملف TEST.SQL في الجزء C من الهارديسك

@C:TEST.SQL

ارجوا ان اكون قد وفقت في الاجابه ولو عن جزء بسيط من سؤالك .

عمر باعقيل

المدينة المنوره

baaqeel@msn.com

#326 مايو 2002 في 04:23

كثر الله خيرك

وشكرا لسرعه الاجابه

سوف اقوم بعمل الخطات اللى قلت لي وإن شاء الله ارد بالنتيجه

#427 مايو 2002 في 04:02

السلام عليكم

المساعده في الفورن كي

عيا يمشي معي الضاهر اني ما فهمت عمله

الباقي تمام

drop table MOUNTAIN;

drop table CLIMBER;

drop table EXPEDITION;

drop table MEMBER;



CREATE TABLE MOUNTAIN

(NAME     VARCHAR2(15) CONSTRAINT MOUNTAIN_NAME_pk PRIMARY KEY,

 HEIGHT_FT NUMBER(5)    CONSTRAINT MOUNTAIN_HIGHT_NN NOT NULL,

 LOCATION  VARCHAR2(15) CONSTRAINT MOUNTAIN_LOCATION_NN NOT NULL);





CREATE TABLE CLIMBER

(NAME    VARCHAR2(25) CONSTRAINT CLIMBER_NAME_pk PRIMARY KEY,

 GENDER   VARCHAR2(1)  CONSTRAINT CLIMBER_GENDER_CC check((GENDER='F')

         OR (GENDER='M')),         

BIRTHDAY DATE        CONSTRAINT CLIMBER_BIRTHDAY_NN NOT NULL);







CREATE TABLE EXPEDITION

(EXPID     NUMBER(2)     CONSTRAINT EXPEDITION_EXPEDITION_ID_PK PRIMARY KEY,

 EXPNAME   VARCHAR2(15)  NOT NULL,

 MOUNTAINNAME VARCHAR2(15) NOT NULL,

 START_DATE   DATE     NOT NULL,

 SUMMIT_DATE  DATE);





CREATE TABLE MEMBER

(EXPID NUMBER(2)       NOT NULL,

 CLIMBERNAME VARCHAR2(25)  NOT NULL,

 HEIGHT_ACHIEVED NUMBER (5) CONSTRAINT MEMBER_HEIGHT_ACHIEVED_NN NOT NULL,

 OBIT VARCHAR2(10));





--- inserting records into MOUNTAIN

INSERT INTO MOUNTAIN VALUES

	('Everset', 29029, 'Nepal');

INSERT INTO MOUNTAIN VALUES

	('Kilimanjaro', 19339, 'tanzania');

INSERT INTO MOUNTAIN VALUES

	('Himalya', 28250, 'India');



--- inserting records into CLIMBER

INSERT INTO CLIMBER VALUES

	('Swee Chiow', 'M', TO_DATE('03/14/1970', 'MM/DD/YYYY'));

INSERT INTO CLIMBER VALUES

	('Edwin Check', 'M', TO_DATE('04/20/1970', 'MM/DD/YYYY'));

INSERT INTO CLIMBER VALUES

	('Masaru Osamura','M', TO_DATE('03/20/1960', 'MM/DD/YYYY'));

INSERT INTO CLIMBER VALUES

	('Ryszard Pawlowski', 'M', TO_DATE('07/01/1959', 'MM/DD/YYYY'));

INSERT INTO CLIMBER VALUES

	('Talli leach', 'F', TO_DATE('03/04/1969', 'MM/DD/YYYY'));

INSERT INTO CLIMBER VALUES

	('Jeff Alzer', 'M', TO_DATE('09/14/1961', 'MM/DD/YYYY'));

INSERT INTO CLIMBER VALUES

	('Heidi Howking', 'F', TO_DATE('05/14/1966', 'MM/DD/YYYY'));

INSERT INTO CLIMBER VALUES

	('Ivan Ranirez', 'M', TO_DATE('06/14/1960', 'MM/DD/YYYY'));

INSERT INTO CLIMBER VALUES

	('Eric Brown', 'M', TO_DATE('07/11/1970', 'MM/DD/YYYY'));

INSERT INTO CLIMBER VALUES

	('Omar Abbosh', 'M', TO_DATE('08/21/1961', 'MM/DD/YYYY'));



--- inserting records into EXPEDITION

INSERT INTO EXPEDITION VALUES

	(1, 'Singapore', 'Everest',  TO_DATE('04/01/1999', 'MM/DD/YYYY'),TO_DATE('06/07/1999', 'MM/DD/YYYY'));

INSERT INTO EXPEDITION VALUES

	(2, '2K Climber', 'Kilimanjaro',  TO_DATE('02/03/2000', 'MM/DD/YYYY'),TO_DATE('03/29/2000', 'MM/DD/YYYY'));

INSERT INTO EXPEDITION VALUES

	(3, 'Confront', 'Himalya',  TO_DATE('06/15/2001', 'MM/DD/YYYY'),TO_DATE('08/04/2001', 'MM/DD/YYYY'));

INSERT INTO EXPEDITION VALUES

	(4, 'Target', 'Everest',  TO_DATE('06/15/1995', 'MM/DD/YYYY'),NULL);



--inserting records into MEMBER

INSERT INTO MEMBER VALUES

	(1,'Swee Chiow', 29029, NULL);

INSERT INTO MEMBER VALUES

	(1,'Edwin Check', 29029, NULL);

INSERT INTO MEMBER VALUES

	(1,'Masaru Osamura', 29029, NULL);

INSERT INTO MEMBER VALUES

	(2,'Ryszard Pawlowski', 19339, NULL);

INSERT INTO MEMBER VALUES

	(2,'Heidi Howking', 19339, NULL);

INSERT INTO MEMBER VALUES

	(2,'Omar Abbosh', 15500, NULL);

INSERT INTO MEMBER VALUES

	(3,'Jeff Alzer', 28250, NULL);

INSERT INTO MEMBER VALUES

	(3,'Eric Brown', 28250, NULL);

INSERT INTO MEMBER VALUES

	(3,'Ivan Ranirez', 28250, NULL);

INSERT INTO MEMBER VALUES

	(3,'Heidi Howking', 20200, NULL);

INSERT INTO MEMBER VALUES

	(4,'Heidi Howking', 29029, NULL);

INSERT INTO MEMBER VALUES

	(4,'Omar Abbosh', 29029, NULL);

INSERT INTO MEMBER VALUES

	(4,'Jeff Alzer', 29029, NULL);

INSERT INTO MEMBER VALUES

	(4,'Ivan Ranirez',15000, NULL);

COMMIT;

#527 مايو 2002 في 04:09

اقتباس
drop table MOUNTAIN;
drop table CLIMBER;
drop table EXPEDITION;
drop table MEMBER;
CREATE TABLE MOUNTAIN
(NAME VARCHAR2(15) CONSTRAINT MOUNTAIN_NAME_pk PRIMARY KEY,
HEIGHT_FT NUMBER(5) CONSTRAINT MOUNTAIN_HIGHT_NN NOT NULL,
LOCATION VARCHAR2(15) CONSTRAINT MOUNTAIN_LOCATION_NN NOT NULL);
CREATE TABLE CLIMBER
(NAME VARCHAR2(25) CONSTRAINT CLIMBER_NAME_pk PRIMARY KEY,
GENDER VARCHAR2(1) CONSTRAINT CLIMBER_GENDER_CC check((GENDER='F')
OR (GENDER='M')),
BIRTHDAY DATE CONSTRAINT CLIMBER_BIRTHDAY_NN NOT NULL);
CREATE TABLE EXPEDITION
(EXPID NUMBER(2) CONSTRAINT EXPEDITION_EXPEDITION_ID_PK PRIMARY KEY,
EXPNAME VARCHAR2(15) NOT NULL,
MOUNTAINNAME VARCHAR2(15) NOT NULL,
START_DATE DATE NOT NULL,
SUMMIT_DATE DATE);
CREATE TABLE MEMBER
(EXPID NUMBER(2) NOT NULL,
CLIMBERNAME VARCHAR2(25) NOT NULL,
HEIGHT_ACHIEVED NUMBER (5) CONSTRAINT MEMBER_HEIGHT_ACHIEVED_NN NOT NULL,
OBIT VARCHAR2(10));
--- inserting records into MOUNTAIN
INSERT INTO MOUNTAIN VALUES
('Everset', 29029, 'Nepal');
INSERT INTO MOUNTAIN VALUES
('Kilimanjaro', 19339, 'tanzania');
INSERT INTO MOUNTAIN VALUES
('Himalya', 28250, 'India');
--- inserting records into CLIMBER
INSERT INTO CLIMBER VALUES
('Swee Chiow', 'M', TO_DATE('03/14/1970', 'MM/DD/YYYY'));
INSERT INTO CLIMBER VALUES
('Edwin Check', 'M', TO_DATE('04/20/1970', 'MM/DD/YYYY'));
INSERT INTO CLIMBER VALUES
('Masaru Osamura','M', TO_DATE('03/20/1960', 'MM/DD/YYYY'));
INSERT INTO CLIMBER VALUES
('Ryszard Pawlowski', 'M', TO_DATE('07/01/1959', 'MM/DD/YYYY'));
INSERT INTO CLIMBER VALUES
('Talli leach', 'F', TO_DATE('03/04/1969', 'MM/DD/YYYY'));
INSERT INTO CLIMBER VALUES
('Jeff Alzer', 'M', TO_DATE('09/14/1961', 'MM/DD/YYYY'));
INSERT INTO CLIMBER VALUES
('Heidi Howking', 'F', TO_DATE('05/14/1966', 'MM/DD/YYYY'));
INSERT INTO CLIMBER VALUES
('Ivan Ranirez', 'M', TO_DATE('06/14/1960', 'MM/DD/YYYY'));
INSERT INTO CLIMBER VALUES
('Eric Brown', 'M', TO_DATE('07/11/1970', 'MM/DD/YYYY'));
INSERT INTO CLIMBER VALUES
('Omar Abbosh', 'M', TO_DATE('08/21/1961', 'MM/DD/YYYY'));
--- inserting records into EXPEDITION
INSERT INTO EXPEDITION VALUES
(1, 'Singapore', 'Everest', TO_DATE('04/01/1999', 'MM/DD/YYYY'),TO_DATE('06/07/1999', 'MM/DD/YYYY'));
INSERT INTO EXPEDITION VALUES
(2, '2K Climber', 'Kilimanjaro', TO_DATE('02/03/2000', 'MM/DD/YYYY'),TO_DATE('03/29/2000', 'MM/DD/YYYY'));
INSERT INTO EXPEDITION VALUES
(3, 'Confront', 'Himalya', TO_DATE('06/15/2001', 'MM/DD/YYYY'),TO_DATE('08/04/2001', 'MM/DD/YYYY'));
INSERT INTO EXPEDITION VALUES
(4, 'Target', 'Everest', TO_DATE('06/15/1995', 'MM/DD/YYYY'),NULL);
--inserting records into MEMBER
INSERT INTO MEMBER VALUES
(1,'Swee Chiow', 29029, NULL);
INSERT INTO MEMBER VALUES
(1,'Edwin Check', 29029, NULL);
INSERT INTO MEMBER VALUES
(1,'Masaru Osamura', 29029, NULL);
INSERT INTO MEMBER VALUES
(2,'Ryszard Pawlowski', 19339, NULL);
INSERT INTO MEMBER VALUES
(2,'Heidi Howking', 19339, NULL);
INSERT INTO MEMBER VALUES
(2,'Omar Abbosh', 15500, NULL);
INSERT INTO MEMBER VALUES
(3,'Jeff Alzer', 28250, NULL);
INSERT INTO MEMBER VALUES
(3,'Eric Brown', 28250, NULL);
INSERT INTO MEMBER VALUES
(3,'Ivan Ranirez', 28250, NULL);
INSERT INTO MEMBER VALUES
(3,'Heidi Howking', 20200, NULL);
INSERT INTO MEMBER VALUES
(4,'Heidi Howking', 29029, NULL);
INSERT INTO MEMBER VALUES
(4,'Omar Abbosh', 29029, NULL);
INSERT INTO MEMBER VALUES
(4,'Jeff Alzer', 29029, NULL);
INSERT INTO MEMBER VALUES
(4,'Ivan Ranirez',15000, NULL);
COMMIT;

هذا الموضوع مغلق.

مواضيع مشابهة

اين اجد هذه المايكروكنترولرات2 رد · 5 أبريل 2004
كيف أجد مثل هذه ال grid1 رد · 13 أكتوبر 2006
اين اجد هذه الشركة؟3 رد · 15 مايو 2002
كذبة أبريل من جووجل - قوية هذه المرة -13 رد · 10 أبريل 2010
اين اجد اسم هذة المكتبة1 رد · 14 أكتوبر 2008
[مخالف]اين اجد هذه المكون1 رد · 13 سبتمبر 2008