پروژه دیتا بیس(33362)*

---

شرح پروژه

سلام وقت بخیر   پروژه دیتابیس هم قبول میکنید؟  میخواستم به این کد این سوالی که فرستادم رو برام انجام بدید  قیمتش رو هم میشه بگید  تا فردا ساعت ۹ صبح انجام میدید؟  create table audiobook

(

audiobookcode number primary key ,

audiobookname varchar(30) not null,

audiobookdate date default sysdate ,

userId number,

constraint fk_user_id7 foreign key (userId)

references userr (id)

);

insert into audiobook(audiobookcode,userId,audiobookname)

values(76543,1,'queen bonmaid egypt');

insert into audiobook(audiobookcode,userId,audiobookname)

values(34567,2,'war and peace');

insert into audiobook(audiobookcode,userId,audiobookname)

values(76663,2,'milk and honey');

insert into audiobook(audiobookcode,userId,audiobookname)

values(38887,5,'mellat eshgh');

insert into audiobook(audiobookcode,userId,audiobookname)

values(79993,5,'kif');

insert into audiobook(audiobookcode,userId,audiobookname)

values(99967,5,'raz');

create table commentt

(

commentcode number primary key ,

commentdate date default sysdate ,

commenttext varchar(300) not null ,

userId number,

audiobookcode number,

isrccode number,

isrccodemusicvideo number,

weblogcode number,

padcastcode number,

constraint fk_user_id8 foreign key (userId)

references userr (id),

constraint audiobookcodee foreign key (audiobookcode)

references audiobook (audiobookcode),

constraint isrc_music foreign key (isrccode)

references music (isrccode),

constraint mvcodee foreign key (isrccodemusicvideo)

references musicvideo (isrccodemusicvideo),

constraint web_code foreign key (weblogcode)

references weblog (weblogcode),

constraint padcastcodee foreign key (padcastcode)

references padcast (padcastcode)

);

insert into commentt(commentcode,userId,commenttext)

values( 34587,1,'nice!');

insert into commentt(commentcode,userId,commenttext)

values(93765,1,'wow');

insert into commentt(commentcode,userId,commenttext)

values( 88887,1,'binazir');

insert into commentt(commentcode,userId,commenttext)

values(96665,1,'awli');

insert into commentt(commentcode,userId,commenttext)

values( 69648,1,':))))))');

insert into commentt(commentcode,userId,commenttext)

values(696962,1,'*****/*****');

create table musicandplaylist

(

musicplaylistid number not null,

isrccode number,

playlistcode number,

constraint isrcmusicc foreign key (isrccode)

references music (isrccode),

constraint playlistcode1 foreign key (playlistcode)

references playlist (playlistcode)

);

insert into musicandplaylist(musicplaylistid,isrccode,playlistcode)

values( 1,5670,1);

insert into musicandplaylist(musicplaylistid,isrccode,playlistcode)

values(2,6041,2);

insert into musicandplaylist(musicplaylistid,isrccode,playlistcode)

values( 3,6566,3);

insert into musicandplaylist(musicplaylistid,isrccode,playlistcode)

values(4,6595,4);

insert into musicandplaylist(musicplaylistid,isrccode,playlistcode)

values(5,99565,5);

insert into musicandplaylist(musicplaylistid,isrccode,playlistcode)

values(6,6525,5);

create table audiobookandplaylist 

(

audiobookplaylist number not null,

audiobookcode number,

playlistcode number,

constraint audiobookcode1 foreign key (audiobookcode)

references audiobook (audiobookcode),

constraint codepl2 foreign key (playlistcode)

references playlist (playlistcode)

);

insert into audiobookandplaylist(audiobookplaylist,audiobookcode,playlistcode)

values( 1,76543,1);

insert into audiobookandplaylist(audiobookplaylist,audiobookcode,playlistcode)

values( 2,34567,5);

insert into audiobookandplaylist(audiobookplaylist,audiobookcode,playlistcode)

values( 3,76663,5);

insert into audiobookandplaylist(audiobookplaylist,audiobookcode,playlistcode)

values( 4,38887,3);

insert into audiobookandplaylist(audiobookplaylist,audiobookcode,playlistcode)

values( 5,79993,2);

insert into audiobookandplaylist(audiobookplaylist,audiobookcode,playlistcode)

values( 6,99967,1);

create table padcastandplaylist 

(

audiobookplaylist number not null,

padcastcode number,

playlistcode number,

constraint padcastcodef foreign key (padcastcode)

references padcast (padcastcode),

constraint codepl3 foreign key (playlistcode)

references playlist (playlistcode)

);

8959*

این پروژه شامل 1 فایل مهم است، لطفا قبل از ارسال پیشنهاد حتما نسبت به بررسی این فایل اقدام فرمایید.

مهارت ها و تخصص های مورد نیاز

---

---