International Journal Engineering Science †Myassignmenthelp.Com

Question: Discuss About The International Journal Engineering Science? Answer: Introducation The client table has ClientID as the primary key and all the information regarding the clients can be acquired from the client table by using the ClientID. Hence the 3NF normalization for the relation is also maintained efficiently. The FullName, State, Street, City PostalCode, Phone and the Level express the transitive dependency for the table and also the data redundancy and the data duplication issues can also be resolved easily by the table. The Functional Dependencies for the Car table is provided below: RegNo Model, Maker, Color, ProducedYear, CarPrice, WarrantyPeriod The Car table has RegNo as the primary key and all the information regarding the clients can be acquired from the client table by using the RegNo. Hence the 3NF normalization for the relation is also maintained efficiently. The Model, Maker, Color, ProducedYear, CarPrice and WarrantyPeriod express the transitive dependency for the table and also the data redundancy and the data duplication issues can also be resolved easily by the table. Interesting procedure that were learnt during the course of this assignment In this assignment the concept was value masking was also learnt. The value masking was required for setting up the constrains in the system. This was used in the case of the registration number of the car. Specific constrains for the car was mentioned in this assignment and hence the value masking provided ample scope to describe the constrains aptly. During the course of this assignment the concepts of Date methods were learnt in this report. The DateAdd() method and the Date() Methods were used in this assignment for fetching the required queries. The assignment had the use of the Date() method in the query number 6 and the method was very efficient in obtaining the data as per the requirement of the assignment. The Now() function available in the system provides the current date and tie for the system. This function was also of great use during the course of the assignment. The most complex task in the assignment The most complex task for the assignment was the setting up the sub report in report. There was a requirement of setting up of an average of the total cost for the services for a car. The average function was not available in the single report and function of average was implemented in the sub report and the sub report was included within the main report. References Gouhar, A., 2017. Database Management System.International Journal of Engineering Science,11766. Nidzwetzki, J.K. and Gting, R.H., 2016.DISTRIBUTED SECONDO: An extensible highly available and scalable database management system. FernUniversitt, Fakultt fr Mathematik und Informatik.