Hello I have two tables: Students and Professors (both with usual info like name, last name, email... etc) I also need to have info about their knowledge of foreign languages, and I guess that should be a third table (languages for example) it should look like: Language_id, Language, Speaking, Writing, Listening, Now, the tricky part for me is, how do I connect Language table with Students and Professors... If I make another column foreign key Student_id.... that way I can connect with Students but how do I also connect it with Professors table? Do I also put foreign key Professor_id? …

Member Avatar
Member Avatar
+0 forum 3

Hi I am currently searching for entities in this case study and I am hoping to create an entity relationship diagram after I have found all the entities. So far I have managed to come up with the following entities Members Group members Organised club racing Training sessions Boat Design class ManageRace Ms Access system However I am not 100% sure wether this is enough, can you spot any more entities? Here is the case study ____________________________________________________________________________ Peak Park Sailing Club PPSC is a small sailing club located in the Pennines near Sheffield. They want to organise their event programme, …

Member Avatar
Member Avatar
+0 forum 1

Hello, I am a student and I was assigned to create my first entity relationship diagram and I'm kind of lost. The professor hints the paintings should be broken into a generalization hierarchy since they have so many attributes but I can only break them into two sub(entities) based on my understanding of G.H.(using the "is a" rule) Anyway I'm struggling with that and finding the weak entity(professor also hinted that there is a week entity) I attached what I have so far as ERD1.pdf (didn't establish relationship type/participation constraints yet) Am I even on the right track/have the right …

Member Avatar
Member Avatar
+0 forum 6

I am making a windows based application in visual studio 2010 using VB. My project starts with a splash screen and a brief welcome splash then opens the main mdi form. The menu in the mdi form has the link to open all the other modules. My question is- How do I represent the MDI form in a DFD? and do all the other modules be included in the next level of the DFD or the same one as the main mdi form? Also what process should I use to represent splash screen--->mdi form? PLEASE HELP. ITS VERY URGENT>

Member Avatar
Member Avatar
+0 forum 3

Hi Iam using visual Studio 2008 professional edition in which iam working with visual c++ projects. I want to generate class diagram for the project. Class diagrams are working fine with c# and VB projects but its not working for c++ projects. I created fresh projects and tried to generate class diagrams. Its showing error "Some of the selected types cannot be included in the diagram". While going through help its shows me the following reasons which may results in that error. **Check your code for errors. Ensure that the selected code elements are supported in Class Designer. (For example, …

Member Avatar
Member Avatar
+0 forum 3

Hello I have two questions about timing diagram but I have no idea how to do them, and the due date is like 2 days away. Please help me. Thank you. 1) The circuit shown here needs to have its timing checked for specific input sequences on A, B and C. Complete the timing diagram shown for this circuit. All gates have 1 unit delay. ![11](/attachments/large/4/11.PNG "11") 2)Inputs A and B have the sequence shown. Draw the full waveform responses for Q and QB. Each gate has a 1 unit delay. In the sample timing chart shown the vertical lines …

Member Avatar
Member Avatar
+0 forum 2

well, this question maybe so silly, but i need to know.. i have to make an application with client-server system with java (client application for on android and server application for on PC) and i asked to make the class diagram for both in one class diagram (not seperately). so my question is, can i make class diagram of both application into one class diagram? because i know, there are different application so must make the class diagrams seperately. thank you

Member Avatar
Member Avatar
+0 forum 2

Hi, Please, this **isn't** about opinions on uml, it's usefulness (or lack thereof), it's standing, etc - please (I'm so tired)! I have a text usage case which main success scenario is thus: A) Two Players. B) Each player is prompted to enter their name C) Program randomly selects which is to be player 1 and the other is player 2 D) Player 1 selects a coin option (either "heads" or "tails") E) Player 2 gets the other option F) Program randomly produces a coin toss result ("heads" or "tails") G) Result of toss is compared with each player's coin …

Member Avatar
Member Avatar
+0 forum 2

i have some five problem like this can u help? 1.Cargo Tracking Management System 2.Supermarket Sales and Inventory Control System 3.Emergency Call Management System 4.Job Management System I want to what are the entities of these problems?

Member Avatar
Member Avatar
+0 forum 1

I'm working on a database project. I avve to build a DB for medical record (hospital) but I'm not too familiar with hospital stuff. I have to come up with entity sets with their attributes, build an ER diagram and then do a Query with GUI included. What I need from you guys is ideas about entity sets for medical records. I don't need anybody to build the ER or anything. I just need ideas of Entity sets. Specify if it's weak entity. I don't need attributes or relationships either. I can come up with those myself. Righ now, the …

Member Avatar
Member Avatar
+0 forum 4

HI, how do i draw the observer pattern in a component diagram? appreciate if someone could point me to a link thanks,

Member Avatar
Member Avatar
-1 forum 1

hi does anyone know any tool that will getnerage code when the sequence dragram is there? apppreciate a reply, thanks

Member Avatar
Member Avatar
+0 forum 3

SQL> DESC TOPPING; Name Null? Type ----------------------------------------- -------- ---------------------------- TOPPINGID NOT NULL NUMBER TOPPING VARCHAR2(10) TOPPINGTYPE VARCHAR2(5) TOPPINGCOST NUMBER(4,2) SQL> DESC PIZZATOPPING; Name Null? Type ----------------------------------------- -------- ---------------------------- PIZZAID NOT NULL NUMBER TOPPINGID NOT NULL NUMBER SQL> DESC PIZZA; Name Null? Type ----------------------------------------- -------- ---------------------------- PIZZAID NOT NULL NUMBER PIZZANAME VARCHAR2(30) BASECOST NUMBER(4,2) SQL> DESC PIZZAORDER; Name Null? Type ----------------------------------------- -------- ---------------------------- ORDERID NOT NULL NUMBER CUSTOMERID NUMBER PIZZAID NUMBER ORDERDATE DATE QUANTITY NUMBER How to draw ER-diagram (TOPPINH , PIZZATOPPING,PIZZA, PIZZAORDER) ?

Member Avatar
Member Avatar
-1 forum 1

Hi there, i need to draw an ERD Diagram and i can only draw the, product,blueprint,hardware,software and i am stuck Please help...i would appreciate it a lot.Many thanks. **Scenario:** You have been asked to create a database design for the BoingX Aircraft Company (BAC), which has two products: TRX-5A and TRX-5B HUD (heads-up display) units. The database must enable managers to track blueprints, parts and software for each HUD, using the following business rules: • For simplicity’s sake, you may assume that the TRX-5A unit is based on two engineering blueprints and the TRX-5B unit on three engineering blueprints. You …

Member Avatar
+0 forum 0

Need some help, practising for an exam and need to make sure I have got this right as it has came up a number of times. Here is the information from a relational representation and I have drawn a ER diagram for this, can someone please tell me if I have got this right or where I have went wrong. Thanks model Engineering Company **relation** Staff StaffNo: StaffNumbers Name: Names Grade: Grades AppointmentDate: Dates **primary key** StaffNo **relation** CompanyProject ProjectId: ProjectIds StartDate: Dates EstimatedFinishDate: Dates Manager: StaffNumbers **primary key** ProjectId **alternate key** Manager **foreign key** Manager **references** Staff **constraint** ((**project** …

Member Avatar
Member Avatar
+0 forum 2

What will be the steps for finding the DFD of A Project based on Banquet Hall? The project if of basic level. thank you.

Member Avatar
Member Avatar
-2 forum 1

I am having trouble to find the entities for this condition. Can anyone please help me here. A university has different types of staffs, e.g., lecturer, receptionist, cleaner etc. Should be recorded is class of jobs - Academic, Technical and General. An Academic can teach many subjects in a session (summer, winter) ............. University offers many degrees (post graduate and under graduate), and the degrees may be by coursework or by research. Each degree has many programs and each program has many courses.Need to clarify What type of course is that (core or elective). Any student can enroll many programs, …

Member Avatar
Member Avatar
+0 forum 2

Hello everyone, I hope everyone is having a wonderful afternoon. I am a college student who is Majoring in Computer Information Systems. In one course, we have a group project that covers the whole SDLC, and we are actually creating a new system. We're creating a e-commerce website that runs on a MySql server. We are still in the Design phase, with a little but of coding work being done right now, but I was curious if I could get some input on how I change a logical data flow to a physical. My disdain for DFD's at this point …

Member Avatar
+0 forum 0

Hi members, just a simple question, how would I show a constant in an UML diagram? For example, here is a double field the class contains. - radius : double But how would the constant PI (3.14159...) be shown? - PI : constant?? Future thanks for the responses!

Member Avatar
Member Avatar
+0 forum 3

Hi, I'm having trouble finding out whether I am doing my diagram the correct way or not. These are some of the properties of the diagram. Make an ER diagram and tables of the diagram: -Classroom contains the name of the building, the building number, and the space. -Reservation contains the day, hours and the expected amount of space. -Only the professor can reserve a room -Each course contains name / id And professor. -Each course must have a classroom -Only one professor per course I believe the Classroom and Course are the two entities and Reservation is the relation, …

Member Avatar
+0 forum 0

Can anyone help me making ah Case Diagram for Online enrollment? can anyone provide links to a good Case diagram tutorial? and Please help me here

Member Avatar
Member Avatar
+0 forum 1

Hey guys! I'm a newbie at databases and ER diagrams, and I need help with describing [URL="http://img194.imageshack.us/img194/521/38770389.jpg"]this ER-diagram[/URL]. I'm having problems with describing "Wine" - "Stocked" - "Inventory". I've learned that "Stocked" is an identifying relationship type and that "Inventory" is a weak entity type. But I have no idea how to describe it in words! I hope someone can help me with this! :)

Member Avatar
Member Avatar
+0 forum 5

Hello. I've been attempting a few exercises to brush up on my ER Diagrams using UML notation. I would greatly appreciate some help regarding this particular problem: • A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor, and each appointment references a single patient. • Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” • If kept, an appointment yields a visit with the …

Member Avatar
Member Avatar
+0 forum 1

Hi, I'm trying to expand an existing php-based project. I need to be able to allow users to create basic flow diagrams inside their web browser. Drag and drop environments with movement and resize abilities on a js canvas. Start blocks, information blocks (possible hyperlinks too), Decision Blocks, End Blocks, obviously lines to link them, that kind of thing. But it must automatically expand when you type into it and look very professional. On top of that, this must be stored into a database so it can be redrawn for other user levels. Also need to be able to interpret …

Member Avatar
Member Avatar
+0 forum 7

Hi folks, I'm building a database to store student exam results so that transcripts can automatically generated. This is a final year project for university so the database will never be used. I am a complete amateur when it comes to designing databases. [ATTACH]5254[/ATTACH] I have attached the relational schema for the database. I'd be grateful if someone who knows about proper design could tell me if its ok (from the point of view referential integrity and normalization etc). I'd really appreciate helpful comments. Regards, sabatier Just to explain a few things: 1) In the OverallMarks table, MarkType refers to …

Member Avatar
Member Avatar
+0 forum 6

The End.