Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2013
    Posts
    1

    Database assignment at University, newbie struggling help would be mucho appreciated

    I'm currently studying Computing at Uni, one of the units is Database. I am a complete newbie when it comes to this and could really do with a push in the right direction as the lecturers seem to be skipping all the basics. Just a link to a good source for someone like or maybe some labs exercises to practice on MS Access.

    Either way here is the assignment, its due in 2 weeks so really need to get cracking!

    Assessment

    Scenario: Northumberland Zoo

    Northumberland Zoo is home to over 2000 animals from over 300 different types of species, and over a third of the animals are threatened species.

    Animals are housed in enclosures; different species can reside in the same enclosure, however each enclosure must be secure enough to house them. Security levels are in bands from 1 to 5, where 5 is the most secure.

    An animal of species type King Cobra would be allocated to an enclosure with a security of 5, however a Zebra could be allocated to an enclosure with security level 1. There are a number of enclosures, for example, Zebra Zone with a capacity of 50 and security level 1, Snake City with a capacity of 30 and security of 5, and Penguin Place with a capacity of 30 and security of 2.

    It is possible that an animal of a certain species can be housed in an enclosure where the security is higher than that is required, for example a Zebra can be housed in Penguin Place if required.

    All animal details are recorded, such as their name, sex, date of birth, their species type, the enclosure they have been allocated to, and a notes section.

    A member of staff looks after specific species types, they can be in charge of more than one species, however a species is only looked after by one member of staff, this is to ensure that the species bonds with a particular individual, and ensures a regular routine at feeding time etc.

    The Zoo currently holds all of its information within Microsoft Excel spreadsheets, that all of the computers have licences for. As the zoo is growing there is a requirement for a more stable system to be implemented. The zoo staff are computer literate, however they have had no exposure to Microsoft Access. The company does hold licences for Microsoft Access but are unable to purchase anymore due to cash restrictions.

    Section 1 - Written

    Task 1
    Identify and list from the scenario the system requirements needed by the business in order to meet their objectives.
    (Outcome 1)
    (2 marks)
    Task 2
    Identify and produce a feasibility study for the mentioned company scenario to identify whether the proposed system is viable.
    (Outcome 1, 2)
    (8 marks)
    Task 3
    Identify the different stages of the Systems Development Lifecycle (SDLC) methodology and discuss what occurs at each stage, supported with diagrams where appropriate.
    (Outcome 1)
    (5 marks)

    Task 4
    Produce a complete ERD for the proposed system ensuring that you describe each relationship created. You are required to include a commentary describing the linkage between entities whilst ensuring that there are no many to many relationships.
    (Outcome 1, 2)
    (15 marks)

    Task 5
    Produce a normalised data set detailing the stages within the process of normalisation from un-normalised to 3rd Normal Form.
    (Outcome 3)
    (15 marks)
    Referencing and Quotation / Citation for Tasks
    Marks will be awarded for appropriate use of quotation / citation and referencing used through Section 1 of the assessment.
    (5 marks)
    (Section Total 50)

    END OF SECTION 1

    ______________________________________


    Once again any help would be much appreciated!


    :-)

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    We are not adverse to helping students, but we are adverse to doing their work for them.
    You'll need to post individual tasks, what solution you have come up with so far, and specific questions regarding the errors in logic or sql that you are encountering.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Feb 2013
    Posts
    2
    Since this guy's assignment is already past due, I actually went ahead and wrote out the SQL to implement the database.. just for practice.

    According to what I have, it queries fine, but is there something I'm missing?

    CREATE TABLE Staff
    (StaffID CHAR(4) PRIMARY KEY,
    StaffName CHAR(24)
    );

    CREATE TABLE SecurityEnclosure
    (SecurityEnclosuresID CHAR(4) PRIMARY KEY,
    SecurityEnclosuresName CHAR(24),
    SecurityEnclosuresLevel CHAR(1),
    SecurityEnclosuresCapacity CHAR(4)
    );

    CREATE TABLE Species
    (SpeciesID CHAR(4) PRIMARY KEY,
    SpeciesType CHAR(24),
    Endangered CHAR(3),
    StaffID CHAR(4),
    CONSTRAINT Staff FOREIGN KEY (StaffID) REFERENCES StaffID(Staff)
    );

    CREATE TABLE Animals
    (AID CHAR(4) PRIMARY KEY,
    AName CHAR(24),
    ASex CHAR(6),
    ADOB CHAR(8),
    SecurityEnclosuresID CHAR(4),
    SpeciesID CHAR(4),
    CONSTRAINT SecurityEnclosure FOREIGN KEY (SecurityEnclosuresID) REFERENCES SecurityEnclosuresID(SecurityEnclosure),
    CONSTRAINT Species FOREIGN KEY (SpeciesID) REFERENCES SpeciesID(Species)
    );

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    If someone copy/pastes a homework problem on a web forum, do we want to post answer that might pop up the next time the same problem is assigned?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •