NO

@@srinubondada I m finding more but I didn't get the course of odi ..can u suggest me any other platform

Sorry

kzbin.info/www/bejne/ZmWygqGCbMp5rLs&pp=gAQBiAQB

Increase playback speed :)

kzbin.info/www/bejne/ZmWygqGCbMp5rLs&pp=gAQBiAQB

kzbin.info/www/bejne/ZmWygqGCbMp5rLs&pp=gAQBiAQB

did you get answer for your question on appending system date to the filename

A logical schema is created to define the structure, relationships, and constraints of data in a database without considering the physical implementation details. It provides a conceptual representation of the data and serves as a blueprint for designing the database. The reasons for creating a logical schema instead of relying solely on a physical schema include: 1. Data Independence: The logical schema provides a layer of abstraction between the physical implementation and the application programs or users accessing the database. This allows for changes in the physical storage structures without affecting the logical representation of the data. It provides data independence, meaning that modifications to the physical schema, such as adding or removing indexes, reorganizing storage, or changing hardware, do not require modifying the logical schema or the applications using the database. 2. Simplified Application Development: By defining a logical schema, developers can design and implement applications without needing to know the intricate details of how the data is physically stored. This separation allows developers to focus on the logical structure and relationships of the data, making application development faster and more efficient. 3. Improved Data Integrity and Consistency: The logical schema enables the definition of constraints, such as primary keys, foreign keys, and business rules, which ensure data integrity and consistency. These constraints can be enforced at the logical level, independent of the physical implementation. By enforcing data integrity rules in the logical schema, the database can maintain consistent and reliable data even if the physical storage structures change. 4. Portability and Interoperability: A logical schema provides a standardized representation of the data that can be understood and shared across different database management systems (DBMS) or platforms. This portability and interoperability make it easier to migrate data between different systems or integrate data from multiple sources. 5. Query Optimization: The logical schema allows for the creation of high-level queries and provides the basis for query optimization. Query optimization involves selecting the most efficient execution plan for a query based on the logical schema's knowledge of the data organization and access patterns. By having a clear logical schema, the DBMS can optimize queries without being tied to the specific physical implementation. In summary, creating a logical schema offers numerous advantages, including data independence, simplified application development, improved data integrity, portability, and query optimization. By separating the logical representation of data from the physical implementation, databases become more flexible, maintainable, and adaptable to changes in technology and requirements.

hahaha