Sponsored Links


Page 1 of 3 123 LastLast
Results 1 to 10 of 24

Thread: cs403 database management mini project July 2010

  1. #1
    Junior Member
    Join Date
    Jun 2010
    Posts
    12

    cs403 database management mini project July 2010

    Sponsored Links


    Q1. You are required to create the following tables using SQL CREATE command, table names along with column description is given below. One of the important things is to use appropriate data types for each column definition and choosing primary and foreign keys for the tables. 20 Marks
    Step 1:
    1. Table Name: MEMBER

    i. MemberId (Member Identification Number)
    ii. FirstName
    iii. LastName
    iv. DateOfBirth
    v. City
    vi. ZipCode Email
    vii. DateOfJoining

    2. Table Name: ATTENDANCE

    i. MeetingDate
    ii. Location
    iii. MemberAttended Hint: This Column is used to check either the member attend the meeting or not so you can use its data type ‘CHAR(1)’.
    iv. MemberId Hint: Behaving as foreign key here in Attendance table.

    3. Table Name: DOCUMENTARY

    i. DocumentaryId (Documentary Identification Number)
    ii. DocumentaryName
    iii. YearReleased
    iv. AvailableOnDVD Hint: This Column is used to check either the this documentary is available on DVD or not like MemberAttended in ATTENDANCE table.
    v. Rating
    vi. CategoryId Hint: Behaving as foreign key here in Documentary table.

    4. Table Name: CATEGORY

    i. CategoryId
    ii. Category Hint: This means the documentary is either about People, Agriculture, Law, War, Religion or Human Rights. It can be from any category.
    5. Table Name: FAVOURITE_CATEGORY

    Sponsored Links


    i. CategoryId Hint: Behaving as foreign key here in favourite_category table.
    ii. MemberId Hint: Behaving as foreign key here in favourite_category table.

    Step 2:
    What to do next???
    After creating these tables successfully you are required to enter Five (5) records in each of the tables using SQL’s INSERT command.
    Important: Students are supposed to submit screen shots of there work for proof. Screen shot for each and every step is not required; these screen shots should be taken after Inserting records in your designed tables. For Example, SELECT * from Category;

  2. #2
    Administrator Xpert's Avatar
    Join Date
    May 2010
    Location
    Jhelum
    Posts
    6,251

    Spotlight

    first you start with this command
    create database project
    create table MEMBER


    Code:
    rest discuss with me here.

  3. #3
    Junior Member
    Join Date
    May 2010
    Posts
    2
    Anyone who could help ?!?!

  4. #4
    Administrator Xpert's Avatar
    Join Date
    May 2010
    Location
    Jhelum
    Posts
    6,251
    i can help u but you have to discuss it with me

  5. #5
    koi mera saath cs403 ki assignment discuss kara

  6. #6
    Administrator Xpert's Avatar
    Join Date
    May 2010
    Location
    Jhelum
    Posts
    6,251
    ok lets discuss i am mcs student and i am in final semester. lets start. that i have given two commands one for creating database and one for table. so now what next

  7. #7
    Junior Member
    Join Date
    Jun 2010
    Posts
    21
    Quote Originally Posted by Xpert View Post
    first you start with this command

    create database project
    create table MEMBER

    Xpert bhai meri to ye first two lines main hi error aa jata hy

    image dekh k btein kia error hy
    Attached Images Attached Images
    Last edited by ayb; 07-18-2010 at 02:38 PM.

  8. #8
    Administrator Xpert's Avatar
    Join Date
    May 2010
    Location
    Jhelum
    Posts
    6,251
    dear app nay , dala howa hai yah nahen ata. aur start main ; termination bhi nahen dali. i suggest you run quries one by one. Like first run the create query and then so on. wuhan par query ko one by one run karnay ka tareqa bhi hai. so try it out for more info please discuss it.

  9. #9
    Junior Member
    Join Date
    Jun 2010
    Posts
    21
    ok
    ab dekhien table bna k data enter kia hy kia ye thik hy ???
    aur dusri bat PRIMARY KEY ksy lagni hy?
    Attached Images Attached Images

  10. #10
    Administrator Xpert's Avatar
    Join Date
    May 2010
    Location
    Jhelum
    Posts
    6,251
    ok good dear i have seen the image now watch this code and alter it and try to make primary key. we are doing discussion because with this discussion you will learn alot.
    Code:
     < column_constraint > ::= [ CONSTRAINT constraint_name ] 
        { [ NULL | NOT NULL ] 
            | [ { PRIMARY KEY | UNIQUE } 
                [ CLUSTERED | NONCLUSTERED ] 
                [ WITH FILLFACTOR =fillfactor ] 
                [ON {filegroup | DEFAULT} ] ] 
            ] 
            | [ [ FOREIGN KEY ] 
                REFERENCES ref_table [ ( ref_column ) ] 
                [ ON DELETE { CASCADE | NO ACTION } ] 
                [ ON UPDATE { CASCADE | NO ACTION } ] 
                [ NOT FOR REPLICATION ] 
            ] 
            | CHECK [ NOT FOR REPLICATION ] 
            ( logical_expression )

Page 1 of 3 123 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 11-09-2010, 09:50 AM
  2. Spring 2010 CS403- Database Management Systems Solved
    By desireforheaven in forum Solved Papers
    Replies: 0
    Last Post: 11-09-2010, 09:44 AM
  3. Replies: 0
    Last Post: 11-09-2010, 09:42 AM
  4. Replies: 1
    Last Post: 07-30-2010, 06:07 PM
  5. CS403 Database Management Systems Assigment 2 May 12, 2010
    By viki in forum Assignments & Solutions
    Replies: 0
    Last Post: 05-13-2010, 03:09 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
-: Vuhelp Disclaimer :-
None of the files shown here are hosted or transmitted by this server. The links are provided solely by this site's users. The administrator's or staff of Vuhelp.net cannot be held responsible for what its users post, or any other actions of its users. You may not use this site to distribute or download any material when you do not have the legal rights to do so. It is your own responsibility to adhere to these terms. If you have any doubts about legality of content or you have any suspicions, feel free to contact us.
Online Education | JhelumSoft