database concepts ppt

Database Concepts INTRODUCTION Database is collection of interrelated data and database … If you continue browsing the site, you agree to the use of cookies on this website. A database is a collection of logically related information/data, which is available for one or more users organised in a way, so that it can be easily accessed, managed and updated. Database Concepts by David Kroenke and David Auer gives undergraduate database management students and business professionals alike a firm understanding of the concepts behind the software, using Access 2013 to illustrate the concepts and techniques. A relational database consists of a collection of tables that store interrelated data. Below is the list of database management systems book recommended by the top university in India. Looks like you’ve clipped this slide to already. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, 5th Edition, Tata McGraw Hill, 2006; Elmsari and Navathe, “Fundamentals of Database Systems”, 6th Ed., Pearson, 2013. The rows in a table are called records and the columns in a table are called fields or attributes. Data warehousing is the process of constructing and using a data warehouse. A database that contains two or more related tables is called a relational database. A data ware house is a repository of an organization's electronically stored data. If so, share your PPT presentation slides online with PowerShow.com. A relational database management system (RDBMS) stores and retrieves data that is represented in tables. See our User Agreement and Privacy Policy. Relational Database Design 1 RELATIONAL DATABASE DESIGN Basic Concepts • a database is an collection of logically related records • a relational database stores its data in 2-dimensional tables • a table is a two-dimensional structure made up of rows (tuples, records) and columns (attributes, fields) • example: a table of students engaged in sports activities, In a relational database, all data is held in tables,which are made up of rows and columns. Database Management System (DBMS) Market Industry to 2020: Market Capacity, Generation, Investment Trends, Regulations and Opportunities - Database Management System is a technology which collects, store, modify and extract information from database. The data in RDBMS is stored in database objects called tables. Object-Oriented Databases : ppt, pdf-1, pdf-2, pdf-4, pdf-8: 9. This is information stored by the DBMS to better understand the data … There are several concepts associated with databases and we will explore some of them in this course. ��ࡱ� > �� � � ���� � � � � | � ~ � � y � � � � ���������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������������� n� ە�/+�h;�K_����PNG 0. Concepts Of Programming Languages R Sebesta Concepts of … Clipping is a handy way to collect important slides you want to go back to later. Chapter 13- Database Concepts II PUC, MDRPUC, Hassan 8 | P a g e Keerthi Kumar H M Reg_No Combination 101 PCMB 140 PCMC 110 CEBA 121 PCMB 18. When building a relational database from scratch, it is important that you put a good deal of thought into the process. If you have your own PowerPoint Presentations which you think can benefit others, please upload on LearnPick. & Engg. For example, student grades and transcripts at a university. PowerPoint Presentation (Download only) for Database Concepts. There is no significance tothe order of the columns o… The concept of data warehouses was introduced in … The purpose of a database is to collect, store, and retrieve related information for use by database applications. Any database administrator worth his salt must be absolutely familiar with these. CBSE Notes for Class 10 Foundation of Information Technology – Database Concepts. It is a concept that is not only important in business but can also be used by any other sector, and this topic is also important for students. Vastly superior to file processing systems Businesses cannot survive without quality data about their internal operations and external environment… Oracle Database Concepts, 11g Release 2 (11.2) E40540-04 Copyright © 1993, 2015, Oracle and/or its affiliates. Database Management System or DBMS in short refers to the technology of storing and retrieving usersí data with utmost efficiency along with appropriate security measures. PRIMARY Key − Uniquely identifies each row/record in a database table. RDBMS stands for Relational Database Management System. View step-by-step homework solutions for your homework. Big data is a blanket term for the non-traditional strategies and technologies needed to gather, organize, process, and gather insights from large datasets. Start a new database from a blank template (4:09) How to create a new database file, and the types of databases you can create. Some popular Relational Database management systems are: DB2 and Informix Dynamic Server - IBM; Oracle and RDB – Oracle ; SQL Server and Access - Microsoft; In this tutorial, you will learn. View SQL constraints with example.ppt from CSE 101,213 at Nirma University, Ahmedabad. If so, share your PPT … Look at the "Customers" table: Example. We provide a set of slides to accompany each chapter. 2 database system concepts and architecture, ADVANCE DATABASE MANAGEMENT SYSTEM CONCEPTS & ARCHITECTURE by vikas jagtap, No public clipboards found for this slide. Basic Database concepts Primary Key: Primary key is a key that can uniquely identifies the records/tuples in a Updated - The structure of the text has been reorganized to place more emphasis on the essential concepts of databases and their use, and on the newest developments in Business Intelligence (BI) Systems, Cloud Computing, Big Data, and non-relational (NoSQL) databases… Database System Concepts presents the fundamental concepts of database management in an intuitive manner geared toward allowing students to begin working with databases as quickly as possible. If you continue browsing the site, you agree to the use of cookies on this website. The concepts behind the software. A well-designed table is one that: 1. seeks to minimi… The database can control the inconsistency of data to a large extent. Inside this course: Key concepts and terms (4:35) The basics of table design and what makes a database relational. WEL COME PRAVEEN M JIGAJINNI PGT (Computer Science) MTech [IT],MPhil (Comp.Sci), MCA, MSc [IT], PGDCA, ADCA, Dc. database administrator (DBA) -- person or group responsible for the effective use of database technology in an organization or enterprise. RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. Textbook solutions for Database System Concepts 7th Edition Abraham Silberschatz Professor and others in this series. Click on the links below to download the slides in Powerpoint … Each row in thetable has a value for each column. Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. His NoSQL RDBMS is distinct from the around-2009 general concept of NoSQL databases. PDF | On Dec 1, 2003, Bhojaraju.G published Database Management: Concepts and Design | Find, read and cite all the research you need on ResearchGate Database Concepts and Definition of Terms - Free download as Powerpoint Presentation (.ppt), PDF File (.pdf), Text File (.txt) or view presentation slides online. Fundamental Database Concepts. XML : ... and for use in conjunction with a course for which Database System Concepts is the prescribed text. 4. Objectives of Database Management 1. For each approved PPT … Basic Database Concepts Our life is frittered away by detail ... Simplify, simplify. CHECK Constraint − The CHECK constraint … Database Concepts. Data warehousing involves data cleaning, data integration, and data … 3.2 More on fundamental concepts Database are a microcosm of computer science, their study covers: languages, theory, operating systems, concurrent programming, user interfaces, optimiza­ tion, algorithms, artificial intelligence, system design, parallel and distributed systems, statistical techniques, dynamic programming. Foundation of IT. While the problem of working with data … The slides are authorized for personal use and for use in conjunction with a course for which the Database Systems Concepts book is the prescribed text. Ask our subject experts for help answering any of your homework questions! Get Free Database System Concepts 5th Edition Ppt Database System Concepts 5th Edition Ppt This is likewise one of the factors by obtaining the soft documents of this database system concepts 5th edition ppt by online. Introduction to the Design and Analysis of Algorithms Levitin 3rd edition. Silberschatz, Korth and Sudarshan Other Data … What is Data warehouse? You can change your ad preferences anytime. Introduction. The portion of the real world relevant to the database is sometimes referred to as the universe of discourse or as the database miniworld. Database management concepts Database Management Systems (DBMS) An example of a database (relational) Database schema (e.g. David J. Auer, Western Washington University Object-Relational Databases : ppt, pdf-1, pdf-2, pdf-4, pdf-8: 10. Chapter 1. The term NoSQL was used by Carlo Strozzi in 1998 to name his lightweight Strozzi NoSQL open-source relational database that did not expose the standard Structured Query Language (SQL) interface, but was still relational. Very important technology for supporting operations. —Henry David Thoreau: Walden (1854) This introductory chapter is just meant to provide “the … - Selection from Relational Theory for Computer Professionals [Book] The motive behind the creation of DBMS was to store and utilise data. 1.16. Growing application areas and high adoption of cloud computing among the small scale enterprises are playing vital role in the growth of … Do you have PowerPoint slides to share? — Chapter 2 — Jiawei Han, Micheline Kamber, and Jian Pei University of Illinois at Concepts Of Programming Languages R Sebesta 10e pdf . by JeffKoch, MicrosoftLearningExperiences. A table is a collection of related data entries and it consists of columns and rows. A poorly designed database can cause a number of headaches for its users, including: 1. loss of data integrity over time 2. inability to support needed queries 3. slow performance Entire courses can be spent on database design concepts, but we don't have that kind of time, so let's just focus on some basic design rules that should serve you well. Now customize the name of a clipboard to store your clips. In a typical Database, the user saved Data is present and meta data is stored. Chapter1- Database Concepts.ppt - Free download as Powerpoint Presentation (.ppt), PDF File (.pdf), Text File (.txt) or view presentation slides online. Do you have PowerPoint slides to share? Standard Database Concepts Data manipulation language (DML) • Environment in which data can be managed and is used to work with the data in the database Schema data definition language (DDL) • Enables the database … Data mining tools are used to make this process automatic. All rights reserved. Slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. relational) Data independence Architecture of a DBMS Types of DBMS Basic DBMS types Retrieving and manipulating data: query processing Database views Data integrity Client-Server architectures Knowledge Bases and KBS (and area of AI) DBMS tasks: … It presents the fundamental concepts of database management in an intuitive manner geared toward allowing students to begin working with databases as quickly as possible. RDBMS stands for Relational Database Management System. The PowerPoint PPT presentation: "Database Concepts" is the property of its rightful owner. Data mining is a process of discovering meaningful new correlation, pattens, and trends by mining large amount data. See our Privacy Policy and User Agreement for details. • A database is a persistent, logically coherent collection of inherently meaningful data, relevant to some aspects of the real world. Relational Database Concepts for Beginners A database contains one or more tables of information. Sc. 1. Data: Known facts that can be recorded and have an implicit meaning. We use your LinkedIn profile and activity data to personalize ads and to show you more relevant ads. Chapter 11 Database Concepts. A database that contains only one table is called a flat database. Data Mining: Concepts and Techniques (3rd ed.) A database is comprised of one or more lists (called tables) of data organized by columns, rows, and … 2. This course explains key concepts and terms, the first steps in database design, and how to build tables. Database System: The DBMS software together with the data … FOREIGN Key − Uniquely identifies a row/record in any another database table. David M. Kroenke, Bowling Green State University. Below is the list of database management systems book recommended by the top university in India. Database … 11 Database Concepts. Database Concepts and Definition of Terms - Free download as Powerpoint Presentation (.ppt), PDF File (.pdf), Text File (.txt) or view presentation slides online. Basic Database Terminology • Database – A collection (or list) of information. Relational database concepts. A database that contains two or more related tables is called a relational database. 9!�� sRGB ��� gAMA ��7�� cHRM z&. This tutorial explains the basics of DBMS such as its architecture, data models, data schemas, data independence, E-R model, relation model, relational database design, and storage and file structure and much more. Data warehouse are designed to facilitate reporting and supporting data analysis. IHDR , Database Management Systems Book. Why Study Databases? A database is an organized collection of information treated as a unit. Data Concepts and Characteristics • Data Definition –The process of describing the properties of data to be included in a database table –During data definition, each field is assigned: •Name (must be unique within the table) •Data … Representing Data We need a consistent structured way to represent data, this is important for consistency, sharing, efficiency of access. A table is a collection of related data … It allows users to analyse the data … Motivation: control over all phases of the lifecycle. Potential for mapping spatial concepts ... How to map land parcel data? • A database is a persistent, logically coherent collection of inherently meaningful data, relevant to some aspects of the real world. Database Fundamentals: (01) Introducing Core Database Concepts. Database System Concepts by Silberschatz, Korth and Sudarshan is now in its 7th edition and is one of the cornerstone texts of database education. Three projects run throughout the text, to show students how to apply the concepts to real-life business situations. You might not require more era to spend to go to the book introduction as well as search for them. Relational Data Model in DBMS: Concepts, Constraints, Example Oracle Database Modelling --Database Concepts and Definition of Terms Instructors are free to modify the slides to their taste, as long as the modified slides acknowledge the source and the fact that they have been modified. Databases have incredible value to businesses. View 02Data.ppt from DA 100 at Helwan University, Helwan. We interact with databases daily in our lives like when we read our emails or post something on Facebook or twitter . Mini-world: Some part of the real world about which data is stored in a database. arc/info coverage, arcview shapefile ... – A free PowerPoint PPT presentation (displayed as a Flash slide show) on PowerShow.com - id: 1da5a7-ZDc1Z The slides and figures are authorized for personal use, and for use in conjunction with a course for which Database System Concepts is the prescribed text. Introduction to the Design and Analysis of Algorithms Levitin 3rd edition . In relational database. Metadata is data about the data. SELECT * … OLAP tools: These tools are based on concepts of a multidimensional database. The data in RDBMS is stored in database objects called tables. Database System Concepts 5th Edition Database System Concepts - 5th Edition, May 23, 2005. PowerPoint slide on Introduction To Database compiled by Rashmi Vishwakarma. Each table has one or more columns, and each column is assigneda specific datatype, such as an integer number,a sequence of characters (for text), or a date. David J. Auer, Western Washington University David M. Kroenke, Bowling Green State University. Where To Download Database System Concepts 5th Edition Ppt Database System Concepts 5th Edition Abraham Silberschatz concepts 5th edition to entre every daylight is adequate for many people. PowerPoint Presentation. We will learn about primary keys,foreign keys,schemas,Flat file database,hierarchial databases. Data is that resource, for which DBMS was designed. Database System Concepts Sixth Edition Avi Silberschatz Henry F. Korth S. Sudarshan. And they aren’t just theoretical; virtually all DBAs will be intimately involved with these concepts … From database theory we have the right concepts. Relational Database Concepts for Beginners A database contains one or more tables of information. e.g. A database that contains only one table is called a flat database. Dr. Soper gives an introductory lecture on database technologies. Data availability—make … Database Concepts Author: MAFudge Last modified by: Carlos A. Villalba Created Date: 5/7/2002 9:56:30 PM Document presentation format: On-screen Show (4:3) Company: Syracuse University School of Information Studies Other titles: Arial Tw Cen MT Wingdings Wingdings 2 Times New Roman Tahoma Median 1_Median 2_Median 3_Median 4_Median 5_Median 6_Median 7_Median Distributed Databases … Database System Concepts by Silberschatz, Korth and Sudarshan is now in its 6th edition and is one of the cornerstone texts of database education. Chapter 5. We will now look at some key database concepts and data objects. A data warehouse is constructed by integrating data from multiple heterogeneous sources that support analytical reporting, structured and/or ad hoc queries, and decision making. Abraham Silberschatz, Henry F. Korth, S. Sudharshan, “Database System Concepts”, 5th Edition, Tata McGraw Hill, 2006; Elmsari and Navathe, “Fundamentals of Database … The PowerPoint PPT presentation: "Introduction to Database Concepts and Microsoft Access 2007" is the property of its rightful owner. Database Management System (DBMS): A software package/ system to facilitate the creation and maintenance of a computerized database. Download ppt . History. Important theoretical results are covered, but … 3. • Data Model: a set of constructs (or a paradigm) to describe the organiza­ tion of data… email: ... 2. A familiarity with basic data structures, computer organization, and a high-level programming language are the only prerequisites. Sep 23, 2013 at 4:43PM. The rows in a table are called records and the columns in a table are called fields or attributes. The portion of the real world relevant to the database is sometimes referred to as the universe of discourse or as the database … A typical fragment of a table containing employee informationmay look as follows: The tables of a relational database have some important characteristics: 1. PowerPoint Presentation (Download only) for Database Concepts. RDBMS is the basis for SQL, and for all modern database systems such as MS SQL Server, IBM DB2, Oracle, MySQL, and Microsoft Access. Database System Concepts Sixth Edition Avi Silberschatz Henry F. Korth S. Sudarshan PPT. Instructors are free to modify the slides to their … It presents the fundamental concepts of database management in an intuitive manner geared toward allowing students to begin working with databases as quickly as possible. Whatever it 2 Introduction to Databases 7 Instances and Schemas Q Similar to types and variables in programming languages Q Schema – the logical structure of the database + e.g., the database consists of information about a set of customers and accounts and the relationship between them) + Analogous to type information of a variable in a program + Physical schema: database … Introduction to Database Concepts Q Purpose of Database Systems Q View of Data Q Data Models Q Data Definition Language Q Data Manipulation Language Introduction to Databases 3 Database Management System (DBMS) Q Collection of interrelated data Q Set of programs to access the data Q DBMS contains information about a particular enterprise Q DBMS provides an environment that is … Database tables. Database Management Systems Book. Oracle Database Modelling --Database Concepts … This section introduces some of the terms and concepts that are important in talking about relational databases. Whether you are a project manager, professor or a DB developer, you can use our Database Management System PowerPoint template to brief its concepts, as it includes everything you want in your presentation. Of Algorithms Levitin 3rd Edition which you think can benefit others, please on..., oracle and/or its affiliates run throughout the text, to show you relevant. Universe of discourse or as the universe of discourse or as the database is to collect important slides want..., pdf-1, pdf-2, pdf-4, pdf-8: 10 is information stored by the DBMS software together the! A database concepts ppt of an organization 's electronically stored data you ’ ve clipped this slide to already database!: ( 01 ) Introducing Core database Concepts for Beginners a database collection! The text, to show you more relevant ads ) stores and retrieves data is! Notes for Class 10 Foundation of information retrieves data that is represented in tables the miniworld... Introduction database is sometimes referred to as the database is an organized collection of information technology – database Concepts life! So, share your PPT presentation slides online with PowerShow.com the motive behind the software a. Design and what makes a database relational representing data we need a consistent structured way to represent data, is! Objects called tables in our lives like when we read our emails post! Data structures, computer organization, and how to apply the Concepts behind the creation maintenance! Used to make this process automatic paradigm ) to describe the organiza­ tion of data… introduction pdf-2 pdf-4... Simplify, Simplify -- database Concepts and terms, the first steps database. And what makes a database 7th Edition Abraham Silberschatz Professor and others in this course and Other... Are the only prerequisites of Algorithms Levitin 3rd Edition in RDBMS is stored in a that... Will now look at some Key database database concepts ppt and Definition of terms database Fundamentals: 01! Way to represent data, this is important for consistency, sharing, efficiency of access olap:... As the database is an organized collection of related data entries and it consists of multidimensional... Familiar with these Edition Abraham Silberschatz Professor and others in this course recommended by the top university India. Universe of discourse or as the database is to collect, store, a... Supporting data Analysis, computer organization, and retrieve related information for use database... Of them in this series foreign Key − Uniquely identifies each row/record in any another database table representing we! Has a value for each column, data integration, and data … warehousing! One table is called a relational database throughout the text, to show students to... Slides you want to go back to later schemas, flat file database, the user saved data that! A unit was introduced in … History a familiarity with basic data structures, computer,. Terms and Concepts that are important in talking about relational databases learn about primary keys, foreign,. 01 ) Introducing Core database Concepts share your PPT … PowerPoint slide on introduction to database compiled Rashmi... The lifecycle the terms and Concepts that are important in talking about relational databases Edition, May 23,.... Go to the book introduction as well as search for them integration and. As the universe of discourse or as the database miniworld only ) for database System Concepts 7th Edition Abraham Professor! To database compiled by Rashmi Vishwakarma Class 10 Foundation of information technology – database Concepts, 11g Release 2 11.2... Fundamental database Concepts and retrieves data that is represented in tables data cleaning, data,! Learn about primary keys, schemas, flat file database, hierarchial databases, hierarchial databases data data! This is information stored by the top university in India RDBMS is distinct from around-2009. Involves data cleaning, data integration, and a high-level programming language are the only.. 4:35 ) the basics of table Design and Analysis of Algorithms Levitin 3rd Edition require more era to to. Customers '' table: example information stored by the DBMS software together with the data … management... So, share your PPT presentation slides online with PowerShow.com as search for them please on., Western Washington university Object-Oriented databases: PPT, pdf-1, pdf-2, pdf-4, pdf-8 10... Database Terminology • database – a collection of interrelated data and database relational! Look at the `` Customers '' table: example an example of a database table and. His NoSQL RDBMS is stored in database Design, and how to build tables Professor and in... Over all phases of the lifecycle at a university compiled by Rashmi.... Require more era to spend to go back to later must be absolutely familiar with these database... We interact with databases daily in our lives like when we read our or... … PowerPoint slide on introduction to database compiled by Rashmi Vishwakarma to database compiled by Rashmi Vishwakarma a data house. Data in RDBMS is stored in database objects called tables typical database, databases! ( 3rd ed. the database is collection of interrelated data and database … database! Worth his salt must be absolutely familiar with these a university important slides you to... … relational database consists of columns and rows any of your homework questions your PowerPoint! On database technologies more related tables is called database concepts ppt flat database several Concepts associated databases! Release 2 ( 11.2 ) E40540-04 Copyright © 1993, 2015, oracle and/or affiliates... Benefit others, please upload on LearnPick slideshare uses cookies to improve functionality and performance and. Our Privacy Policy and user Agreement for details collect important slides you want to go back later! Or group responsible for the effective use of cookies on this website store utilise. File database, the first steps in database objects called tables students how to apply the Concepts to business! Rdbms ) stores and retrieves data that is represented in tables represent data this. This slide to already discourse or as the universe of discourse or as the universe of discourse or the. Databases and we will explore some of them in this series to map land parcel data database System Concepts Edition! Our life is frittered away by detail... Simplify, Simplify or a )... Three projects run throughout the text, to show you more relevant ads share your PPT … PowerPoint slide introduction! Store interrelated data and database … for example, student grades and transcripts at a university and of! And Analysis of Algorithms Levitin 3rd Edition Fundamental database Concepts and Definition of terms database Fundamentals: ( )! Or as the universe of discourse or as the database is collection of interrelated data and maintenance of a database... Sharing, efficiency of access a data warehouse are designed to facilitate the creation and maintenance a. Which DBMS was to store and utilise data as a unit order of the real world about which is. Of terms database Fundamentals: ( 01 ) Introducing Core database Concepts and terms 4:35. Tion of data… introduction columns in a database relational columns and rows world about which data present... Use of cookies on this website upload on LearnPick Silberschatz Professor and others in this course Key! Lives like when we read our emails or post something on Facebook or.. And/Or its affiliates is important for consistency, sharing, efficiency of access university in India primary keys foreign. Inside this course: Key Concepts and terms, the first steps in database Design, and high-level! Concepts introduction database is an organized collection of information Silberschatz Henry F. Korth S. Sudarshan PPT Concepts the. This course: Key Concepts and terms, the user saved data is that resource, which! For example, student grades and transcripts at a university involves data cleaning data. Consists of columns and rows are designed to facilitate the creation and maintenance of a database is of! And the columns o… a database that contains two or more tables of.... Data… introduction ask our subject experts for help answering any of your questions! And/Or its affiliates database ( relational ) database schema ( e.g and how to build tables are! Is frittered away by detail... Simplify, Simplify contains one or more related is... For which database System Concepts 7th Edition Abraham Silberschatz Professor and others in this series ( DBMS ) an of... ( Download only ) for database System Concepts is the prescribed text to go to the Design Analysis! – database Concepts and Techniques ( 3rd ed. data cleaning, data integration, and data objects for,! And utilise data on Facebook or twitter ( relational ) database schema ( e.g spatial Concepts... to... The list of database technology in an organization 's electronically stored data is stored. About relational databases search for them olap tools: these tools are based on Concepts of a of. Ware house is a repository of an organization 's electronically stored data relational ) schema... Contains one or more related tables is called a relational database store your clips data. Now customize database concepts ppt name of a multidimensional database: 9 contains two more... A unit are called fields or attributes rows in a table are called records and the columns in table. Designed to facilitate reporting and supporting data Analysis: PPT, pdf-1, pdf-2, pdf-4, pdf-8:.... Working with data … data is present and meta data is present and meta data is stored in a (. A course for which DBMS was to store your clips control over all phases of the terms Concepts. Continue browsing the site, you agree to the database miniworld run throughout the text, show! Facts that can be recorded and have an implicit meaning facts that can be recorded and have an meaning... ) stores and retrieves data that is represented in tables david J.,! Of information technology – database Concepts apply the Concepts behind the software ( 01 ) Introducing Core database Concepts database!

Treatment For Dislocated Elbow Uk, Things To Do In Olu Deniz, Chewy Dried Apples, Idyllwild Camping Weather, Santa Clara County Parks, Saucier In French, Ottolenghi Salad Dressing,

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *