I know how to do this manually but automatically?

Contents:
I know how to do this manually but automatically?

piterden 2021-01-19 12:59:22

To make a correct database structure, you should know your subject area well. If you ask to help you with this, you should give that information to us completely

2021-01-19 13:00:15

yes, if i take an equipment from storage to lab or vice versa. it will be recorded. the database is also used to manage associate device and installed app on used computer in lab.

piterden 2021-01-19 13:01:27

So you have rooms, computers, devices, apps and some relations between them

piterden 2021-01-19 13:01:36

Am I correct?

2021-01-19 13:01:40

yes.

2021-01-19 13:02:30

and i want to different management for equipment used in lab with unused equipment in storage room.

piterden 2021-01-19 13:02:53

2021-01-19 13:02:30

and i want to different management for equipment used in lab with unused equipment in storage room.

It doesnt matter now

piterden 2021-01-19 13:04:26

You should think about it like about things (actually types of things), which have other things or belongs to other things if we would look at them from the opposite side

piterden 2021-01-19 13:04:48

Computer can have many apps

piterden 2021-01-19 13:05:06

Room can have many computers

piterden 2021-01-19 13:05:14

And so on

piterden 2021-01-19 13:06:05

Your scheme should be more like a chain neither like a net

piterden 2021-01-19 13:07:00

Please try to rewrite your scheme using these simple rules

piterden 2021-01-19 13:07:24

And then we will be able to continue

piterden 2021-01-19 13:08:48

I 100% sure there shouldn’t be any crosses of relations

2021-01-19 13:09:16

i was thinking i can get help with that, since thats where i troubled with. as i also noted before i did a data structure for this ( struct inside struct) but still confused to create db schema

piterden 2021-01-19 13:10:15

Don’t mind with one thing. Mind with the types of things

piterden 2021-01-19 13:11:56

2021-01-19 13:09:16

i was thinking i can get help with that, since thats where i troubled with. as i also noted before i did a data structure for this ( struct inside struct) but still confused to create db schema

I trying to help you to understand it. The other way: you can just hire me, then give me all information and you will get your ready to use DB very soon )

2021-01-19 13:12:47

sure, i was’t trying to get full answer anyway. but i failed to grab your explanation. my bad.

piterden 2021-01-19 13:13:59

You are trying to understand SQL. I am trying to learn English. It is just your payment to me )))

piterden 2021-01-19 13:14:46

The symbiosis

piterden 2021-01-19 13:17:10

2021-01-19 12:46:44

this is kind of a poor presentation of entity structure of database that i want to create. Here is the explanation, i want to create a DB to manage every equipment in computer lab and also computer storage room. my problems are
1. i do not really know how many tables i need to create. ( i can think of to create tblRoom – to list all rooms, tblEquipment -to list all equipment. I do not know if i need to create tblType – to list equipment’s type, tblAssociatedDevice – to list all associated dev for each PC, tblInstalledApp – to list all necessary installed app in each PC.
2. Do i need to create another table to list every equipment in storage room. since the pc is unused without associated device and installed app.

You have draw items. But you should draw their classes

piterden 2021-01-19 13:18:03

Rooms
Computers
Equipment
Devices

piterden 2021-01-19 13:18:13

and so on…

piterden 2021-01-19 13:18:46

Because tables are classes and rows are items

piterden 2021-01-19 13:19:56

Structure does contain tables and columns and doesn’t contain rows

2021-01-19 13:20:20

dam* i’m so stupid. haha. i’ll try to create a schema. pls help to evaluate it later.

piterden 2021-01-19 13:20:41

piterden 2021-01-19 13:19:56

Structure does contain tables and columns and doesn’t contain rows

Hope it was much clear

2021-01-19 13:55:22

thank you.

MasterZiv 2021-01-19 13:55:37

piterden 2021-01-19 13:17:10

You have draw items. But you should draw their classes

@Xedoxzarea please note, that entities and classes are two names for one same thing

2021-01-19 13:56:04

MasterZiv 2021-01-19 13:55:37

@Xedoxzarea please note, that entities and classes are two names for one same thing

yes, i know that.

Liran 2021-01-19 16:15:29

Does anybody know how to do automatic fail/switch over?

piterden 2021-01-19 16:16:05

Liran 2021-01-19 16:15:29

Does anybody know how to do automatic fail/switch over?

Wat???

Liran 2021-01-19 16:18:09

I have master-slave and I want that in case the master fail to work the slave will take place.