ICTDBS502 : Design a Database - Encryption and Authentication - IT Computer Science Assignment Help

Assignment Task :

Unit Application 

This unit describes the skills and knowledge required to establish client needs and technical requirements and to design a database that meets those requirements. 

It applies to individuals employed as database administrators and designers who are required to design databases. 

Knowledge Evidence:

To complete the unit requirements safely and effectively, the individual must: 

• explain the process of data analysis, particularly in determining data types and data structures, query and report design 

• describe the data modelling related to developing the conceptual data model 

• explain how data redundancy is identified 

• describe database management system (DBMS) fundamentals, particularly during the design phase 

• explain encryption and authentication as these apply to database security features 

• outline the functions and features of data types, and data structures 

• describe the functions, and features, of databases 

• describe logical design concepts, particularly those related to designing data structures, queries screens and reports 

• outline the object model design concepts, particularly those related to designing data structures, queries, screens and reports 

• explain the term ‘scalability’ as it applies to databases. 

• Storing the customers rating of the rental on a 5-star basis. 

Task requirements You are required to perform the database design for the customer and following all steps and implement the above system in an RDBMS e.g. SQL Server and/or MS Access 

This requires completion of Part A to F described below. Part A Your task in part A as the lead developer is to understand the above information regarding the business and perform an interview with appropriate staff at Epic Videos to refine the database requirements (a role play organizing a time with your trainer to achieve this). Using this collective information (identifying the hints provided above) develop a conceptual model of the new database. 

Assessors can provide typical information, but should only elaborate on the request or questioning initiated by the student. This is to ensure each student can communicate effectively with clients. 

Part B Based on this conceptual model you are required to formalize this in a logical database model refining the design using normalization. Note: 

• A logical design requires the production of an ER diagram (showing all relationships) and supporting data dictionary (with name, data types, attributes and any comments e.g. validation rules). 

As part of your model these keys points should be identified: 

• Identify primary keys of each table considering the use of automatically generated values for these. 

• Identify the modality and cardinality of all relationships between entities and the foreign keys to support these. 

• Ensure your model supports correct referential integrity rules and constraints and document in data dictionary. 

• Ensure your model identifies data integrity or validation rules and document in data dictionary. 

• Identify where required the use of indexes and list in data dictionary. 

This IT Computer Science Assignment has been solved by our IT Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.