Database Assignment Example | Topics and Well Written Essays - 1000 words

Database - Assignment Example A class can either have no appointments as least or 10 appointments as greatest (cardinality set apart as (0, 10) close to CLASS/VISIT element). A booking must consistently have a class identified with it and one class is the most extreme (cardinality set apart as (1, 1) close to BOOKING substance). BOOKING and OWNER An OWNER can have a few BOOKINGs and a one BOOKING have a solitary comparing OWNER. Consequently, one to numerous relationship exits between these substances (Marked with 1 and M close to the individual element). An OWNER may consistently have a booking and a booking ought to consistently have proprietor. It is viewed as a BOOKING and OWNER are required for one another. An OWNER at any rate makes them book in least or numerous appointments (cardinality set apart as (1, M) close to OWNER element). A booking must consistently have a proprietor identified with it and one proprietor is the most extreme (cardinality set apart as (1, 1) close to BOOKING substance). Proprietor and DOG An OWNER can have a few DOGs and a DOG have a solitary OWNER. Subsequently a one to numerous relationship exits between these substances (Marked with 1 and M close to the separate element). A proprietor may consistently have at any rate a canine and a pooch ought to consistently have proprietor. Subsequently it is viewed as a BOOKING and OWNER are required for one another. A proprietor at any rate has one canine or numerous mutts (cardinality set apart as (1, M) close to OWNER element). ... A composite substance ‘attend’ was presented as the connecting element (set apart as 1:M on either side of the composite element). A class may consistently have a numerous canines joining in or no mutts going to a class (set apart with a hover on the composite element). A pooch ought to consistently go to a class. Consequently it is viewed as a DOG is discretionary for a CLASS/VIST. A class can either have no pooches joining in or 10 canines as greatest (cardinality set apart as (0, 10) close to CLASS/VISIT substance). A canine should consistently have at any rate a class identified with it and one class is the greatest (cardinality set apart as (1, 1) close BOKING substance). BOOKING and INVOICE An INVOICE can be connected uniquely for a one BOOKING and a one BOOKING have a solitary relating INVOICE. Thus a balanced relationship exits between these elements (set apart with 1 and 1 close to the particular substance). A receipt consistently has a booking and a booking oug ht to consistently have a receipt. It is viewed as a BOOKING and INVOICE are required for one another. An INVOICE consistently makes them book or numerous appointments as least and most extreme (cardinality set apart as (1, 1) close to INVOICE substance). A booking must consistently have a receipt identified with it and one receipt is the greatest (cardinality set apart as (1, 1) close to BOOKING element). The essential and remote key applicable to every element is introduced in their element definition table as PK and FK separately. Element DEFINITION Entity Name: CLASS/VISIT  Entity Description: The subtleties of the Classes and Visits are recorded here Attribute Name Data Type Field Length Required Y/N Validation Rule Primary Key/Foreign Key class_id text 50 Y Not Null PK class_name text 100 Y  class_day text 15 Y  class_max limit whole number 2 Y  class_start_date date 20 Y  Entity DEFINITION Entity Name: BOOKING  Entity Description: