Database Management Systems CSE3DMS La Trobe University Department of Computer Science and Information Technology CSE3DMS Assignment XXXXXXXXXXSemester One) Objectives: • To understand large data...

I need to do this immediately. Don't worry about the team members and all.No need of team members just b, c, d, e is required from ""THE OUTPUT"". and all 1 to 7 from above section.


Database Management Systems CSE3DMS La Trobe University Department of Computer Science and Information Technology CSE3DMS Assignment-1 2021 (Semester One) Objectives: • To understand large data importing to Oracle from other platforms • To identify and overcome the data error during the migration process • To estimate the relational diagram from existing data • To understand physical database design as a critical element in achieving overall database objectives. • To have a sound understanding of the use of indexes and the trade-offs that must be considered in their usage. • To understand the concepts of database query optimization. Weight of the assessment: 20% The instruction: You have to submit the assignment in LMS in Week-10 by Monday, 10 May 2021 at 09:00 pm Melbourne time. Delays caused by computer downtime cannot be accepted as a valid reason for late submission without penalty. Students must plan their work to allow for both scheduled and unscheduled downtime. No extensions will be given. The Output: 1. Documentation that contains: a. List of your team members b. Proposed Relational Model c. Storage evaluation table d. List of errors in the provided csv files and how you handle those problems e. The method how to import the data 2. DDL file to create the data 3. Restored Table and Data in ALL MEMBERS’ SCHEMA Submission Details & What to submit A group cover page. Please ensure that all names of your group are on the first cover page. You should include a list of submitted files in this file. All files should be zipped into one file named with “username_ DMS_Assignment_Part 1.zip”. Please note, only one copy of your submission is required. Other members of the group should be on the cover page already. No duplicated submissions! You must submit an electronic copy of your assignment via LMS under the subject title CSE3DMS. It is the student's responsibility to ensure that they understand the submission instructions. If you have ANY difficulties, ask your Lab Tutor for assistance (prior to the submission date). Database Management Systems CSE3DMS Plagiarism Please do not forget to read the following statement of Copying, Plagiarism in this assignment. Make sure the submitted assignment is your own work. Copying, Plagiarism: Plagiarism is the submission of somebody else’s work in a manner that gives the impression that the work is your own. Penalties for Academic Misconduct There are serious penalties for academic misconduct. You may be asked to leave the University and will not be able to complete your course if a serious academic misconduct is involved in the case. Some students have even been barred from registration in their chosen profession! http://www.latrobe.edu.au/students/academic-integrity http://www.latrobe.edu.au/students/academic-integrity Database Management Systems CSE3DMS Problem Scenarios: You have been accepted to start your internship in TelStar, an international IT company as a Database Engineer. This company has a good reputation for handling large projects worldwide from various industries. The company has set a very high-quality standard for the projects and applied this standard throughout their activities. You have been assigned to a project named “EPIC” where an overseas client is in the process of a complete system migration. As a member of data transformation team, your primary role is to identify the new structure for the database. The client has sent the dump file in a CSV format from their previous database and the relational structure is unknown. Your team are required to provide the following items: 1. [10] The proposed relational diagram that can be used to restore the data. Ensure the proper datatype are used, and all required constraints are applied. 2. [20] DDL script to create the table structures. 3. [10] Log of errors related to the data import process, and how you handle the error to ensure all data can be restored. You must show the error in each table and how you handle the error. The aim is 100% data restoration. 4. [10] Estimate the storage cost for each CSV file in Oracle. Table Name Average Rec Length (Bytes) Number of Records Total Record Size (Kbytes) Blocking Factor Blocks Needed Estimated Space Required Estimated Space Used Estimated Space Wasted inventory Cashierpayment Cashierdetail Cashier Article 5. [5] Explain your proposed data importing method. 6. [35] Load the CSV files to the tables created with the DDL script in your schema. You must load the data to all the team members’ schema. 7. [10] Analyse the table and provide an SQL query to show the storage analysis that contains the following columns: - Table Name : List of the tables implemented in your schema for this assignment - Number of rows : Number of rows in each table - Average Row Length : Average record length obtained from data dictionary - Total space allocated : Total spaces allocated for each table - Number of Blocks allocated : Number of blocks allocated for each table - Number of Extents allocated : Number of extents allocated for each table - Used space : Total space used in each table - Unused space : Total space allocated – Total space used Hint: Obtain the data from Data Dictionary USER_TABLES and USER_SEGMENTS