StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...
Free

Document Database Analysis - Assignment Example

Cite this document
Summary
The assignment "Document Database Analysis" focuses on the criticla analysis of the major issues in the evaluation of the document database. The ER-Diagram consists of five main entities, namely CLASS/VISIT, BOOKING, OWNER, DOG, and INVOICE…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER96.4% of users find it useful
Document Database Analysis
Read Text Preview

Extract of sample "Document Database Analysis"

?Task a) and b) The ER-Diagram consists of five main entities, ly VISIT, BOOKING, OWNER, DOG, and INVOICE. The relationships can be explained in detail considering their cardinalities, participations and constraints according to the given scenario. CLASS/VISIT and BOOKING A CLASS/VISIT can have several BOOKINGs and a one BOOKING have a single corresponding CLASS/VISIT. Hence a one to many relationship exits between these entities (Marked with 1 and M near the respective entity). A CLASS/VISIT may or may not have booking at a time and it is considered a BOOKING is optional for a CLASS/VISIT and CLASS/VISIT is mandatory for a booking (marked with a circle on BOOKING as the optional side). A class can either have no bookings as minimum or 10 bookings as maximum (cardinality marked as (0, 10) near CLASS/VISIT entity). A booking must always have a class related to it and one class is the maximum (cardinality marked as (1, 1) near BOOKING entity). BOOKING and OWNER An OWNER can have several BOOKINGs and a one BOOKING have a single corresponding OWNER. Hence, one to many relationship exits between these entities (Marked with 1 and M near the respective entity). An OWNER may always have a booking and a booking should always have owner. It is considered a BOOKING and OWNER are mandatory for each other. An OWNER at least has one booking in minimum or many bookings (cardinality marked as (1, M) near OWNER entity). A booking must always have a owner related to it and one owner is the maximum (cardinality marked as (1, 1) near BOOKING entity). OWNER and DOG An OWNER can have several DOGs and a DOG have a single OWNER. Hence a one to many relationship exits between these entities (Marked with 1 and M near the respective entity). An owner may always have at least a dog and a dog should always have owner. Hence it is considered a BOOKING and OWNER are mandatory for each other. An owner at least has one dog or many dogs (cardinality marked as (1, M) near OWNER entity). A dog must always have an owner and one owner as the maximum (cardinality marked as (1, 1) near DOG entity). CLASS/VISIT and DOG A CLASS/VISIT can have several DOGs attending and a DOG can attend to several CLASS/VISITs. Hence, many to many relationship exits between these entities. A composite entity ‘attend’ was introduced as the linking entity (marked as 1:M on either side of the composite entity). A class may always have a many dogs attending or no dogs attending a class (marked with a circle on the composite entity). A dog should always attend a class. Hence it is considered a DOG is optional for a CLASS/VIST. A class can either have no dogs attending or 10 dogs as maximum (cardinality marked as (0, 10) near CLASS/VISIT entity). A dog must always have at least a class related to it and one class is the maximum (cardinality marked as (1, 1) near BOKING entity). BOOKING and INVOICE An INVOICE can be related only for a one BOOKING and a one BOOKING have a single corresponding INVOICE. Hence a one to one relationship exits between these entities (marked with 1 and 1 near the respective entity). An invoice always has a booking and a booking should always have an invoice. It is considered a BOOKING and INVOICE are mandatory for each other. An INVOICE always has one booking or many bookings as minimum and maximum (cardinality marked as (1, 1) near INVOICE entity). A booking must always have an invoice related to it and one invoice is the maximum (cardinality marked as (1, 1) near BOOKING entity). The primary and foreign key relevant to each entity is presented in their entity definition table as PK and FK respectively. Entity DEFINITION Entity Name: CLASS/VISIT   Entity Description: The details 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 capacity integer 2 Y     class_start_date date 20 Y     Entity DEFINITION Entity Name: BOOKING   Entity Description: All the bookings relevant to classes and visits are recorded here Attribute Name Data Type Field Length Required Y/N Validation Rule Primary Key / Foreign Key bk_id text 50 Y Not Null PK class_id text 50 Y Not Null  PK and FK ow_id text 20 Y Not Null PK and FK bk_date date 20 Y     Entity DEFINITION Entity Name: INVOICE   Entity Description: Invoice details relevant for each booking is recorded in this relation Attribute Name Data Type Field Length Required Y/N Validation Rule Primary Key / Foreign Key invoice_id text 50 Y Not Null PK bk_id text 50 Y Not Null  FK invoice_tot amount float 15 Y     Entity DEFINITION Entity Name: OWNER   Entity Description: The details of the Classes and Visits are recorded here Attribute Name Data Type Field Length Required Y/N Validation Rule Primary Key / Foreign Key ow_id text 20 Y Not Null PK ow_name text 100 Y     ow_address text 150 Y     ow_tele text 20 Y     ow_no_of_dogs interger 10 Y ow_email text 50 Y     Entity DEFINITION Entity Name: DOG   Entity Description: The details relevant to dogs which attend the classes and visits Attribute Name Data Type Field Length Required Y/N Validation Rule Primary Key / Foreign Key rec_id text 50 Y Not Null PK dog_name text 100 Y     dog_breed text 50 Y     dog_age integer 2 Y     vacc_date date 20 Y     Entity DEFINITION Entity Name: attend   Entity Description: this entity acts as a linking entity between CLASS and Dog entities Attribute Name Data Type Field Length Required Y/N Validation Rule Primary Key / Foreign Key class_id text 50 Y Not Null PK rec_id text 50 Y Not Null PK c) Form A Form B The booking for a Jenny Jones Dog Education Class can be completed with two easy steps according to the Form illustrated above. Form A is the first step where the user is given the option to select the owner or register a new owner. The Class can also be selected from the existing set of classes. A calendar option is given to select the date accurately. After entering the correct information user can check availability of the place in that particular class and the message will be displayed within the same page after checking. Depending on the availability user can either cancel the booking or move into the second step represented in Form B. In this form the Customer ID, Booking ID, Invoice ID and Date will automatically appear in this form where user have to enter the charged amount and confirm by taking a printout of the invoice. Appropriate validation checks for each form value will also be guide the user as well. References Hoffer, Jeffrey. George, Joey. Valacich, Joseph. Modern Systems Analysis and Design, Boston, MA, USA: Addison-Wesley Longman Publishing Co., Inc, 1998. Print. Read More
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Database Assignment Example | Topics and Well Written Essays - 1000 words”, n.d.)
Retrieved from https://studentshare.org/family-consumer-science/1406009-database
(Database Assignment Example | Topics and Well Written Essays - 1000 Words)
https://studentshare.org/family-consumer-science/1406009-database.
“Database Assignment Example | Topics and Well Written Essays - 1000 Words”, n.d. https://studentshare.org/family-consumer-science/1406009-database.
  • Cited: 0 times

CHECK THESE SAMPLES OF Document Database Analysis

Principles of Good Database

For instance, it offers the capabilities of trend analysis and time series analysis.... hat is the purpose of requirement analysis?... he general purpose of requirements analysis is to collect each piece of data and information required to develop a database of optimal functionality which fulfills the informational requirements of a company.... In addition, the process of requirements analysis is considered as an imperative and extremely laborious phase within the DBLC (database development life cycle)....
4 Pages (1000 words) Research Paper

Logical and Physical Database Security

The document provides a comprehensive analysis of the techniques and strategies being utilized to overcome database security issues (Abramov, Anson, Dahan, Shoval, and Sturm, 2012).... The paper "Logical and Physical database Security" discusses that there are several countermeasures to avoid physical data theft vulnerability include: the installation of security cameras, alarms, electronic access control implementation on the doors, and allocation of security guards....
4 Pages (1000 words) Essay

Management of Information & Knowledge Strategically

It was found out that the airline has little knowledge management and hence it goes ahead to explore various options that can be adopted by Ryanair so as to.... ... ... The options explored include use of simple social avenues such as Twitter, Facebook and YouTube through creation of Blog Spots and Further on, recommendations have been made such as having a knowledge management system that is comprehensive and accessed to everyone, including customers and one that has fully searchable and one that can be used to access a great deal of information by attaching multiple files....
14 Pages (3500 words) Essay

Development of database security

The essay "Development of database security" presented various techniques for implementing security features in a database which can lead an organization to have a logically secured database.... Moreover, describes how data should be kept safe from the physical theft threat on the database.... The database security is concerned with the unauthorized access or misuse of the authorized user which leads to the leakage of personal or potential information....
4 Pages (1000 words) Term Paper

An Analysis of the NoSQL Database Management System

The paper "An analysis of the NoSQL Database Management System" states that the use of the NoSQL database approach is gaining status with a gigantic speed.... A critical analysis of the NoSQL database management system shows that it can be a perfect solution for exponentially growing data volumes.... This title is affiliated with the fact that NoSQL databases do not require the execution of SQL statements to query the database.... It was devised by Carlo Strozzi in 1998 while referring to his Light Weight, Open Source database that had no any SQL interface....
6 Pages (1500 words) Essay

Database Development and Management

The purpose of the paper 'database Development and Management' is to analyze an effective database design that incorporates all the stores product sales and inventories.... The potential sales information stored within the database entail the price of the product, customer and store number in the store.... The author states that the use of the information of potential sales information and store transactions assists in the improvement of an operative database scheme that connects all the stores together with the products in them for sale....
12 Pages (3000 words) Term Paper

XML as Databases - Advantages and Concerns

This paper presents a detailed analysis of XML with respect to its usage as a database management system.... This paper "XML as Databases - Advantages and Concerns" has discussed the features and elements that differentiate XML databases from other database management systems, as well as important concepts associated with XML and databases, and the way an XML database is used.... Basically, XML was not designed to be used as a database because it lacks a large number of features that are important for the databases....
20 Pages (5000 words) Essay

NoSQL and Big Data Management

here are four main classifications of the NoSQL architecture that includes: document database, graph database, key-value stores, and wide column stores.... In terms of velocity, data are said to stream at an unprecedented speed which requires timely analysis.... The main techniques for analyzing big data include regression analysis, sentiment analysis, genetic algorithms, association rule learning, social network analysis, machine analysis, and classification tree analysis....
8 Pages (2000 words) Article
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us