Preview

Database Management

Satisfactory Essays
Open Document
Open Document
715 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Database Management
Coursework Header Sheet 172806-18

Course Coursework Tutor

COMP1302: DB Design & Implementation DBDI - COLOMBO - DEC 10 - AC A Al-Zobaidie

Course School/Level Assessment Weight Submission Deadline

CM/UG 50.00% 09/11/2010

Coursework is receipted on the understanding that it is the student's own work and that it has not, in whole or part, been presented elsewhere for assessment. Where material has been used from other sources it has been properly acknowledged in accordance with the University's Regulations regarding Cheating and Plagiarism.

000592677 Tutor's comments

Grade For Office Use Only__________ Awarded___________ Moderation required: yes/no Tutor______________________

Final Grade_________ Date _______________

[INOKA MEDAGODA COMP 1302]

Page 1

Table of Contents

Content

Page

D1. Business Rules D2. ER Diagram D3. Relational Schema D4. Normalization D5. Database View D6. SQL Codes D7. Player Registration Form D8. Report D9. Master detail form Reference

02 - 03 03 - 04 04 - 05 05 - 06 06 - 07 07 - 08 08 - 11 11 - 13 13 – 15 15 - 16

[INOKA MEDAGODA COMP 1302]

Page 2

D1. BUSINESS RULES

1. An amateur player can have only one hobby. 2. A Match can be uniquely identified by its match date and the place. Therefore only one match can be played in a particular court at a particular day. 3. A club will have only one team therefore a club can be identified by the team. 4. A player can have multiple positions but at a given time slot he should hold a particular position.

[INOKA MEDAGODA COMP 1302]

Page 3

D2. ER DIAGRAM

FName

LName Hobby Salary Start_date Team No

Name Age
Amateur Professional

M

1
Belongs To

Team

Address

Player ID D Street

City

1

Postcode

Player
1 M M
Holds Perform_In

M

Match_Date

M M

Matches
Match_Place

M
Position ID

Position

Winning Team

Player of the match

Experiance

[INOKA MEDAGODA COMP 1302]

Page 4

D3.

You May Also Find These Documents Helpful

  • Good Essays

    * In an inventory order system, you don't want an order to be deleted if there are inventory order items, or those items will be orphaned.…

    • 579 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    As part of this proposal, the below charts will diagram the database. It is to be used as a reference to the purposed database. Tables have been diagramed along with the proper schema, data types, and primary/secondary keys.…

    • 515 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    I declare that the assignment here submitted is original except for source material explicitly acknowledged, and that the same or related material has not been previously submitted for another course. I also acknowledge that I am aware of Institute policy and regulations on honestly in academic work, and of the disciplinary guidelines and procedures applicable to breaches of such policy and regulations.…

    • 4220 Words
    • 17 Pages
    Powerful Essays
  • Satisfactory Essays

    By the act of making this submission, the learner certifies that this is the work of the learner named above. The work has not, in whole or in part, been knowingly presented elsewhere for assessment, or where assessment has been built on a previous assessment, this has been identified. Where materials have been used from other sources it has been properly acknowledged. If this statement is untrue, the learner acknowledges that an assessment offence has been committed.…

    • 262 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Dbm380 Course Syllabus

    • 2296 Words
    • 10 Pages

    Course Description This course covers database concepts. Topics include data analysis, the principal data models with emphasis on the relational model, entity-relationship diagrams, database design, normalization, and database administration. Policies Faculty and students will be held responsible for understanding and adhering to all policies contained within the following two documents: • • University policies: You must be logged into the student website to view this document. Instructor policies: This document is posted in the Course Materials forum.…

    • 2296 Words
    • 10 Pages
    Satisfactory Essays
  • Good Essays

    References: Barrodale Computing Services Ltd. (2011). Applications of Object Relational Database Management Systems at BCS. Retrieved from Barrodale Computing Services Ltd. (BCS): http://www.barrodale.com/docs/ORDBMS%20Applications%20at%20BCS.pdf…

    • 672 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Economics Assignment

    • 2192 Words
    • 9 Pages

    If you request an extension for your final assignment, there is no guarantee that you will receive your assignment back before the final examination.…

    • 2192 Words
    • 9 Pages
    Good Essays
  • Best Essays

    Coursework is receipted on the understanding that it is the student's own work and that it has not, in whole or part, been presented elsewhere for assessment. Where material has been used from other sources it has been properly acknowledged in accordance with the University's Regulations regarding Cheating and Plagiarism.…

    • 3658 Words
    • 15 Pages
    Best Essays
  • Powerful Essays

    Jile La Obstacle

    • 1824 Words
    • 8 Pages

    * Extensive Knowledge in Normalization Techniques for designing database Relational technology on N-Tier and created database reports to monitor the project.…

    • 1824 Words
    • 8 Pages
    Powerful Essays
  • Satisfactory Essays

    Assam and Contact Number

    • 468 Words
    • 2 Pages

    Lists Of Dota Teams: Team Name: Fraternity Clan Lord: Bankhraw Address: Laban, Shillong, Meghalaya Contact Number: 8014394544 List Of Players: 1. Gabrial 2.…

    • 468 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    Shooting a Basketball

    • 1819 Words
    • 8 Pages

    1 (LOW) TO 5 (HIGH) Head Coach will use the second column to rate each coach.…

    • 1819 Words
    • 8 Pages
    Powerful Essays
  • Powerful Essays

    Database Project

    • 1591 Words
    • 7 Pages

    AGGREGATED CATERING SYSTEM PROJECT REPORT 11/12/2012 Contents 1 Problem Description ..............................................................................................................................................3 1.1 Description of the organization ................................................................................................................ 3 1.2 Scope of the database .................................................................................................................................... 3 2 Entity-Relationship Diagram .............................................................................................................................. 4 3 Relational Database Schema ...............................................................................................................................5 4 Printouts of Data Input Screen Form ..............................................................................................................6 4.1 Flavor Input Screen Forms ..........................................................................................................................6 4.2 Restaurant Input Screen Forms ................................................................................................................…

    • 1591 Words
    • 7 Pages
    Powerful Essays
  • Good Essays

    4. In MS Word, select “Edit/Paste Special”. (Do NOT select “Paste” Ctrl+V. This will result in a huge MS Word file and you will have difficulties in submitting such a big MS Word file.)…

    • 339 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    DATABASE MANAGEMENT

    • 1145 Words
    • 5 Pages

    1. MySQL is the world's second most widely used open-source relational database management system (RDBMS). It is named after co-founder Michael HYPERLINK "http://en.wikipedia.org/wiki/Michael_Widenius"Widenius's daughter, My. The SQL phrase stands for Structured Query Language.…

    • 1145 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    2. Software: software consists of the programs that run on a computer. The software that…

    • 371 Words
    • 2 Pages
    Satisfactory Essays