mcs 012 solved assignment

• privacy policy
• Terms and Conditions
• Refund policy
• +918504059601

• Study Materials
• _IGNOU BA/BDP
• Student Zone
• _HALL TICKETS
• _GRADE CARD
• _IGNOU ADMISSION
• _EXAM DATE-SHEET
• GUESS PAPERS
• SOLVED ASSIGNMENTS
• _NEW ASSIGNMENTS
• HANDWRITTEN ASSIGNMENT
• _MCA Handwritten copy
• _BCA Handwritten copy

Friday, September 8, 2023

Ignou mcs-012 solved assignment for 2023-24 session, ignou mcs-012 solved assignment for 2023-24 session students could simply realize their assignment topics by clicking on the official link of ignou. all-important links are shared on the online panel. this is the space university which is why students square measure required to create their assignments at their home. if you're feeling any doubt, then ask from us by below comment box ignou bca/mca  free solved assignment for 2023-24 session ignou bca/mca  mcs-012 2nd  semester solved assignments 2023-24 mcs-012   computer organization and assembly language programming   download ignou  bca  solved all free  assignment  for 2023-24 session the important guidelines to write the assignment answers is mentioned in the programme guide or assignment booklet. have you not applied for  ignou admission  for distance learning yet do, it now to save your money and time it should be noted that the ignou  mcs-012   assignment 2023-24 session solution provided here are just for reference to help in making the assignments.   ignou bca mcs-012  computer organization and assembly language programming workplace  course is related to english, therefore, the assignment is available in english medium only. are you also looking for  ignou mcs-012  solved assignment  as well students have to solve all the mandatory questions mentioned in the tutor marked assignment mcs-012  course. students who have taken admission in july 2022, they can submit this assignment to appear in june 2023 examination. so, the students should try to write the assignments in their own words. while asking for solved assignments through email, do not forget to mention the course code, course name, student name, enrollment number, address, etc. the ignou  mcs-012   assignment 2023-24 sessionis valid for july 2022 and january 2023 admission cycle.   the assignment is valid for december 2022 examination for the students who have registered them in january 2023 session.   ignou bca/mca  mcs-012 2nd semester solved assignments 2022-23     2nd semester solved assignment/questions paper download (mcs021 solved assignments download 2023-24 session pdf downloads,mcs022 solved assignments download 2023-24 session pdf downloads mcs053 solved assignments download 2023-24 session pdf downloads, mcse011 solved assignments download 2023-24 session pdf downloads, mcse003 solved assignments download 2023-24 session pdf downloads,mcse004 solved assignments download 2023-24 session pdf downloads,mcsl054 solved assignments download 2023-24 session pdf downloads) assignments/questions paper download has been added. july 2022 and january 2021 session.2023-24 session pdf downloads ignou help master ignou solved assignment. mca ignou july-january 2023-24 session pdf downloads assignment solution free download   ignou bca 1st semester solved assignments 2023-24 session pdf downloads session download, ignou bca 2nd semester solved assignments 2023-24 session pdf downloads session download, ignou bca 3rd semester solved assignments 2023-24 session pdf downloads session download, ignou bca 4th semester solved assignments 2023-24 session pdf downloads session download, bcs052 solved assignment download 2023-24 session pdf downloads session, bcs053 solved assignment download 2023-24 session pdf downloads session, bcs054 solved assignment download 2023-24 session pdf downloads session, solved assignments and solved term-end exam questions paper free download. ignou help master ignou solved assignments.new latest solved assignment download. bca ignou july-january 2023-24 session pdf downloads session assignment solution free download 2023-24 session pdf downloads session, mcs024 solved assignment download 2023-24 session pdf downloads session, bcsl043 solved assignment download 2023-24 session pdf downloads session, bcsl044 solved assignment download 2023-24 session pdf downloads session, bcsl045 solved assignment download 2023-24 session pdf downloads session, mcsl016 solved assignment download 2023-24 session pdf downloads session, bcs051 solved assignment download 2023-24 session pdf downloads session,  ignou bca 6th semester solved assignments 2023-24 session pdf downloads session download free download/paper free download 2023-24 session pdf downloads session,2023-24 session pdf downloads,2022-23.    ,mcs023 solved assignments download 2023-24 session pdf downloads,mcs024 solved assignments download 2020- 21,mcsl-025 solved assignments download 2023-24 session pdf downloads)3rd semester solved assignment/questions paper download (mcs031 solved assignments download 2023-24 session pdf downloads,mcs032 solved assignments download 2020- 21,mcs033 solved assignments download 2023-24 session pdf downloads,mcs034 solved assignments download 2023-24 session pdf downloads,mcs035 solved assignments download 2023-24 session pdf downloads,mcsl036 solved assignments download 2023-24 session pdf downloads) ignou bca/mca  mcs-012 2nd semester solved assignments 2022-23   4th semester solved assignment/questions paper download (mcs041 solved assignments download 2023-24 session pdf downloads,mcs042 solved assignments download 2023-24 session pdf downloads,mcs043 solved assignments download 2023-24 session pdf downloads,mcs044 solved assignments download 2020- 21,mcsl045 solved assignments download 2023-24 session pdf downloads) 5th semester solved assignment/questions paper download (mcs051 solved assignments download 2023-24 session pdf downloads, mcs052 solved assignments download 2023-24 session pdf downloads, ignou bca/mca  mcs-012 2nd semester solved assignments 2022-23   ignou mca 1st semester solved assignments 2023-24 session pdf downloads download, ignou mca 2nd semester solved assignments 2020- 21 download, ignou mca 3rd semester solved assignments 2023-24 session pdf downloads download,ignou mca 4th semester solved assignments 2023-24 session pdf downloads download, ignou mca 5th semester solved assignments 2023-24 session pdf downloads ignou bca/mca  mcs-012 2nd semester solved assignments 2022-23   download,ignou mca 6th semester solved assignments 2023-24 session pdf downloads download/paper free download. ignou mca/bca 1st,2nd,3rd,4th,5th semester solved assignments 2019-20,2023-24 session pdf downloads,2023-24 session pdf downloads,2023-24 sessiondownload and solved questions paper,solved term-end exam questions paper download. fully solved 1st semester solved assignment/questions paper (mcs011 solved assignments download 2023-24 session pdf downloads,mcs012 solved assignments download 2023-24 session pdf downloads,mcs013 solved assignments download 2020- 21,mcs014 solved assignments download 2023-24 session pdf downloads,mcs015 solved assignments download 2023-24 session pdf downloads,mcsl016 solved assignments download 2023-24 session pdf downloads,mcsl017 solved assignments download 2023-24 session pdf downloads).  ,   ignou bca/mca  mcs-012 2nd  semester solved assignments 2023-24 how to download ignou mca/bca solved assignment   1.         send your subject code / enter your assignment code . 2.        click on assignments codes types /screen shoot . 3.        enter your right subjects code. 4.        click on “sent ”. 5.         select (all payments methods available) 6.        success your transaction than check your whats app  automatically download 7.        download the assignment., ignou more assignments b.a/bdp/bag/bca/mca/pgdca/mba  also avilable, below  ignou programmes select ignou all solved  assignments click here ignou bca solved assignments click here ignou mca solved assignments click here ignou bag/bdp/ba solved assignments click here ignou pgdca   solved assignments click here ignou mba  solved assignments click here ignou other assignments click here ignou mca/mca new handwriting pdf available 2023-24  whats app:-+918504059601 ignou solved assignments 2023-24  bag mca bca pgdca mba ba/bdp b.com m.com m.a, below  ignou programmes select ignou all solved  assignments click here ignou bca solved assignments click here ignou mca solved assignments click here ignou bag/bdp/ba solved assignments click here ignou pgdca   solved assignments click here ignou mba  solved assignments click here ignou other assignments click here solutions available call/whats app-+918504059601 thanks&regard ignou help master team mobile number: +918504059601 email:- ignouhelpmaster @gmail.com all-important links are going to be shared on the online panel. this is the gap university which is why students square measure required to create their assignments at their home. if you're feeling any doubt, then raise from north american nation by below comment box, no comments:, post a comment, ignou exam help notes.

• IGNOU BAG Notes/guess Paper
• IGNOU MBA Exam Notes

IGNOU LATEST NEWS

• BCA Solved assignment 2024Session Click Here

• IGNOU M.A solved assignment2024 Session Click Here
• IGNOU BAG solved assignment 2024 Session Click Here
• MBA solved assignment 2024 Session Click Here

IGNOU SOLVED ASSIGNMENTS

• IGNOU PDF Assignments
• IGNOU Handwriting Assignments
• IGNOU Hard Copy Home delivery Assignments
• IGNOU Projects + synopsis

Popular Posts

• IGNOU New Students Whats App Groups new Students IGNOU All Students Whats App  Free Links Join .  The solve ignou students problem below, you get a list of active IGNOU Whats App groups cr...
• IGNOU BA/BAG Solved Assignment January-2024 Session Free IGNOU BA/BAG (NEW) Solved Assignment For July- 2024-25 Session: If you were searching for the IGNOU  BA/BAG Semester Solved Assignment for J...
• IGNOU BAM Solved Assignment Download For 2024 session IGNOUBAM (NEW) Solved Assignment For  July/January- 2024 Session : If you were searching for the IGNOU  BA/BAM Semester Solved Assignment fo...
• IGNOU BAG Solved assignment July-2023 Session And January-2024 Session IGNOU  BAG  Solved Assignment  For  2023-24 Session :  If you were finding out the IGNOU  BAG  Semester solved Assignment for July-2023/Janu...

Breaking News

Fully Solved Assignments

SUPPORT STUDENTS

Blog archive.

 IGNOU HELP MASTER

 RAJASTHAN JHUNJHUNU-333029  Email id: ignouhelpmaster @gmail.com  WhatsApp us: +918504059601

IGNOUHelp.in

A Leading Portal for IGNOU Students

IGNOU MCS-012 Study Material

IGNOU MCS-012 Study Materials/Books – If you come to this page for download each course of MCS-012 Study Material so you are come at right place. Here you will get everything for which you have come to here. We have downloaded all available Study Materials of MCS-012 to our System and it is ready and available for all MCS-012 Students.

We provide all study materials to IGNOU Computer Application student with free of cost and it can download easily and without registration need.

List of Available MCS-012 Study Materials:

Is it required to download MCS-012 Materials?

For attend IGNOU MCS-012 TEE Examination, it is necessary to first submit your Assignments to IGNOU and it is possible from IGNOU Study Material . You can solve your MCS-012 Assignments with using Books/Materials. Not only Assignments, but you can use it for preparation of Examination and you can get good marks in your Computer Application Programme Annual Exams with good grade.

Related Posts:

• IGNOU MCSL-17 Study Material
• IGNOU BCS-31 Study Material
• IGNOU MCS-011 Study Material
• IGNOU BCSL-56 Study Material
• IGNOU BCS-42 Study Material
• IGNOU PGDCA Study Material

8 thoughts on “IGNOU MCS-012 Study Material”

Please send me pdf material with diagrams

plz send me pdf material mca ebooks hindi and english

how to get old question papers solved.

plz send me PDF material

Pdf doesn’t show any diagram please fix this issue as soon as possible 🙏

in this material figure is not showing…

Have you received textbook with figures? Unbelievable carelessness from textbook makers!

Yes in my physical book there are diagrams, LOTS OF THEM

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

• IGNOU CBCS BAG SOLVED ASSIGNMENT 2023-2024
• IGNOU CBCS BCOM(G) SOLVED ASSIGNMENT 2023-2024
• IGNOU CBCS BSC(G) SOLVED ASSIGNMENT 2022-2023
• IGNOU BA Hindi (BAHDH) SOLVED ASSIGNMENT
• IGNOU B.A English SOLVED ASSIGNMENT
• IGNOU B.A Sociology SOLVED ASSIGNMENT
• IGNOU B.A History SOLVED ASSIGNMENT
• IGNOU B.A Psychology SOLVED ASSIGNMENT
• IGNOU B.A Public Administration SOLVED ASSIGNMENT
• IGNOU B.A Political Science SOLVED ASSIGNMENT
• IGNOU BAECH (Economics) SOLVED ASSIGNMENT
• IGNOU B.A Philosophy SOLVED ASSIGNMENT
• IGNOU M.A Hindi SOLVED ASSIGNMENT
• IGNOU M.A English SOLVED ASSIGNMENT
• IGNOU M.A History SOLVED ASSIGNMENT
• IGNOU M.A Sociology SOLVED ASSIGNMENT
• IGNOU M.A Public Administration SOLVED ASSIGNMENT
• IGNOU M.A Political Science SOLVED ASSIGNMENT
• IGNOU M.A Psychology SOLVED ASSIGNMENT
• IGNOU M.A Economics SOLVED ASSIGNMENT
• IGNOU M.A RURAL DEVELOPMENT SOLVED ASSIGNMENT
• BCA 1st Semester
• BCA 2nd Semester
• BCA 3rd Semester
• BCA 4th Semester
• BCA 5th Semester
• BCA Question Papers
• Study Material
• Whatsapp Group
• RESULT TERM-END
• +919811854308

MCS-012 Computer Organization and Assembly Language Programming Previous Year Question Papers

Ignou all previous year question  papers  in one pdf.

एक PDF में पिछले वर्ष के सभी प्रश्‍न पत्र

Download Now

The Advantages of studying IGNOU Solved Assignments are given below:

• Easy Accessibility: IGNOU solved assignments are easily accessible online, which means students can access them anytime and anywhere.
• Comprehensive Solutions: The solved assignments provide comprehensive answers to the questions asked in the assignments, which makes it easier for students to understand and study the topics.
• Cost-Effective: The solved assignments are available at a very economical rate, which makes them a great option for those who are on a budget.
• Reference Material: The solved assignments can be used as reference material for further study, as they provide detailed answers to the questions asked.
• Time-Saving: The solved assignments save a lot of time for students as they do not need to spend time researching and writing the answers themselves.

Can I score good marks by getting solved assignments?

Yes, you can get good marks by getting the Solved Assignment as it contains the answers to the questions asked in the assignment and will help you to understand the concepts better and score better.

Read more: How to Make IGNOU Solved Assignment? 

RELATED ARTICLES MORE FROM AUTHOR

Bsw-131 समाज कल्याण प्रशासन और सामाजिक कार्य in hindi previous year question papers, bsw-131 social welfare administration and social action in english previous year question papers, bsw-130 मादक द्रव्यों के सेवन की रोकथाम in hindi previous year question papers, leave a reply cancel reply.

Save my name, email, and website in this browser for the next time I comment.

• Terms & Condition
• Privacy Policy
• Refund & Cancellation
• Paid Solved Assignment

IGNOU MCS-012 Computer Organization and Assembly Language Programming Question Paper Download

Are you trying to prepare for your IGNOU BCA MCS-012 Computer Organization and Assembly Language Programming exams but struggling to find the right resources? Look no further! In this article, we’ll provide you with a step-by-step guide on how to download IGNOU MCS-012 Computer Organization and Assembly Language Programming Question Paper and sample papers easily. Read on to learn more about where to find these resources and how you can use them to effectively prepare for your upcoming exams.

Introduction to IGNOU BCA MCS12

IGNOU BCA or Bachelor of Computer Applications is a three-year undergraduate course offered by the Indira Gandhi National Open University. The course has been designed to provide students with a strong foundation in computer applications.

The following steps will help you download IGNOU BCA MCS-012 question papers and sample papers easily:

• Visit the official website of IGNOU at www.ignou.ac.in.
• On the homepage, click on the ‘Student Zone’ tab and then select ‘Downloads’ from the drop-down menu.
• Now, under the ‘Question Papers’ section, select your programme i.e., ‘BCA’ and then choose your desired year and semester.
• Finally, click on the ‘Submit’ button to download the question paper or sample paper.

Benefits of Downloading IGNOU MCS-012 Solved Question Paper

There are many benefits of downloading MCS-012 Computer Organization and Assembly Language Programming question papers and sample papers from the internet.

• Firstly, it saves a lot of time as you do not have to go through the entire syllabus to find the relevant topics.
• Secondly, you can get an idea about the pattern of questions asked in the examination by solving these papers.
• Thirdly, it helps in building up confidence as you know what to expect in the examination.
• Finally, it provides an opportunity to revise the concepts before appearing for the actual examination.

Download Last 5 Year’s Question Paper on  MCS-012 

Where to Find the Official IGNOU BCA Question Paper in PDF

The official IGNOU MCS-012 Computer Organization and Assembly Language Programming Previous question papers and sample papers can be found on the university website. However, these are not always easy to find. Here is a quick guide on how to download them:

• Go to the IGNOU website (ignou.ac.in) and click on the ‘Student Zone’ tab at the top of the page.
• On the next page, scroll down to the ‘Examination’ section and click on the ‘Downloads’ link.
• On the downloads page, scroll down to the ‘BCA’ section and click on the ‘Question Papers’ link.
• This will take you to a page with all of the available BCA question papers. You can either download them individually or as a ZIP file.

How to Download IGNOU MCS-012 Computer Organization and Assembly Language Programming Question Paper and Sample Papers

If you are looking for IGNOU BCA Question Papers and Sample Papers, then this article will help you. Here we will provide you detailed information on how to download these papers easily.

• IGNOU MCS-012 Computer Organization and Assembly Language Programming Question Paper and Sample Papers can be downloaded from the official website of IGNOU.
• To download the papers, firstly visit the website and then click on the ‘Student Zone’ tab given at the top of the page.
• After that, select ‘Question Papers’ from the drop-down menu. Now, a list of all available question papers and sample papers will be displayed on your screen.
• You can either select the paper you want to download or can search for it by using the provided search box.
• Once you have found the paper, click on the ‘Download’ button given next to it. The paper will now start downloading automatically.
• You can also take a printout of the downloaded paper for future reference.

Tips for Preparing for IGNOU BCA MCS-012 Exams

It is always better to be prepared for exams in advance and IGNOU BCA Exams are no different. Here are some tips that will help you prepare for your exams:

• परीक्षा पैटर्न और पाठ्यक्रम समाधान: हर परीक्षा के लिए तैयार होना का पहला चरण परीक्षा पैटर्न और पाठ्यक्रम समझ है। जब आपको पता चलता है कि परीक्षा में कौनसे टॉपिक कवर होंगे, तो आप उसके हिसाब से तैयार शुरू कर सकते हैं।
• स्टडी मटेरियल कलेक्ट करना: अब आपको स्टडी मटेरियल कलेक्ट करना है जो आपको एग्जाम के लिए तैयार करने में मदद करें। ऑनलाइन और ऑफलाइन डोनो जगह ढेर सारी किताबें और संसाधन उपलब्ध हैं जो आपके लिए तैयारी के लिए मददगार हो सकती है।
• मॉक टेस्ट अभ्यास करना: और एक महत्वपूर्ण टिप है मॉक टेस्ट अभ्यास करना, वास्तविक परीक्षा के पहले। ये आपको पता चलता है कि परीक्षा में कौनसे टाइप के प्रश्न पूछे जाएंगे और आपको आत्मविश्वास भी बढ़ाता है। ऑनलाइन बहुत सारे सैंपल पेपर और पिछले साल के प्रश्न पत्र उपलब्ध हैं जो आप इस उद्देश्य के लिए उपयोग कर सकते हैं।

Follow these tips and you will surely be able to crack IGNOU BCA Exams with flying colours!

Downloading the IGNOU MCS-012 Computer Organization and Assembly Language Programming Question Paper in PDF and MCS-012 sample papers is not a difficult task as long as you know the right steps and resources. We have provided detailed instructions on how to do this so that you can easily find the correct material for your studies.

Leave a Comment Cancel reply

Save my name, email, and website in this browser for the next time I comment.

IGNOU MCS-012 Study Material & Textbook Download

If you are looking for MCS-012 IGNOU Study Material or Textbook entitled Computer Organization and Assembly Language Programming you have come to the right place. This is because eGyankosh allows you to download single units at a time but we provide you with the fully combined pdf with all blocks and units. Click on the image or the button below to download the study material for free! We have also provided you with an option to get verified and easy to understand guide books from Gyaniversity Publications which contain answers to previous year questions, predicted list of most important questions for upcoming term end exams, paper pattern, etc. The books are applicable for the following course(s) in IGNOU: Bachelor of Computer Applications (BCA)

MCS-012: Computer Organization and Assembly Language Programming

IGNOU Study Guide Book

IGNOU Textbook

MCS-012 Guidebook v/s Textbook

IGNOU textbook for MCS-012: Computer Organization and Assembly Language Programming is freely available to all students. However, it is very long, confusing and hard to understand. If you are a busy working professional looking to pass your exams easily, we suggest you to go for Guidebooks made by Gyaniversity Publications instead as they are prepared using historical data from previous 20 question papers. They provide you with accurate list of the important questions are most likely to appear in your upcoming exams along with proof points based on previous year exam questions. The answers are written in simple English too. This helps you pass your exams easily!

100% Verified solved assignments from ₹ 40  written in our own words so that you get the best marks!

Don't have time to write your assignment neatly? Get it written by experts and get free home delivery

Get Guidebooks and Help books to pass your exams easily. Get home delivery or download instantly!

Download IGNOU's official study material combined into a single PDF file absolutely free!

Download latest Assignment Question Papers for free in PDF format at the click of a button!

Download Previous year Question Papers for reference and Exam Preparation for free!

Need More Help?

To get additional help, please post your question in our student community forum. Our IGNOU Advisors will respond to you within 48 hours.

IGNOU MCS-012 SOLVED ASSIGNMENT 2023-24

₹ 60.00 ₹ 30.00

• Description

IGNOU MCS-012 SOLVED ASSIGNMENT 2023-24 ENGLISH MEDIUM

Click on the link for more information., visit my website :, kunjpublication.com, ignousolvedassignment.org, any query plz call and whatsapp: 8006184581, note:  ignou handwritten solved assignment, related products.

IGNOU BCSL-043 SOLVED ASSIGNMENT 2023-24

IGNOU BCSL-045 SOLVED ASSIGNMENT 2023-24

IGNOU ECO-01 SOLVED ASSIGNMENT 2023-24

IGNOU BCS-040 SOLVED ASSIGNMENT 2023-24

WhatsApp us

Ready to build? Don’t miss our free ebook: The Ultimate Guide to Building a House

636-462-3500 | CONTACT SALES

Ready to Love Your Home? Invest in a New Construction Semi-Custom Home Built Just for You

There’s no place like home, especially when it’s built just for you! CMS Homes in Troy, MO, builds semi-custom houses in an easy turnkey process that will get you into your new home quickly. Contact sales to learn more or schedule a no-obligation conversation with one of our attentive and experienced specialists. We’ll guide you through the home-building process, starting with your wish list and budget, and provide a free comprehensive estimate to take home.

Why Choose to Build with CMS Homes?

We value integrity and complete transparency, no pressure, detailed estimates, fair pricing, financing: proprietary easy build program, job-site attention and project management by company owners, open communication and complete accountability.

CMS Homes Communities

Can I Build a Home Anywhere with CMS Homes?

If you want to build a new home on your land or already have home plans but aren’t sure where to build, the CMS Build Anywhere Program lets you build a home literally anywhere within 30-35 miles of Lincoln County, MO. Using your home plans or one of our home plans customized to your wishes, we will build:

• On your lot within 30-35 miles of Lincoln County, including St. Charles and Warren Counties.
• On one of our parcels for sale in one of our communities.
• Or we will help you find land.

No matter where you build, we offer a stress-free building process you can count on, full transparency and communication, and superior craftsmanship.

Visit our Sales Office

Orchard Grove Display Homes 602 Schapers Court Moscow Mills, MO 63362

636-462-3500

Testimonials

Austin Oaks Estates Homeowner

Park Hills Homeowner

Contact Us About Our New Home Communities in Troy, Missouri

Now is the time to build your dream home in a community you love, at a competitive price, and move in within six months. When you build with CMS Homes, you get everything under one roof with one team caring for you and your home-build project. No other builder offers the number of standard features and the level of customization we offer — we want your home to be exactly what you need and want. Contact sales today for a no-pressure, no-obligation conversation and walk away with a free, comprehensive estimate.

Our Latest News & Insights

30 great cleaning tips for your new home.

Cleaning & Organizing Tips for Your New Home Have you been in your new home for three or more...

I Want to Build a House On My Land, Where Do I Start?

You’ve decided it’s time to build a house on your land. Now you’re wondering, where do I start?...

CMS Homes: An Interview with Our Closing Coordinator, Emily Wilson

Building your dream home can be an exciting and rewarding experience when you choose a...

Should I Buy a New Home When Interest Rates Are Going Up?

At CMS Homes and Guild Mortgage, we hear this question frequently, “Should I buy a new home while...

New Home Loans

What Not to Do When in the Process of Getting a New Home Loan Before your new home is built, one...

Meet Travis

Meet Travis Hear from Travis one of our 4 Project Managers. Travis grew up around home building...

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications

1. create a database called 'assignment' (Note please do the assignment tasks in this database)

MoinDalvs/EXCELR_Data_Analyst_SQL_Assignment_Part1

Folders and files, repository files navigation, excelr_data_analyst_sql_assignment_part1, download link for sql database, 2. create the tables from consolidatedtables.sql and enter the records as specified in it..

use assignment;

3. Create a table called countries with the following columns

-- name, population, capital -- choose appropriate datatypes for the columns

-- a) Insert the following data into the table

-- b) Add a couple of countries of your choice

-- c) Change ‘Delhi' to ‘New Delhi'

4. Rename the table countries to big_countries

Rename table countries to big_countries;

5. Create the following tables. Use auto increment wherever applicable

-- a. Product -- product_id - primary key -- product_name - cannot be null and only unique values are allowed -- description -- supplier_id - foreign key of supplier table

6. Enter some records into the three tables.

7. modify the supplier table to make supplier name unique and not null., 8. modify the emp table as follows.

-- a. Add a column called deptno

-- b. Set the value of deptno in the following order

-- deptno = 20 where emp_id is divisible by 2 -- deptno = 30 where emp_id is divisible by 3 -- deptno = 40 where emp_id is divisible by 4 -- deptno = 50 where emp_id is divisible by 5 -- deptno = 10 for the remaining records.

9. Create a unique index on the emp_id column.

10. create a view called emp_sal on the emp table by selecting the following fields in the order of highest salary to the lowest salary..

-- emp_no, first_name, last_name, salary