Code Monkey home page Code Monkey logo

database-gui-app's Introduction

Database

Created an Oracle database based on the given schema and develop the application programs using Java to fulfill the following specific requirements: a. Customers can search for records by name of the musician, title of the album, and name of the song. b. Notown staff can search any table and can add/delete/alter a row in any table. Each Notown staff member has to provide this security code before she/he can submit an update command. No security check is needed for pure search. c. Notown requires a user-friendly GUI. Items (a) and (b) shall be nicely integrated into this GUI environment. d. For test purpose, please populate each table with at least five simulated (look-like-real) records/rows.

  1. Each musician that records at Notown has an SSN, a name, an address, and a phone number. Poorly paid musicians often share the same address, and no address has more than one phone.
  2. Each instrument used in songs recorded at Notown has a unique identification number, a name (e.g., guitar, synthesizer, and flute) and a musical key (e.g., C, B-flat, E-flat).
  3. Each album recorded on the Notown label has a unique identification number, a title, a copyright date, a speed.
  4. Each song recorded at Notown has a title and an author.
  5. Each musician may play several instruments, and a given instrument may be played by several musicians.
  6. Each album has a number of songs on it, but no song may appear on more than one album.
  7. Each song is performed by one or more musicians, and a musician may perform a number of songs.
  8. Each album has exactly one musician who acts as its producer. A musician may produce several albums, of course.

database-gui-app's People

Stargazers

 avatar

Watchers

 avatar  avatar

Forkers

curioustauseef

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.