CS405 Assignment 1 Solution Spring 2026 | CS405 Assignment 1 Solution 2026 | KST Learning

Bismillahirrahmanirrahim.

Assalamu Alaikum Wa Rahmatullah Wa Barakatahu.

Hope you all are well friends

In today's video, we

CS 405 Assignment Number One Spring

We will solve it completely in 2026.

The due date is April 30 and its total

Marks are 20. Friends, this assignment which

You have not submitted it in any file.

Get it done but yes if you have to go there

When you get the option to submit the file, then

You have to submit MS Word file.

Basically there are two pictures inside it.

You have saved both the screenshots in MS Word.

Paste and submit the MS Word file

But if you get there like this

I got the interface of, that is, when you go to LMS

When you start submitting assignments, if you

You will get an interface like this: Submit Assignment

to do, then how do you submit

That is, here inside this interface you will get

This way you get a picture option.

Click on this picture here.

After clicking you simply made your first

The picture that will be of question number one

and then in the second

You have to paste the picture. And then simply

Click Save and submit the assignment.

I have to get it done. Okay? So there's a better chance.

That this assignment is in some file

You don't have to submit in instead you have to submit inline

session. Meaning in which you will get this kind of

An editor will be available on top of the LMS which

You don't have an editor like MS Word

that you insert the picture there yourself

Basically, the interface is everything you need.

You'll find it on top of the LMS. So, you'll find a

You will get the picture option. You can do that through it.

Upload and save both your pictures.

Do you understand? Now, friends, this assignment is complete.

There are basically two questions inside it. First

In the question, basically you have ARD entity

A relationship diagram has to be drawn.

Embed screenshots on your LMS

Have to submit it. And for the second question

Inside you have basically covered SQL Workshop.

Inside, through SQL commands, which work

Space has to be created and then given

His Select Curie is simple.

You have to take a screenshot and paste it.

on your LMS. Got it? So here are two

You have work to do. So if you do this

If you want to get the assignment done from us on paid basis then due

If you contact before the date then this

The assignment fee will be small. However, if

If you contact on the due date

this assignment because this assignment is a little

length. So your contribution to this assignment is

If the contact is not received on the due date

If you do, the fees will double.

Try this video below.

In the description I will tell you my jo

I'll give you my number too.

I'll also give you the members' numbers. You can also ask me

You can contact me or my team member

You can also contact us and for that you

Get the paid service done and book it.

You can do it yourself. Is it okay? Then try it.

Make your bookings before the due date.

Let us first solve the ERD.

Yes. Question number one. Question number one

Friends, you have to create this ERD.

This is an ERD in which you have

The restaurant is the entity, the customer is the entity,

Menu is the menu item entity, Order

entity followed by the order detail entity

And then there's this restaurant

The attributes are restaurant ID, name,

Location. The three attributes of a menu item

Item ID, Price, and Restaurant

ID. Okay? Then order whatever you have.

There are two attributes here: an order ID.

and a customer ID. A customer has three

The attributes are customer ID, name, and

Address. And then order details here.

but is being used as a junction table

which is linked to the menu item as well and

Same with the Adder Order entity. Okay? And

There are three attributes inside it: order

ID, Item ID, and Quantity.

Friends, your question is basically number one.

There's a solution. This is basically question number one.

This is the picture which you have basically on LMS

Question number one has to be submitted

As a picture. Now how to make it?

This is the solution, right? Now you can pause the video.

Do this and the whole diagram is

Draw. Now what do you need to do to draw?

Have you? I'm sorry to tell you about LMS.

In the description below the video

I'll give you a link to this tool. Draw.iio

To create EID of question number one

This tool is to be used like Draw.Pay

You will come to the draw, right? Here you will find this.

The journal will open like this. You have selected the general.

to close. After closing the journal

Here you will get an option Entity

Relationship. Your relationship has to come into this.

What do you need after coming into this?

You need this entity first, sir. Then

You need this attribute shape. After that

You need a one to many relationship.

Okay? And then this, this, this, underneath it

This is a straight line, basically primary

And below that, there is a dirt line.

Basically, we have a foreign key. Okay?

Now let's go and see it. First of all

You need this entity, so this is the entity friends.

Look, there's this entity here. This entity

Grab it and put it on like this. Okay? And

What do you do after that?

Make a duplicate of this. Five such

We need to create an entity. So here's an entity here.

We placed it. We placed an entity here.

We placed an entity here, at this location. And

We placed an entity here at this place.

That's fine. Adjust this a little bit.

Let's adjust this a little bit.

Let's adjust this a little bit.

Let's take it. And adjust this a little bit.

Let's take it. This is how you have to make it.

assignment. Okay? Here are the entities.

What do you need now? Their attributes

So look here for the attribute.

This is the primary key attribute

Below which it is written that attribute.

And this is your simple attribute.

Your foreign key is an attribute whose

The attribute of V is written below.

What you need to know about this entity here

Need a primary for this entity?

Two simple attributes are needed.

For this a simple primary key

The attribute is a foreign key. Okay? The rest is up to you.

See for yourself. Okay? I told you.

Which thing comes from where? It's yours.

This is the primary key attribute. Look at this

This one with the straight line underneath it. This is your

It is a simple attribute below which there is no

There's no line. And this is your foreign key.

attribute with a dotted line under it

It's done. Okay? So learn how to create attributes.

Now how do I link them?

This straight line is used.

Straight line. You have to hold it like this.

You have to catch it and link it with it like this.

After that, hold it and link it like this

Please provide the rest of the links yourself. Okay?

I have told you the main concept.

So what's the last thing you want after that?

This relationship is one to many.

This is a relationship, how will it be restored?

Come back and see this here.

You will get this, this is one mandatory to many

Optional second last line of second last

There is an option above this one, okay, this

Hold it, hold it and lift it up.

I have turned it up, I have to turn it down.

holding it down and mixing it with it like this

Now you have to correct it, to correct it you

Click on this arrow to click

After this you will get an option above

ah way points click on this and this is what

There is the first option, click on it.

So look at this, whatever you have, it's absolutely fine.

That's it. Just click on this arrow and

Duplicate it with Control D.

After duplicating, grab it and do it like this

Put it here. This point here

and hold this point here

Apply it. Similarly, do the rest of the duplicates.

Put it down. Look, I duplicated it.

And they are basically placed below as well.

Done? When the diagram is completely yours.

This should become a complete diagram. Now write in it

How are you? See here to write on the entity

If you double click, you can write in it.

The same applies to attributes.

Click on it and you can write something on it.

Yes. Okay? Once the file is created,

How to download? Click on the file

Yes. Export Edge Pay and PG Pay

Click here to export

And here you have completed it like this

Remove it and write CS45 here.

Underscore one means this picture question

It is a number one picture, that is why I

Wrote CS 5 405 underscore 1 and simply save

Click on it. So this is your complete solution.

The diagram will be saved.