online clubbing /party

Tweet

D1. One A4 page containing the conceptual data model diagram (i.e. an Entity Relationship Diagram using consistently either Chen or UML notation showing: Relevant entity type, The primary key for each entity, Relationship Type with role name (plus any relationship attributes if any) Structural constraints on each relationship (both cardinality and participation) Note: if you show attributes other than the Primary Keys (e.g. Foreign Keys) then you will be penalised. D2. For the above model, produce the logical data model (the relational schema) (one A4 page). The model represents your mapping from the conceptual model into a relational schema and should show: All entity and relationship types that are potential for a relational table. For each potential table identify the primary key and any necessary foreign keys. D3. One A4 page containing a normalised set of relations with all attributes listed. On the same page, state clearly any assumptions that you make about the data; in particular, noting any information that you believe should be included, but is not mentioned in the outline specification: D4. Create a database for the above schema in Oracle DBMS using SQL and populate each table with typical records to clearly demonstrate the application results. D5. The SQL code for the creation scripts and population scripts used in D4. The SQL queries used to fulfil applications A1-A6. Note: you should populate your database sufficient to clearly and unambiguously demonstrate the applications A1-A6 mentioned above. D6. For application A6 above, create a Master/Detail form to run the application. D7. DTD and XML instance document as described in A7. D8. Using Oracle Form Developer create a simple form to enable new users to register. A new user will register their email address and telephone number. Duplicate email, telephone number combinations will be rejected. The form should have two buttons on it – one to commit a new user to the database and one to exit the form/move to a different form. D9. Oracle Forms Report builder create a report / web page for application A5 above. You should include relevant information likely to be required by the report user and format the information appropriately.