Tables :: What Means A Table To Appear As Entity On Diagram

Nov 16, 2013

what means a table to appear as an entity on the diagram? And how to identify the cardinality of a relationship and how to specify which is mandatory and which is optional.

View Replies


ADVERTISEMENT

Tables :: Creating Er Diagram From Existing Database?

Aug 21, 2013

Using access 2010; anyway to create an er diagram from an existing database? I have inherited a fairly large database and need to make changes to some field properties and need to find out where these fields are located. I know I can go into tools and run the documenter but doesn't give me an easy format to look at.

View 5 Replies View Related

Entity's Help

Apr 13, 2007

what entity/tables will i need for a book e-commorce site?
so far i have Book,Customer,Purchases,order and stock if possible could you suggest what fields i should have within.

View 1 Replies View Related

Entity Relationship Diagrams

Nov 7, 2007

Somewhere on the Internet are some sample entity relationship diagrams for various database designs.

I've used every sort of Google search criteria I can think of, and haven't been able to find it.

Anyone got any idea of the site I'm talking about? Or any other resources even.

Thanking you in anticipation.

Cheers Tony

View 6 Replies View Related

Does Anybody Know What This Means?

Mar 15, 2006

Danny,

Below is a outline of the new application that I would like you to write.

In a nutshell, this application will test the connectivity to specific network dirves/directory and display whether the connectivity test passed or failed. I see this as something that automatically runs once started then displays the results. Understanding "error" handling will be an important part of this.

Test cases to include:

a) Tag Inventory System = W:Company Shared DataTagInv
b) Maintenance Stores System = W:Company Shared DataEngineeringMtceStores
c) Customer Information System = Z::CustInfo
d) Sales System = Z:SalesSys
e) Alfak Database = ODBC connectivity to Alfak/Gupta database
f) etc

The test cases are to be in a table for ease of editing rather than hard coded.

Please review this and come up with a skeleton design on paper on what you think I want based on the above and we will discuss tomorrow at 9am.


-----Can somebody tell me what he intends for me to do ? I am kind of confused

View 1 Replies View Related

Can Someone Tell Me What This Command/method Prefix Means??

Apr 6, 2006

Hi

I am new to VB.

Can anyone tell me what the 'ac' part of a method, such as 'acReport', actually means. I am guseeing it may be something like Active Command or similar.

There is no other reason that curiosity for me wanting to know this...or is there??

Thanks in advance

View 1 Replies View Related

Microsoft Monopoly Means No Documentation

Sep 19, 2004

I spent a great deal of time trying to load up a picturebox with an image stored in an Access data base.

The thing that was most troubling was the complete lack of documentation.

Every feature that exists in VB or Access had many, many man days spent in development. Which means that someone has extensive documentation on it.

Yet, when I went to Microsoft web site to look it up, I was told my product (access) was not supported in the us, but rather I had to pay $99 to speak with someone.

It is a shame that the Microsoft monopoly is able to steal from the consumers and the little developers. Not to get to political but i think it is unfortuante that the bust up of microsoft was averted. It is really a drag to the little developer the lack of documentation and proper development of so many features of their products.

Perhaps I am missing something but is there a place to find proper documentation on the various components - with examples of use?

View 8 Replies View Related

Application Diagram

Aug 4, 2005

Can anyone point me in the right direction to produce an application diagram.

Sort of a map of an app, what data it hold in laymans terms rathers than table and field definitions. What forms do what, and how the whole application fits together.

Thanks for any assistance you can offer.

View 9 Replies View Related

Relationship Diagram

Sep 24, 2006

Hello I would like to make a table Relationships diagram to enforce referential integrity.

I wanted to make this diagram in the Back End container but I realized if I want to delete a corrupt table I have to delete the relationships as well.

(My clients might need to delete an individual corrupt table and replace it with a previous copy. This will cause the relationship to be removed and I don't expect my clients to re-establish this relationship.)

My question is: What if I put the relationship diagram in the Front End container? Will this enforce all the integrity rules? I assume if I put the diagram on the front end ... the user can replace tables in the Back End and the relationships diagram will be unaffected on the FE.

Any input on this topic would be appreciated thank you.

View 3 Replies View Related

Help! With Relationship Diagram

Jun 20, 2007

Hi 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...atabasefa1.jpg

The aim of the database so for the customer to purchase product, and the business records this transaction. Its from the point of view of the business not the customer. The business uses a supplier for its products and has no physical stock on hand.

View 8 Replies View Related

Query Diagram

Nov 2, 2007

Is there an easy way to get an explanation of where each query within the Db gets it's data from?

I'd ideally like to get a hierachical model - be it as a diagram, text, or whatever - along the lines of

QueryABC gets data from QueryD and QueryE
QueryE gets data from Table1
QueryD gets data from QueryX
QueryX gets data from Table2

I've only just needed to look at the existing queries in this Db in any detail and I'm hoping there's some faster way to sort this out, rather than manually opening and listing each one.

Thanks for any ideas.

View 7 Replies View Related

Refining RSD Diagram

Dec 15, 2005

Hello forum,I am new to designing databases and am excited to learn everything I can. I have read about normalization and relational structures and just need some assurance that I’m on the right track. I’m not looking for someone to design this database for me but am looking for someone to help critique what I have so far which is some user requirements and a RSD. My RSD is attached below.What I am building is a database to track carpets that have been cleaned in rooms which are in buildings. Employees clean carpets in rooms in a building. Many employees can be assigned to a carpet cleaning project. Employee’s record which building they are in, what room's carpet they are cleaning, what day and time they started and ended cleaning, what materials and method of cleaning they used, and the reason for the cleaning. Depending on the reason, the customer is charged a certain rate per hour of carpet cleaning. I am hoping to be able to query from this database to be able to answer, when the last room was cleaned, how long did it take to clean a room, and how much did it cost to clean a room. Some questions I have are: What attributes should be included in the PROJECTDETAIL table and not in the PROJECT table? When should I create a table showing DETAILS of an entity? How do I know when I should have an associative table or correlation table? Am I on the right track in creating this database? Thanks for your help!

View 2 Replies View Related

Database Relationship Diagram

May 25, 2005

I need some help. I have to design a relational database for a small bookstore that operates 3 stores.Books are sold by a sales person to a customer through an order. A order may consist of one or more books but assume that for a given order, all the books sold are all from one store and are sold by one salesperson.


Field name
Address
Author ID
Author Name
Book ID
Book Type
Book type description
City country
Cust ID
Cust name
Cust Type
Cust type descr
Email
On hand
Order date
Order no
phone number
phone typr
phone type descr
postcde
publisher ID
Publisher name
quantity
salesperson ID
Salesperson name
Salesperson Phone
Selling Price
Store Address
Store City
Store email
Title


How do I start the database

View 1 Replies View Related

Please Suggest How To Make Block Diagram

Feb 25, 2006

I am developing one software in access 2000. Now where i stuck up is ... Customer is asking for " process flow chart" (steps in block diagram). The requirement is as below..

For a pen there are below operations
1. moulding
2. cleaning
3. polishing
4.assembly

Now these flow of operation is to be presented in block diagram. Please suggest me how do I do this in accesss? (in form or report)...

View 3 Replies View Related

Logical Diagram - Plsssss Helpppppp

Jun 4, 2006

hi everyone, this is first post, i have this task and i think i have the solution but im not sure, so plsplsplspsssssssss someone help!!!!
its called class scheduling. below is the physical model. i need to make the logical, i have been told that course and section share a many to many relation as well as section and faculty and also bwee/ faculty and course, thus the creation of the intersection tbl, the OFFERINGS TABLE. i have inserted the foreign keys (FK's) into that table (which are the primary keys for the 3 main tables). what i need to know is that:
1. do i need anymore FK's?
2. wen i make my logical diagram, do i show it like the way i have shown it in the word file? i made it as such that course and section have the PK of the 2 tables and are now FK which allow duplication ie 1 course can have many sections etcc pls helpppppppppppp


Courses table
CourseID (PK)
Title
Credits

Sections table
SectionsID (PK)
Days
Time

Faculty table
FacultyID (PK)
Firstname
Lastname
department
Title
FullTime or partime
hiredate

Offerings table (intersection table)
OfferingID (PK)
CourseID (FK)
SectionID (FK)
FacultyID (FK)
Building
Room

View 1 Replies View Related

Queries :: Quickly Diagram A Query Like Flowchart

Jun 11, 2014

All I have taken over a database. It has dozens of queries. Is there a tool or code that I can use that would quickly diagram the querie like a flowchart telling me what queries are related and the steps and so on.

View 1 Replies View Related

Access 2013 Chart Diagram Modification With VBA

Oct 17, 2014

I would like to do two things

1.) pink arrow // I've changed the titel in a diagram with vba ... is there also a methode to move the position of the titel with vba ( left-center or rigth ? )

Private Sub Form_Current()
' KostenHinweis im Diagram
Me!Dia_WS.Object.ChartTitle.Text = _
"Preis: " & Me.[Roh-Preis] & "€/kg " & _
" Mindestbestand =" & Round(Me.MindestBestand * Me.[Roh-Preis], 0) & "€ ; " & _
" Maximalbestand =" & Round(Me.MindestBestand_Max * Me.[Roh-Preis], 0) & "€"
'Me!Dia_WS.Object.ChartTitle.Left ???
End Sub

2.) red arrow // maybe its because of the titel placement.I would like to change the size of a diagram with VBA code to have the diagram fit nicely to a given space best thing would be if there would be a possibility to resize the diagram in the given space

View 3 Replies View Related

Making Transactions With Multiple Products (Diagram Inside)

Mar 21, 2008

Hey people, hows it going? Quick question

I am creating an EPOS system for a bookstore and I have a many to many relationship between the transactions table (tbl_transactions) and the products table (tbl_products) using a link table (tbl_linktblproductstransac). The below diagram shows what i mean below:

http://img512.imageshack.us/img512/3246/relationnshipswd9.jpg

I made it many to many because 1 transaction can have many products on it and 1 product can be on many transactions.

Now what I need to know is how will i make records with more than one product on one transaction (in the table itself or in a transaction form). I would really appreciate if someone could help. Thanks :) and have a good Easter

View 2 Replies View Related

Newbie Trying To Create A Dependency Diagram And Determine Relationships

Feb 9, 2006

Hello : )

I am currently taking a database design class using Access 2003 and am looking for some help. I am trying to draw a dependency diagram before I create the tables based on the following attributes / fields in one table named Student:

StudentNumber, StudentName, StudentMajor, student's AdvisorNumber, AdvisorName, AdvisorOfficeNumber, AdvisorPhone, student's NumberCredits and student's Class (freshman, sophomore, etc.)

So far I have identified the Primary Keys as StudentNumber and AdvisorNumber and this is what I have:

Table #1 - Student = Student Number functionally determines Student Name, StudentMajor (?) NumberCredits and Class
Table #2 - Advisor = Advisor number functionally determines Advisor name, office number and phone

The problem I run into is with the the StudentMajor / Advisor / StudentNumber relationship. Since one student can have many majors and therefore many advisors since there is only one advisor per major, and each advisor has many students I am assuming it is a many-to-many relationship.

The problem I am having is determining the third table (and fourth if there will be one) and the relationship between StudentMajor / Advisor / StudentNumber.

Should StudentMajor be included as functionally dependent on StudentNumber? If it is there would be redundancy due to multiple entries in that field for each row so I guess I can't include it actually. :confused:

Wouldn't there have to be another attribute named AdvisorDept for this to work properly....that way there is a relationship between Advisor and their department they work in so I can link the student's major to the advisor :confused:

Any pointers and suggestions would be greatly appreciated

Thanks

View 2 Replies View Related

Unable To See Relationship Diagram In Database After Upsizing From Access 2003 To SQL

Nov 9, 2011

I have upsized from Access 2003 to SQL Server 2008 R2 using upsizing wizard. Everything works fine. But I don't see relationship in SQL SErver 2008 R2 if I go to database. But I set relationship in Access 2003 before upsizing it.

Amso I don't see relationship (diagram) in Access 2003 , which I was able to see before.

So do I need to again recreate the relationship amongst the table in Access 2003 Or SQL SErver 2008 R2 ? I thought, if you link tables, everything should be taken care but i don't see relationship structure any more.

View 1 Replies View Related

Tables :: Consolidating Multiple Tables In One Single Table (Sorted Ascending By Time)

May 30, 2014

What I have is a database setup with multiple tables in which different areas of my DC can input information simultaneously into their respective tables. I then have another database linked to it for myself to have a live view of each updated record. I would like to see all the records of each table in 1 single table (possibly just sorted ascending by time). Each table has the same Field headings but may have different qtys of records. As I will then have it linked to an Excel table to VLOOKUP from it.

I have tried Union coding but always get Syntax Error etc.

View 8 Replies View Related

Tables :: Calculated Fields From Two Tables / Based On Relationship In Third Table

May 29, 2014

I have two tables of data, each relating to three business branches (branches A, B and C).

Table 1 shows the expenditure of each branch (by fuel, premises and wages).

Table 2 shows a number of units for each branch (mileage, floorspace and sales).

What I would like to do is calculate unit costs, based on the expenditure in Table 1, divided by a relevant unit in Table 2. The catch is that I want to have a third table which allows the user to specify which expenditure (from Table 1) is combined with which unit (from Table 2) to generate the calculated unit costs. I've been able to do this in Excel, and have attached an example. I've also attached an incomplete Access version with the first two tables. Given the complexity of my actual data, I feel this could be better handled in Access than Excel.

View 6 Replies View Related

Tables :: Joined Two Tables - Unable To Filter / Lookup On Second Table?

Feb 18, 2013

I have an Access Table with about 28,000 Automobile dealerships across the country shown. I've joined a new/small phone contact table to this to keep up with our phone contacts with the dealership and followup efforts. When I search/filter on the dealership table all is fine. However when I search/filter on the phone contact table with a few test entries, I get nothing at all. I supposed that after joining the tables, I'd be able to do a search on the field named follow up date and find/filter today's date or other dates and locate which dealerships to contact when the correct date arrives. But nothing.

View 14 Replies View Related

Tables :: Populating Several New Tables With The Contents Of Original Table

Mar 29, 2013

I have a feed from ODBC to Access DB. I need to populate several new tables with the contents of the original table. I know I'm being stupid but it's been a long week.

View 1 Replies View Related

Tables :: Combine Two Tables That Have Identical Structure To One Table?

Jul 8, 2013

I need to combine two tables that have identical structure to one table. Different people have used them to insert data from different parts of our project. I have tried to find information about how to do this but so far with little luck.

View 13 Replies View Related

Tables :: How To Combine Records Of Three Tables Into One Table

Jul 30, 2013

I have three tables. I want to combine all the records in these tables into one table. I need VBA code to do this. The first table is called down1, the second table is called down2 and the third table is called down3. All these tables contain the same fields so I don't think combining them will be a problem.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved