databas academic project

well this is the assessment...please help....!!!!i needo someone to make the hole project for me!!!!read please the pdf or the doc i attached and then bid Part 1 Use the EntityFrameworkwith theTrucks discourse and model ([login to view URL]) provided 1. To check the model meets the following requirements and the discourse. If necessary, change the semantic data model to meet the following requirements and to correct any inconsistencies with the discourse-  [CR1.1] Include data on truck owners who must be companies or people.(2 marks)  [CR1.2] Include data on drivers of tractors who must be the owner or an employee of the company that owns the tractor.(2 marks)  [CR1.3] Include data on maintenance records (2 marks)  [CR1.4] Include data on load types (5 marks)  [CR1.5] Include data on loads carried for customers (5 marks)  [CR1.6] Include data on trailer types (5 marks)  [CR1.7] Include data on container types (9 marks) Describe any and each change clearly. Use the change requirement codes e.g. [CR1.1] Note: requirements and information in Part 2 may influence your design choices and the changes to be made. 2. Generate and implement a complete, consistent (with the discourse and change requirements) and correct database schema using SQL. Place comments in the schema to highlight those parts of the schema which implement any changes made to the [login to view URL] any necessary code and commentary to the schema that is not automatically generated (10 marks) 3. Produce a brief assessment (max 500 words) of the tools capabilities to deal with changes to an existing model, schema and database(10 marks) Consider the following issues (as a minimum) How does the tool deal with key definition e.g. can it deal with composite keys? How well does it deal with changes to property definitions e.g. changing data types? How well does it deal with the definition and changes to associations e.g. multiplicities.? How well does it deal with changes after code generation e.g. if the data model changes ...is the database schema changed automatically? How difficult or easy is it to maintain consistency between the data model and generated products? How well are the various model abstractions implemented in the database schema?   Part 2 Data Migration Using tools that are available to you, and the data provided, do the following- Note: the following may require changes to the model and database in Part 1. Note: Expect defective data and data with inconvenient values and formats. Handling such data is part of the exercise. The data provided may require some ‘manual’ rearrangement but an objective should be to keep this and any programming required to a minimum. Produce a reusable, generalised package (or packages) or SQL Routine (or routines) to • transfer the supplied customer data (in [login to view URL]) to an existing database table (or tables) in the Trucks database from Part 1. (10 Marks) • transfer the supplied container data to an existing database table(s) in the Trucks database from Part 1.(10 Marks) • transfer the supplied customer loads data to existing database table(s) in the Trucks database from Part 1. The package/routine should be capable of repeatedly loading many similar files at one time and over time. The package/routine should be capable of detecting and reporting on defective data. (20 Marks) Data Mining (max 500 words) Do some reading and research into data mining ‘Cubes’. Provide the following (IN YOUR OWN WORDS-IF ONLY UNCITED COPY AND PASTE FROM WEB SITES OR ELSEWHERE SUBMITTED, ZERO MARKS WILL BE AWARDED) A definition of ‘Data Cube’ (2 marks) Purpose of Cubes(3 marks) Types of visualisations and visualisation tools relevant to cubes(3 marks) References(2 marks) all project is attached....