Transcript: Proposed System Screenshots and Sql Codes CUSTOMER TABLE ORDER TABLE SUPPLIER TABLE PRODUCT TABLE Relations OWNER TABLE
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
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
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
Transcript: Database Presentation for South Sea Cruises Group 17 Overview Overview Objectives To provide current and useful information Provide a database to evaluate trends and look for possible new cruises ideas and packages We have created a database that addresses each of SSC's requirements Cruises Itineraries Ships Information and more... Key constraints of a database are; Cost Security Compatibility Complexity Scope Limitations Entity Relationship Model ER Diagram Relational Schema Relational Schema SQL Video SQL Implementation SECURITY & PRIVACY Issues and Ethical Considerations Security Security Surge in e-commerce has led to an increasing amount of people providing private information over the internet. Leaving customers vulnerable having their highly sensitive information leaked and taken advantage of. 2011 Sony Playstation breach Implement; Views Encryption of certain data, Login details and passwords Segmenting the database Auditing Privacy PRIVACY Data/information privacy is concerned with the sharing of sensitive information with third-party institutions. Databases retain all customer information to provide market research to the company or other companies. 2017-2018 Facebook Key Features of Database Designed Key features of Database Through SQL each tables fields are explained with information about each field that uses abbreviated names Explaining Field Names Explaining Field Names Separating bookings into past, current, and future provides more clarity of what people are willing to pay through a cruise status number Separating Bookings into Past, Current and Future Separating Bookings to Past, Present & Future Most of the fields allowed to be left empty like docking fee and number of docks may be dependent on when South Sea Cruises actually decide to use them Some ports requires more research, particularly smaller ones with less of an online presence Planning of Future Ports and Tours Planning of Future Ports and Tours Crew information in our table not only provides information about ship number assigned, manager, it also elaborates on their job position and department Crew Details Crew Details An automation to the desgination of bookings to past, present and future as these will shift over time Ship Number assigning to Crew members field able to be left blank to account for those members currently not assigned or on leave, no means at this time to differentiate these Activties and Tours tables have capacities in mind but a means of implementing a limit check on these bookings required More information on means of docking, some cases like small Fijian Ports are too small for docking and what occurs is small boats carry passengers from a cruise that is offshore to the island Future improvements Future Improvements Inclusion of Onshore Staff Monitoring Overcoming Language and data sharing barriers Possible Improvements Possible Improvements QUESTIONS? QUESTIONS ?
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
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
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
Description: How do you stand out from the stacks of resumes on your prospective employer’s desk? With a Prezi resume template, of course! Create your own “Prezume” and and impress them with your cutting-edge dynamism and cool. All Prezi presentation templates are easy to customize.
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.
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.
Description: Impactful presentations need stunning visuals and a meaningful metaphor to show high-level concepts and the smaller details. This customizable presentation template uses a classic world map visual to help you navigate complex information while staying grounded in your presentation’s core message.
Now you can make any subject more engaging and memorable