- 31
- 85 888
JCS IG & A-level Tutorials
Ghana
เข้าร่วมเมื่อ 21 ก.พ. 2017
IGCSE ICT Tutorials
Normalization Made Easy | AS/A-Level IT (9626) Worked Example
Are you struggling with normalization in AS/A-Level IT? In this video, we simplify the concept using a clearly worked example straight from the Cambridge A-Level IT (9626) support guide. Watch to master normalization step-by-step and gain the confidence to ace your exams! This video is perfect for students and educators looking to easily understand database design. Don't forget to like, subscribe, and share for more A-Level IT tips and tutorials!
This is the Excel used for the video.
docs.google.com/spreadsheets/d/1XeDzgHa1m1xyMSDaKvlK63JAoLJ_KLLJ/edit?usp=drive_web&ouid=108342724088277677850&rtpof=true
Use this link to understand functional dependency.
th-cam.com/video/6DgpETBt0vE/w-d-xo.html
Rules to Normalize under 5 minutes.
Achieve 1NF:
Remove duplicate rows and ensure every column contains atomic values.
Identify Functional Dependencies:
Analyze relationships between fields to determine which fields are dependent on others.
Decompose into New Tables:
Split fields with functional dependencies into separate tables, each with a unique primary key.
Create Relationships:
Link the original and new tables by adding foreign keys referencing the new primary keys.
Tables with only Foreign Keys must have their own primary Key.
This is the Excel used for the video.
docs.google.com/spreadsheets/d/1XeDzgHa1m1xyMSDaKvlK63JAoLJ_KLLJ/edit?usp=drive_web&ouid=108342724088277677850&rtpof=true
Use this link to understand functional dependency.
th-cam.com/video/6DgpETBt0vE/w-d-xo.html
Rules to Normalize under 5 minutes.
Achieve 1NF:
Remove duplicate rows and ensure every column contains atomic values.
Identify Functional Dependencies:
Analyze relationships between fields to determine which fields are dependent on others.
Decompose into New Tables:
Split fields with functional dependencies into separate tables, each with a unique primary key.
Create Relationships:
Link the original and new tables by adding foreign keys referencing the new primary keys.
Tables with only Foreign Keys must have their own primary Key.
มุมมอง: 259
วีดีโอ
Normalization Made Easy: AS/A-Level IT (9626) Simplified Using Functional Dependency!
มุมมอง 15721 ชั่วโมงที่ผ่านมา
In this video, we break down the concept of normalization into simple steps, making it as easy as A-B-C. Using functional dependency, we’ll demystify how normalization works and show you how to master it for your AS/A-Level IT exams. By the end of this video, you'll understand: The purpose of normalization. How to identify and use functional dependencies. The steps to move from 1NF to 2NF and b...
IGCSE-ICT: Chapter 7: System Life cycle
มุมมอง 1.4K7 หลายเดือนก่อน
No More Glitches! The System Life Cycle Explained. The stages in the system life cycle can be summarized with the acronym ADDIDE: A - Analysis D - Design D - Development I - Implementation D - Deployment and Testing E - Evaluation Link to the note drive.google.com/file/d/1L99tMV7qiho38oKF5CTw06I5ux4_D00H/view?usp=sharing Link to the quiz docs.google.com/forms/d/e/1FAIpQLSchG6ovGtxIOiz3dux8BCpN7...
IGCSE-ICT: Chapter 1: Types and Components of Computer Systems
มุมมอง 2.2K7 หลายเดือนก่อน
Master IGCSE ICT Theory in Minutes! This Video breaks down Chapter 1: Types and Components of Computer Systems into bite-sized chunks. Conquer your IGCSE exams with easy-to-understand summaries and ace your understanding of hardware, software, and everything in between. Subscribe for stress-free IGCSE ICT revision! To download the note use the link below ️ drive.google.com/file/d/1rXqiuo6rA-Pix...
Alignment of images to text, Paragraphing and Breaks in document production.
มุมมอง 88ปีที่แล้ว
In the IGCSE ICT exam, questions are asked about text wrapping and aligning images to margins. A common practice among students is to align images by eye without using a proper guide. Those errors can be corrected with the help of this video. Additionally, inserting paragraphs and breaking pages or columns can be misconstrued.
Vertical Bar Chart
มุมมอง 2.6K3 ปีที่แล้ว
Creating a vertical bar chart, using the scatter diagram as a first resort to getting your graph. The scatter plot is then changed to a vertical bar chart.
Producing Report (Feb -Mar, 2017 paper 2) Question 31
มุมมอง 1316 ปีที่แล้ว
Producing Report (Feb -Mar, 2017 paper 2) Question 31
Creating Forms (2017 Feb- Mar, Paper 2 ) and adding other form features.
มุมมอง 6116 ปีที่แล้ว
Creating Forms (2017 Feb- Mar, Paper 2 ) and adding other form features.
Producing Report (Feb_Mar, 2017 paper 21) Q 30
มุมมอง 1276 ปีที่แล้ว
Producing Report (Feb_Mar, 2017 paper 21) Q 30
Filtering
มุมมอง 1166 ปีที่แล้ว
docs.google.com/spreadsheets/d/1UkYhNEC17b4eUZJAJlJR6yWDiK_KECOOgN2_55oyMBs/edit?usp=sharing
Sorting
มุมมอง 996 ปีที่แล้ว
Make sure to select all the active sheet before, sorting, if not, your work will jumble up. File: docs.google.com/spreadsheets/d/1UkYhNEC17b4eUZJAJlJR6yWDiK_KECOOgN2_55oyMBs/edit?usp=sharing
Wildcard Search ( using ???, A*, *N , B???)
มุมมอง 3016 ปีที่แล้ว
Wildcard search is useful for sorting specific information from a list data in a spreadsheet. docs.google.com/spreadsheets/d/1UkYhNEC17b4eUZJAJlJR6yWDiK_KECOOgN2_55oyMBs/edit?usp=sharing
Importing .csv files ( avoiding errors by changing the date format)
มุมมอง 2K6 ปีที่แล้ว
Avoid importing .csv files with errors by changing the date format to the required format from the question.
linking tables ( creating relationship)
มุมมอง 2046 ปีที่แล้ว
linking tables ( creating relationship)
Importing two diiferent .csv files both with primary keys
มุมมอง 3796 ปีที่แล้ว
Importing two diiferent .csv files both with primary keys
creating reports using a relational database
มุมมอง 3406 ปีที่แล้ว
creating reports using a relational database
COUNT, COUNTA, COUNTIF, COUNTIF WITH THE NOT CRITERIA
มุมมอง 8537 ปีที่แล้ว
COUNT, COUNTA, COUNTIF, COUNTIF WITH THE NOT CRITERIA
Creating Forms in Access with Drop down list (COMBO BOX)
มุมมอง 48K7 ปีที่แล้ว
Creating Forms in Access with Drop down list (COMBO BOX)
Upload more videos of the rest of the chapters. IF possible give notes at least for now!!!! ??
Great guide for Normalization. Thanks Sir..
Let me have your take on the video and make sure to share Others must benefit
please make for all chapters please 🙏🏽 your chapter 1 and 7 videos were so helpful!
Thanks for the kind words. I'll try my best to get the rest of the chapters covered.
thanks🤗
Thank you for the excellent notes. Please kindly can you make notes for all the chapters. Please we need them. Thank you
I will make it available as soon as possible.
@babmathigcseicttutorial1706 pls give access to the drive notes link.🙏🙏
Can you make the other chapters pls
Hi pls this was very helpful. Can you pls do one on ICT application
Very helpful thanks
Its good to know. kindly spread the channel
Good job
Thank you sir
@babmathigcseicttutorial1706 Sorry, I made a mistake sir
Well presented
Thanks.
Kindly spread the channel
it's a very helpful video for last minute revision But can you go over the more demanding topics like system life cycle And the one with robots, augmented realit, etc, like examstyle questions regarding them
can you please do all the chapters? im kinda struggling and the paper is next week wednesday thanks xx
Very helpful
Glad to hear that
Hey BabMath, great. Now I know how to do it. But first, I need to know why and when I would want to do it.
This helped me with some IT work I was stuck on. Thank you very much!
Loved this video - very clear information and easy to follow. Thank You
i did this but from a table list, and its just showing the number of the choice picked..
nice babmath
Very professional teaching sir, thanks for sharing your valuable knowledge 🙏🙏
Nice
Sr, plz share this Excel File... usmaniqbal102@gmail.com
love the accent
thanks so much.... ps. im ur 100th subscriber
THANK YOU SO MUCH!! this helped me so much 💜💜🥰
When i import csv file to access , i have a bad name error . How to fix it ?
You selected 'Ghana' as the location value, but when reviewing the table, the record had 'Cornwall' for location. I'm having similar issues.
Wow. You have eyes for details. Thanks for notifying me. To rectify the situation, make use of the new record icon (forward arrow with *) at the bottom of the form and save your work. This should work!!
@@babmathigcseicttutorial1706 I'm sorry, I don't see either the new information added via the combo box to show in the table in Datasheet View. I don't understand your solution how do I rectify? I continued searching how to do this and this worked for me and the data correctly shows in the database as you choose from the dropdown menu, the function is a "Lookup Wizard" th-cam.com/video/H_qAOGQduO4/w-d-xo.html
The combo box should be linked with the column of the table from the form setting to reflect the value from form to table.
Thanks.
Trash BOi
use a logical function to find out if each customer is eligible for a daily deal (Y) or not (N), based on. (*Hint - use a nested if function) Monday 20% off total bill Tuesday Free dessert Wednesday Mains - Buy 1 Get 1 Thursday 10% off total bill Friday No deal Saturday No deal Sunday Free side order please help on this problem ...
Hi, i would like to ask for help on my formula. this is an example of my tabulation. Lets say I used column A1:A6. A1= today() A2= 25-jun-18 A3= 2-jul-18 A4= 9-jul-18 A5= 16-jul-18 A6= 23-jul-18 Suppose i will be using A7 to write my formula. I have three schedules to rotate every week; 6am, 2pm, 10pm and i wrote it this way but didn't work why?: =if(A1>=A2,"6AM",IF(A1>=A3,"2PM",IF(A1>=A4,"10PM","")))
Great, thank you
Thanks man
lol u naked.
thankyou so much
Great tutorial with illustrations.Guys, I highly recommend this video to y'all.
Good video, is there any other software suggestion to change / reduce color depth of image besides Photoshop?
Thanks for the comment. well unfortunately I haven't come across one yet. Will let you know when I chance on one.
thank you so much
This was wonderful and informative. It helped so much
Helped me pass my exams!
thank you! this was amazing
Is that Mr Mathias speaking
Joshua are you there
comment frend 1
i cant find your comment
I really appreciate these videos, thanks.
BECKFAST!
I love this video frend 1 when is the next steven universe
hey joshua when is the next steveen universe
akua we get it your internet works
Dana, joshua, akua and sebastian I cant reach you
This was very insightful. Keep up the good work!