You're about to create your best presentation ever

Get started with Prezi

Presentation Background Database

Create your presentation by reusing one of our great community templates.

Database Presentation

Transcript: Proposed System Screenshots and Sql Codes CUSTOMER TABLE ORDER TABLE SUPPLIER TABLE PRODUCT TABLE Relations OWNER TABLE

DATABASE PRESENTATION

Transcript: MIS- 3353 DATABASE MANAGEMENT PROJECT ShaQuiLe Team Introduction Claire Corley Hunter Stringfellow Chloe Plumley Angela Ha Hannah Hersley Assumptions Client Meeting We made the assumption this food truck does not work 24 hours. We made an assumption that you could only use one discount per purchase. Each customer only has one phone number (No home phones or work phones) We assume that the truck moves depending on the day and has no set location. We assume that each employee is capable of working different shift(cook vs cashier) Customers only have one email on record. ERD Milestone 1 ERD Overview What is an ERD? Why is it necessary? An ERD is a visual representation of how data is stored in a database for easy retrieval and business proceedings. What business cycle was used? We decided to use the revenue and expenditure. This is because the taco truck has an expenditure cycle for purchasing the ingredients and materials and revenue for selling the products. ERD ERD PT 1 ERD ERD PT 2 ERD ERD PT 3 SQL Queries SQL Normilization Milestone 2 Normilization What is normilization and what is the purpose? Normilization Normalization is the process of organizing data within a conceptual database. This translates the conceptual designs into a series of relations, columns, and rows. Normilization of the data provided by the client. We put the assortments of food and combos offered at the taco truck as their own entity, which makes them atomic. Employees, Customers, Wholesale, Purchase Order, Purchase Order Line, Raw Materials, and Product are all considered 3NF, because there is no date duplication and there are no transitive dependencies for non-prime key attributes. Data Dictionary Milestone 3 Implementation Implementation Physical Design What is physical Design and Implementation? Physical Design The physical design is the actual database itself which is used to store and retrieve data for the taco truck. This is implemented for this project through SQL server, and then uses SQL to retrieve the data using queries. What is denormilization? Unlike a Normalized Database, Denormalization adds more specific types of data into the system, which can cause redundancy in some tables. Database Database Challenges What was our biggest challenge? Challenges One of our biggest challenges was correcting the previous stages of the database. As this project has progressed, we have edited the original design several times so that it could run as smoothly as possible, by following feedback and testing query feasibility. Weakness and stregnths? mhk Additional Queries Queries

Database Presentation

Transcript: The Database 2. Age: 40+ 3. Size <= 1500 squared feet Land + User - All users must be registered in system under unique User ID - Registration grants access/use to system - Upon death UserID is maintained to ensure continual record history - Titles are created when a user's UserID & land parcel's LandID are linked - No two titles can contain the same LandID -> Prevents multiple ownership - Multiple titles can contain the same UserID -> Allows a user to own multiple parcels = Concept A Parcel of Land All utilities are inherent to each parcel. Sample Queries Rights & Responsibilities Ryder Kiehl Huaqiu Liu Adam Clare Robert Fung ENGO455 - Assignment #4 Database Design Samples Queries Balancing Land & User Hanging in the Balance A User Only R.O.W on titles are water access - All parcel's are perfect rectangles (no curved boundaries) - Monuments @ NE & SE boundary corners - Defined by its size: A & NS boundary: x 1. Last Name: Burns - TitleID, Name, - LandID, Heir, and Name of land A Title

Database Presentation

Transcript: Manager Queries & Reports Accountant Customer Search Residential customer search Commercial customer search Vehicle Search Residential Vehicle search Commercial vehicle search View Vehicle History Service Details Check vehicle mechanic history Visit cost report Team Accountant Queries & Reports Name: Stansliv Matyusheko Responsibilities: Tracks invoices and pays bills Prepares income & expense reports Mechanic Trigger Name: Cornelius Rodriguez Responsibilities: Ordering supplies & stock. Creates employee schedules. Receptionist Name: Sheila Jackson Responsibilities: Handles customers scheduling visits processing payments Nick Fisher, Tim Foley, Eric Lech, & Paul Vacey -aka DB Jesus Receptionist Queries & Reports Auto repair shop Standard maintenance 12 mechanics Open 6 days per week. Mechanic Queries & Reports Update Supplies on hand View Employee Schedule Employee Vehicle assignments Performance Report Name: Brewer DeerSlayer Responsibilities: maintenance & repairs vehicle work orders Manager Entity Relationship Diagram Monthly Revenue Unpaid Bills Commercial Credit Lines Henley Automotive Shop

DATABASE presentation

Transcript: Geo-Information for Urban Planning and Adaptation to Climate Change Status of ISEG DATABASE- a case study of Faridpur Project area Contents Geo-Information for Urban Planning and Adaptation to Climate Change (GPAC) Bangladesch – German Technical Cooperation Project Database Data quality ISEG database Data entry Findings Conclusion Database DataBase A database is a collection of information that is organized so that it can be easily accessed, managed and updated. Data is organized into rows, columns and tables, and it is indexed to make it easier to find relevant information. Data Quality Data Quality Data quality is a perception or an assessment of data's suitability to serve its purpose in a given context. Key factors The quality of data is determined by factors such as Data Completeness Data Consistency Data Quality Data Accuracy Data Timeliness Data Uniqueness Data Validity Data completeness refers to whether all available data is present. Borehole data SPT data Geotechnical data Waypoint data Data completeness Importance Importance Poor- quality data is often attached as the source of erroneous reporting and unrealistic approaches. When collecting data, it is important that the data collected are of high quality so that we can be reliably using as the basis to make sound results. To ensure data quality, data control measures must be applied at every stage of the data collection process. ISEG Database ISEG database An open source software ‘PostgreSQL’ database was used to prepare the ISEG database. ‘PostgreSQL’ is the world’s most advanced open source database. Methodology DB Team Key Players Mohammad Feruj Alam, Sarwat Jabeen, Tahera Afrin Md. Khairul Islam Ahmed Shoeb Werner Buchert Data completeness is around 90% All data are consistent Timeliness within November all data should be entered. For PSA accuracy is 90% Each and every BH is Unique. nothing is entered more than once ISEG DB Quality ISEG DB Data entry Processes of data check- Excel table query Checking missing information or identifying suspicious information determine the data accuracy Up to date Data Checking Finding Waypoints Info Photo info Overview of project areas Case study - Faridpur project area Statistical analysis of SPT(N30) SPT info Summary of all collected & tested samples Geotechnical info Waypoints Distance analysis of Waypoints location Map Photo information of the Project area Data Overview of project areas Conclusion These expected grain size analysis test results are 2011 but the actual amount of receiving results are 1807 instead of 2011, as some samples are missing of different depth because of • few samples are damaged during extrusion , • samples are not sufficient to perform test Data accuracy 90% Thank you

Database Presentation

Transcript: Our team is working on a project Bus Express Booking System. The Bus Express Booking System is a huge developing business in Malaysia and other countries. ER - Diagram Organization Chart Bus Express Booking System What is our project all about?? Thank You The Online Bus Express Booking System is a web-based application that allows visitors to check bus ticket availability, buy bus ticket and pay the bus ticket online . This system is established for all the home/office users after gaining access from the administrator. By: Uthman Ibnu Affan Team Explain more! 1..1 make > 1..* 1..1 has > 1..1 1..* drive > 1..1 1..* < has 1..1 1..1 pay > 1..1

Database Presentation

Transcript: Light For Business Your name international business man International Recourse Quality Money Why ? TIMELINE How ? Our Roll Light For Business connect Business Plan Import Export Life Time support Title f

Database Presentation

Transcript: Gymnasium database www.cela-network.com Data flow diagram The database forms Reports Autonumber Number Text Boolean Currency Date/Time Blogs/Journals Bibliography (Harvard system) Websites Allan, B 2010, ‘Microsoft access tips: Data Types in Access’, Allen Browne's Database and Training, viewed 8 November 2011, <http://allenbrowne.com/xbase-05.html>. Function, X 2000,’Mail merge: Mail merge with an MS access database’, Mail merge tutorial, viewed 19 November 2011, <http://www.functionx.com/mailmerge/access.htm>. Mary, A 2005,’ article switchboard: add a switchboard to access application’, viewed 1 November 2011, <http://www.techrepublic.com/article/add-a-switchboard-to-your-access-application/5656204>. Books Gary, B 2010, Microsoft Access 2010:Comprehensive, shelly cashman series, channel centre Boston, USA. Philip, J 2008, Microsoft office access: concepts and techniques, Stamford, Connecticut, USA. Primary key Switchboard Design Data types www.cela-network.com Context Diagram Gantt chart diagrammatic view of system ERD Diagram Planning Data Dictionary

Explore our templates for more presentation inspiration

World Map - Atlas

Description: For program proposals, grant requests, or any other nonprofit or education presentation, this beautiful world map-inspired creative Prezi template will engage and captivate your audience. All Prezi education templates and Prezi nonprofit templates are easy to customize.

Grant Proposal Presentation for NonProfit & Education | Prezi

Description: For grant requests, program proposals, or any other kind of nonprofit or education presentation, this graphite drawing-inspired creative Prezi template is the way to generate interest. Like all Prezi education templates and Prezi nonprofit templates, it’s easy to customize.

Best Creative Resume Templates to Customize | Prezi

Description: Stand far above the stacks and stacks of flat, boring resumes on any hiring manager’s desk with a Prezi resume template. Just customize this Prezi presentation template to create your very own “Prezume” and impress them with your dynamism, coolness, and originality.

Easy Book Presentation Template for Individual Design | Prezi

Description: When you need to clearly spell out your message, this creative Prezi template is the way to go. As with all Prezi education templates and Prezi nonprofit templates, this one is easy to customize to let you zoom in on your ideas or pull back to show the big picture.

Now you can make any subject more engaging and memorable

Get started with Prezi