is there a tool available, which generats an entity relationship diagram by a given, existing database? ...
I would like to know if I can auto-generate an entity relationship diagram or something similar for a schema in Oracle 9i database. I have a standard edition type installation of Oracle9i.Will I be able to do it with Oracle9i or are there any tools(other vendors) that's available for this purpose.i ...
I'm poking around in MySQL Workbench and am exploring the Entity Relationship diagram editor. Very Cool. I have a simple example of a a customer table and an Orders table. I am hoping the entity relationship diagram editor will help me create my sql for me. (including foreign key constrants). The re ...
i'm building a database with access for a computer business which sells computer products. The database is going to be from the point of view of the business not the customer. I'm having some trouble with the Relationship diagram, so far i have done this http://img509.imageshack.us/my.php?i...atabas ...
I need to draw a single Entity Relationship Diagram (ERD) to represent the following situation, which is described by means of text and a relational data model.SituationA relational database has been designed for a company which sells merchandise through magazine advertising. Customers who want to p ...
I have a database created from existing db scripts. I would like to see the constrain-relationship diagram between all the exsiting tables. Can do that somehow or through some thirdparty tool like Toad , etc.Kindly let me know. ...
it's it possible to make in oracle a graphical relationship diagram like access?And when yes with wich tool? ...
I am using Oracle 9i R2. Is there any way to view the Relationship Diagram of the schema. ...
We have a MS Visio diagram, created using “Cross Functional Flowchart” stencil (see attached), which we are attempting to import into SA using SA Visio Mapping.We believe the equivalent in SA to be the “Business Profess” diagram. However we are struggling a little with mapping Visio shapes t ...
Hi. I dont even know if this is the right board for this so please dont go nuts at me if it isnt. I'm working on a question for uni. But I'm really having some difficulty trying to make sense of it so I tried to find some people who may know anything about it.Heres the description: The chemical plan ...
Hello, I have attempted the question but (disregard the multiplicity thank you I need to thoroughly review that after your suggestion) I am not sure whether I had a correct relationship with correct entities. could you please check this for me thank you Masters! QUESTION:CEPA (name of company) place ...
I'm new to MySQL and am getting used to the Query Browser, v1.1.20. Is it able to graphically display the links/relationships among tables? Beyond that, can you create and edit the links through the diagram interface, if it exists? ...
I have to perform "the logical design step" on some ER diagrams. What this basically means is translate them into SQL.I've never done this before and need a little guidance. I'll try my best to "draw" the ER diagram. It looks a little something like this:employees<---->(wor ...
everyone, it would of a great help if anyone out there could help me with this.Im currently doing my major project on a sms alert system whereby the school sends out the exam timetable to the registered students mobile phones.BUT ive no idea how to do a ER Diagram on this. Help please.. ...
HelloI need to build a diagram showing the relationalship of the data items in the database somewhat like what I have seen in MS Access. Is there a way I can pull this information out of the Oracle database? I am using 9i r2 currently.Steve ...
imaginary language into java. I have everything down except for the symbol table. I am currently making ERD diagram for a library . The entities are below:Entity AttributesMember memId, memName, memAddress, memMaxbooksBook isbn, bName, datePublished, pubId*, ageLower ageUpper, valueCopy cId, isbn*, ...
I am new to Oracle Database..I want to know the concept of Data Modeling in detail like- how do we connect two entities in ER diagram and how do we start with it basically?I mean what steps needs to be followed when we want to design tables in Oracle database?If u can povide any material ,it would b ...
I have two ERD diagrams and I was just looking for someone to take a look at both for criticism and to determine which one I should use for implementing my database. It is for a group project and I am conflicted with my group partner so I was hoping to get some outside opinions on the ERD's.ERD1:htt ...
how do you represent many different kinds of essentially the 1 object? like a candidate for election, say, candidates can have a party, can be independant and so on...do i make 1 candidate entity and give it all possible attributes? or do i make many canidate entitys to represent all possibilities? ...
I need to design a booking system database but have a problem with identifying tables.I went to some companies but the information I got confused me even worse.Please ca you help me with the design.I'm a student at Vaal Triangle technikon, this is for my project.Please help me. ...
Is there a way to generate an ERD (from App Ex) for the db tables? ...
What is the difference between an Entity relationship diagram and a database schema? ...
I did reverse engineering in Oracle Designer 9i.I got server model diagrams after engineerd.I wanna know how will i convert that to an Entity relationship Diagram.I know that first i've to switch into Entity relationship diagrammer from Designer Editor.Can anybody lead me to complete it.Thanx in adv ...
i have given the job to develop the Entity Relationship Diagram for "TASK MANAGEMENT" for an MNCi'm a learner in ER DiagramI really dont know how to start with this......So please help me!!!!! ...
Hallo, Target: Visualisation of a (complex) MySQL-Database based on the MyISAM-engine (no support for foreign keys). End Result: Entitiy-Relationship-Diagram with virtual relationships Question/Request: Which software is best suitable for that? Is it possible to create virtual relationships among ta ...
I was reading lot of posts but i couldnt find this kind of topic.I've already finished my class diagram now i need to turn it into a ER diagrambut i couldnt find how to implement that in RSA 6.0Please does anybody know how to make that in RSA 6.0Other IDEs like Visual-Paradimg know how to perform th ...
Hello, colleagues all,I attach a Word file with four screen grabs in it.The first is the relationship diagram for a digital jukebox content management system.The second is the design form for a query involving three tables from the database. As you can see, MS Access says that it cannot create the S ...
guys,I do understand how to create a Table from Microsoft Access,what i dont understand is when you given a FLAT FILE,and expected to come up with TABLES.Here is an EXAMPLE1.The FLAT FILE has 11 ATTRIBUTES as follows:CustomerID,LastName,FirstName,Phone,Gender,GenderN ame,MemberSkill,MemberCost,Count ...
Hi, this is my first time posting here. I searched for a couple of hours but didn't find the answer I needed, so here goes:I've attached a very basic relationship diagram that I slapped together, just for the sake of hopefully making things easier to explain. This database is meant to store market r ...
I do have this assignment I have been working on for a while. My lecturer told us that we can produce few different EER models for this assignment and I would like to share with you my point of view at this problem and get as many other ideas and critical answers on what am I doing wrong.Here is the ...
Forgive me in case this is a recurring discussion, but I need help to clarify few of my doubts. I was going though UML 2.0 Superstructure, Kernel Package. Here I have following questions, [b]Root Diagram: [/b]Q1. Can you give a practical case of "Element" <-> "Comment" Composition relationship ...
I need Data Flow Diagram, Entity Relationship Diagram, Activity Diagram, Sequence Diagram, Architecture Design Diagram for the following Scenario.I can provide Use Case Diagram for this .. It might help u ..Please, Basically I m stuck in Sequence and Architecture Design Diagram. But I want to check ...
i have given the job to develop the Entity Relationship Diagram for "TASK MANAGEMENT" for an MNCi'm a learner in ER DiagramI really dont know how to start with this......So please help me!!!!! ...
I need to create a er diagram which is a entity relationship diagram about a hospital. My professor gave us a case study and the data requirements are wards, staff, patients, patient's next-of-kin, local doctors, patient appointment, out-patients, in-patients, patient medication, surgical and non su ...
I'm here to seek for help about my work that is shown in the following scenario. I hope there are people can give me some suggestions. I'm confusing about identifying the correct Entities and the correct Attributes . Please help me.SCENARIO:Esquire Hire Company hires out formal wear (suits etc.). Th ...
Have Hardy 8.04 32 bit at work and 64 bit at home. In both cases, I've attempted to import a database from MySQL into OpenOffice.org Base (and been successful) using the JDBC Driver. Once I have it imported, I attempt to set up table relationships. I have tried this in two ways.First by just draggin ...
is there any table that shows the relationship between each tables that i can find from PL/SQL ?in Oracle is there any relationship diagram as well ? fro, Oracle EM ??kindly advisetks & rdgs ...
guys am in real need of help here i need to create a single Entity-Relationship diagram for the following:StaffNoStaff_Start_DateFirst_NameLast_NameDOBHome_AddressHome_TelMobileNoWorkNoGenderNatInsNoStaff_SalaryCourse_NameCourseNoCourse_StartCourse_EndStaff_ID, First_Name, Surname, DOB, Address, Tel ...
I have been given the assignment to come up with an Entity Relationship diagram of an existing database. The database wasn't designed by me. I was wondering if there is a standard scientific way of displaying the relationships between the various tables at a functional level on Visio. Since, I didn' ...
microOLAP Technologies is pleased to announce the new CASE tool for MySQL: microOLAP Database Designer.Product page:http://microolap.com/dba/mysql/designermDirect download link (30 days fully-functional trial):http://microolap.com/dba/mysql/designerm/mymdd.zipMicroOLAP Database Designer for MySQL is ...
I am in the process of developing an e-com web-site for my project. I have experience with PHP, perl, CGI, mySQL and the same, but mostly because of my work schedule, I haven't been able to devote much time on this. I was wondering if this is something which you would be interested in working for on ...
Please I want an expert in java to help me solving a portfolio, because Im go to a trip outside the country and I should handle the project before the 9 10 2006 Please dont ignore my request, The question is Develop a small application for a Business. Your application must include the foll ...
This is a formal Interview, they ask question below:Prepare a 15 minute presentation outlining: "The essentials of programme/software designs"I thinking of preparing the below listed:TalkaboutMake a list of Methodologies e.g SSADM, RADMethodologies Choice e.g Campare SSADM with RAD choice ...
I'm using DB2 v9.1 and was looking for documentation on entity relationship diagrams for EnterpriseOne. Didn't find anything. Anyway I tried Reverse Engineering a database with some tables in Visio 2003, that didn't work out too well.So I'm looking for an free "entity relationship diagram" ...
I would like to generate an entity relationship diagram for an existing database. Is there any way to do this using DB2 tools. ...
This is a cross posting with:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=33143Is it possible to rename a database in SQL Server 2000? Ifnot, is it possible to copy the tables and relationship diagramfrom one to another? The database is new, so there are no records to copy. I just want to rename ...
Im a newbie! hi..... !!! I have two questions. i have mysql and mysql-front and about 50 text files with ALOT of data! each text file is a table, with different fields. Is it possible to import the table automatically so i dont have to manually enter the column names and then import the text file. A ...
I am hoping to get some general advise on database design for an e-commerce website. Looking at the number of online shops on the web got me thinking as to how they implement their databases. Sites like Amazon.co.uk sell loads of products in different categories e.g. CD's, Books, Electronics. Produc ...
I'm working on an entity relationship diagram about a mice farm.Let's say we have a very very basic diagram like this:MOUSE "is in" CAGEFor example, this givesMouse "n°1500" is in cage "AAA"Mouse "n°1501" is in cage "BBB"One operator can take one m ...
I'm new to DB2 and am currently trying to produce a database relationship diagram for a DB2 database. Could anyone tell me how i find out what primary keys are in a specific table. i only know SQL where you enter 'describe <tablename>;'I know how to do this in the control center but is there a ...