A department store has a bridal registry. This registry keeps information about the bride, the products that the store carries, and the products for which each bride registers. Some products include several related items: for example, dish sets, include plates, specialty dishes, and serving bowls. Brides typically register for a large number of products, and many brides register for the same products. A bride may also register for several of the same product but may register for different colours or types of each product. For example, a bride may register for bath towels, which typically come in sets (bath towel, hand towel, wash cloth), and may register for 4 blue bath towels, 4 blue/white striped bath towels, 8 blue hand towels, and 16 white wash cloths. The couple then notifies people who are invited to the wedding that they are "registered" at the store. The registry also must keep track of what registered items have been purchased for the bride so that a current list showing items registered for but not yet purchased can be produced for friends and family who come to the store. The friends and family can then purchase items on the list which then have to be marked as having been bought. For example, someone may come in and buy only one place setting of the bride's china. If eleven other people do the same thing, the bride will receive twelve full place settings of new china.
Information kept about brides includes name and fiance's name, address and phone number. Product information includes product number, description, and store department in which the product can be found.
I WANT YOU TO PRODUCE A BASIC DATABASE USING ORACLE DESIGNER
You are required to produce a report which documents the following tasks:
Use Oracle Designer to produce for the Analysis stage: i.e. Process Modelling/ Dataflow (just one of these), plus Entity-Relationship and Function Hierarchy diagrams for the system given in the scenario. Also generate the server model and database tables using database design transformer and the Generate tables option from design editor. State any assumptions made and justify any design decisions made during the analysis stage.
Use Oracle Designer to develop and generate Modules and Forms. Use your own data use the form(s) to add data and then conduct queries on the data
Critically Evaluate the quality of your database design, the user interface aspects of your forms design and the Oracle Designer components used to carry out this assignment.