Andrian Christian Paul Gadin

BSEMC2B

ACTIVITY TASK MODULE 3 INFMNGT LECTURE


1. what are the basic sql expression? 

        a sql query is an expression that defines the set of data to be retrieved from the database
2. what is the difference between simple equijoin and natural join? 
        an equi join matches rows where values in both tables are equal. in a natural join,                     however, data is matched based on column names that are common between tables.
3. what are the different types of join? 
        there are four main types of joins in sql:

    • inner join
    • outer join
    • cross join
    • self join. 

4. what are the different components of sql structure? 
there are four different components of sql structure:

  • the data manipulation language (dml)
  • the data definition language (ddl)
  • the data control language (dcl).

5. what is the different between write and fetch transaction?

it is the transactions of the organization and has data that is captured. master data is refers to different transactions. examples are customer, product, or supplier data. 

meanwhile fetch transactions are used to transfer data from EBICS gateway to the customer. the order types required for the operation of EBICS are set up after the installation. the order types can be different for each bank and will be created according to the requirements.


C. 

1. where clause

2. tables

3. database management system

4. structured query language 

5.  Select


Comments

Post a Comment

Popular posts from this blog

Title: From Plan to Global: Building a Business That Works

Image
Case Analysis by Andrian Christian Paul Gadin INTRODUCTION In today’s fast-paced digital world, having a solid plan is key to business success. But with so many terms flying around— digital marketing plans , action plans , business model canvas , and even global strategy —it can get a little overwhelming. Don’t worry! In this blog post, I’ll break them down in a simple and relatable way.  A. What is a Digital Marketing Plan ? A Digital Marketing Plan is like a GPS for promoting your business online. It outlines how you'll use digital tools—like social media, search engines, emails, and websites—to reach your audience and grow your brand. Example: Imagine you’re opening a coffee shop. Your digital marketing plan might include creating a Facebook page, running Instagram ads, and sending out a monthly email newsletter with special offers. Key elements include: Goals (like increasing website visits or sales) Target audience Platforms to use (Facebook, Google, etc.) Bud...
Read more

ONLINE PORTFOLIO

Image
WELCOME TO MY ONLINE PORTFOLIO Welcome to My Creative Space! Hello! I am Andrian Christian Paul Gadin, a passionate and dedicated Multimedia Artist with a keen eye for creativity and a drive for excellence. specialize in creating stunning and impactful designs/artworks that bring ideas to life. Explore my portfolio to see how my skills, education, and artistic vision align with your needs! About Me I am a 3D Designer with a deep appreciation for digital artistry and immersive environments. My journey started with a passion for visual storytelling, which led me to pursue BSEMC at GORDON COLLEGE. Throughout my career, I have worked on numerous projects, collaborating with clients and brands to develop unique and compelling 3D designs and animations. Skills: Graphic Design (Adobe Photoshop, Illustrator, InDesign) Digital Illustration & Painting Branding & Visual Identity UI/UX Design 3D Modeling & Texturing (Blender) Rendering & Lighting Animation & Motion Graphics Vid...
Read more

GADIN - CASE ANALYSIS

  Andrian Christian Paul Gadin BSEMC 3B CASE ANALYSIS INTRODUCTION The case focuses on a leading UK supermarket chain that expanded into offering financial services through a white-label agreement. Despite their strong presence in the grocery market, the supermarket faced challenges in converting website visitors into customers for these financial products. The main issue was the difficulty of integrating financial services into their primarily grocery-focused website, which led to a poor user experience and low conversion rates. SUMMARY The case revolves around a well-established UK supermarket chain that ventured into offering financial services through a white-label agreement. However, the supermarket faced difficulties converting visitors into customers for these financial products due to the challenge of integrating them into their grocery-focused website. The user experience was hampered by unclear navigation, confusing form fields, and insufficient error signposting, which r...
Read more