Database 20232 Final Presentation 2020.pptx

about database

1. Presentation Presented By: Ramesh Thapa Presented to: Atut Gorkhali (Sir) Faculty: BSc.IT Subject: Database Section: A Submitted on: 6/4/2021 Roll No.: 31 International School Of Management and Technology Tinkune, Kathmandu

2. Agenda Demonstration of the prepared software. Highlight the correctness of the database system, input and output interfaces, ER Diagram SQL validation checks data security Back up and Restore Authentication And Authorization

3. Introduction Database is a collected information which is in an organized form for easier access, management, and various updating. Any system or technology that creates and manages databases is called a database management system (DBMS). DBMS is the software tool for database which helps to organize (create, retrieve, update, and manage) data. Cylinder is the typical diagram representation for a database .

4. In this ongoing project the DBMS is used because , To develop software app in less given time. Data independence and efficient use of data. For uniform data administration. For data integrity and security. For making easier to access to data, and data backup. For using user-friendly query language.

5. ER Diagram of the Modern Tech Database

6. SQL SQL is the language that lets access and manipulate databases. If anyone want to pull, edit, add information to a database, SQL is use to do that. SQL is the language that only speaks to the Relational database, which is essentially a database that has a tabular schema . So, it’s a lot like a data table with rows and columns

7. User Interface UI design is the process of creating the look and feel of an application’s user interface. The user interface (UI) encompasses both the appearance and interactivity of an app. The designed for the desktop application for this project visual studio is used. In the application, there are total 16 forms which include 1 login form, 1 homepage, 9 insert forms and view, and 4 report form and 1 reset password form. The name of the desktop application is Modern tech which includes all the necessary information about the Marketing ticket.

8. Login

9. Homepage

10. Customer

11. Employee

12. Roles

13. Ticket Type

14. Ticket Priority Type

15. Ticket Status Type

16. Project

17. Ticket Form

18. Ticket Log Form

19. Ticket History

20. Summary Report

21. Active Employee Report

22. Employee History

23. Password Change UI

24. About Form

25. Data Validation Data validation is an essential part of any data handling task whether you’re in the field collecting information, analyzing data, or preparing to present data to stakeholders. If data isn’t accurate from the start, your results definitely won’t be accurate either. That’s why it’s necessary to verify and validate data before it is used. Some Data Validation that used in the modern tech application are:

26. Login

27. Password Change

28. Employee

29. Employee

30. Employee

31. Data Security Data security is a set of standards and technologies that protect data from intentional or accidental destruction, modification or disclosure. Data security can be applied using a range of techniques and technologies, including administrative controls, physical security, logical controls, organizational standards, and other safeguarding techniques that limit access to unauthorized or malicious users or processes

32. Back up Database backup is the process of backing up the operational state, architecture and stored data of database software. It enables the creation of a duplicate instance or copy of a database in case the primary database crashes, is corrupted or is lost. The full back up of the ongoing project (MarketingTicketingSystem) database using SQL Server Management studio has done.

33. Restore Database Restore Database command is the most basic and universal way to restore SQL Server backups Full backups contain all information necessary to restore database to the point in time when the backup process had finished. The backup will overwrite your database if such is exist or produce a new SQL Server database. The Restore database of the ongoing project (MarketingTicketingSystem) database using SQL Server Management studio has done.

34. Authentication Authentication is used by a server when the server needs to know exactly who is accessing their information. Authentication is used by a client when the client needs to know that the server is system it claims to be. In authentication, the user or computer has to prove its identity to the server or client.

35. Authentication Example

36. Authorization Authorization is a process by which a server determines if the client has permission to use a resource or access a file. Authorization is usually coupled with authentication so that the server has some concept of who the client is that is requesting access.

37. Authorization Example

38. Thank You…

39. Any Questions!