Close Button
Signup/Login
Back All services Close Button

World's Leading Assignment Library

Continued assistance through writing and revision till final submission by the professional and experienced writers.

  • 10 subjects

  • 2,10,1000
    solved Questions

  • 500 Solved Questions
    Added Everyday

  • Download Solution
    in Seconds

For the database project your write up should include everything a complete picture and explanation of your design, screen shots of all the tables and operations, form... everything.  Ideally I should

Question Preview:

Object Based Data Model
For the database project your write up should include everything a complete picture and explanation of your design, screen shots of all the tables and operations, form... everything.  Ideally I should be able to read your write up and verify everything is correct. I will only run your database if the write up is not complete and it is not clear what you have done.  At this point you will be losing points.  So think of the .txt file, the write up as the complete project and all other required submitted files are supporting files.
Problem D...

View complete question »

Question Preview:

Object Based Data Model
For the database project your write up should include everything a complete picture and explanation of your design, screen shots of all the tables and operations, form... everything.  Ideally I should be able to read your write up and verify everything is correct. I will only run your database if the write up is not complete and it is not clear what you have done.  At this point you will be losing points.  So think of the .txt file, the write up as the complete project and all other required submitted files are supporting files.
Problem Description
Students develop an object-based data model for a given business situation. The model should include the objects, their attributes and their relationships. Each object and attribute should have a description, with the data format and parameters (limits, steps, etc) specified for the attributes. The model will include a written description of why the objects were selected. The data model will be implemented in a database in 3rd Normal form with sample data and a means of adding and accessing data.
Overview of Standards
Database Design - The student is able to develop an appropriately designed, efficient database with complex relationships and large quantities of data. The student can manage and manipulate the data in the database to obtain results from complex queries and to perform other complex operations.
Data Model - The student is able to select the most appropriate data models and structures for the manipulation and storage methods expected to be applied to that data. The student understands how to manipulate data from one model or structure to another in order to
Procedures Overview
Create an object based data model for an insurance company.
1.  Watch the video below provided at the link below. To get an idea how to start on this project. It is not intended that you copy this example but use it as an  
     example to start and build upon.
     https://www.youtube.com/watch?v=sepuXr-t890
2.  Create the model and the relationships.
3.  Design the database and the objects.  Demonstrate standard queries
4.  Write a summary and a conclusion that describes your model and what you learned in this project.
 Detailed Procedures
 2: Create the model and the relationships.
You can start with the example in the video.  The model should include the House, automobile (to support multiple drivers and multiple cars)  life insurance customer Insurance policies, to include different types of coverage such as: fire, theft earthquake …
The relationship model should be clearly defined using tables:
Use at least 5 entries for each table.  The implication is that the table could be could extend to N number of entries.  All tables should include many to many where appropriate such as Name to Policy Name to address.
Include the foreign keys and all Intermediate tables as needed.
3: Design the database and the objects.  Demonstrate standard queries
Define all objects including customer, policy address.
How do you support different policies with different customers? Some customers my want Fire only, some may want Fire earthquake etc.  You need to model this.
Model all many to many cases. Include intermediate tables.
Describe at least 2 database queries
6. Address each one of the 6 steps in detail.  The paper should be between 350 - 500 words.
1.  Introduction about object based data model.
2.  describe your model include all diagrams and tables.
3.  Describe your objects and why you designed you database in this manner
4.  Conclusion should include what you learned and how you would improve it if you were to redesign the model

 

 

View less »

Solution preview

Object based data model represents the different objects and their relationship. The relationship between one object to another can be, one-to-one (1:1), one- to- many (1: M) and Many-to-Many (M: N). The data members of the objects are shown into the object as well as instance of each object are also shown in the Object based model. The various relationship Tables can be derived from object based model.

This model is converted into Relationship Data model where the objects are called Entities (Tables), data members are the attributes of the entities as well as relationships are also simply derived from the Object based model that are shown as Relationship Tables.

Object based data model represents the different objects and their relationship. The relationship between one object to another can be, one-to-one (1:1), one- to- many (1: M) and Many-to-Many (M: N). The data members of the objects are shown into the object as well as instance of each object are also shown in the Object based model. The various relationship Tables can be derived from object based model.

This model is converted into Relationship Data model where the objects are called Entities (Tables), data members are the attributes of the entities as well as relationships are also simply derived from the Object based model that are shown as Relationship Tables.

 

Get solution

java assignment help

© Livewebtutors. All Rights Reserved 2018

Livewebtutors
Rated 4.9/5 based on 2480 reviews
Arrow up