Entity Relationship Diagram
Entity Relationship diagram
can anyone help me with my diagram pleasee..i have been banging my head on it for weeks.
i have 6 entities Student, Course, Module, Attendance, and Result
Polato Student Record System
"The Polato university administration has decided to computerise their student record system. The system must be able to automatically print a new ID card for students on their admission and after completion of each academic year. The card should have the student’s name, number of years and the message welcome to 1st, 2nd or final year.
In a bid to curb the rate of incompletion, the system should also be able to record attendance of students to any class. The system should be able to automatically send out a warning to any student that misses any two lectures for the first time. (Of course the student should come up with a very good reason for missing the lectures or else he/she will be removed from the module). Missing three or more lectures leads to automatic withdrawal from the module involved. A student will receive notice from the system, right after missing the second lecture.
The system also must be able to calculate each student’s results for that semester only showing details of all modules taken. You should use the simple formula; the total of all the modules taken, divided by the number of modules"
charles
View Complete Forum Thread with Replies
Related Forum Messages:
Entity Relationship Diagram
I have VS 2005 and SQL Server 2005 Express installed and I created 4 tables and setup the primary and foreign keys and can view the individual foreign key relationships by right clicking on the foreign key. Is there a way to view a table relationship diagram (fields with primary and foreign keys), such as Access provides. Does VS 2005 or SQL Server 2005 have that capability? Thanks
View Replies !
How Can I Create A One-to-one Relationship In A SQL Server Management Studio Express Relationship Diagram?
How can I create a one-to-one relationship in a SQL Server Management Studio Express Relationship diagram? For example: I have 2 tables, tbl1 and tbl2. tbl1 has the following columns: id {uniqueidentifier} as PK name {nvarchar(50)} tbl2 has the following columns: id {uniqueidentifier} as PK name {nvarchar(50)} tbl1_id {uniqueidentifier} as FK linked to tbl1.id If I drag and drop the tbl1.id column to tbl2 I end up with a one-to-many relationship. How do I create a one-to-one relationship instead? mradlmaier
View Replies !
Need Help On Entity-Relationship Design
I need to design a schema that will provide me a hierarchical view in reporting. I mean by this is, lets say: Hospital |_________> Hospital Entity | | | | | V | | Clinic A | | - Jane Doe MD | | - Janette Brown MD | | ACME Clinic | | - Jennifer Smith MD | | Clinic of Jennifer Smith MD | | - Jennifer Smith MD | | - Billy Johnson MD | | | V | - Earl Brown MD (Hospital Entity Resident Practitioner) | - Janette Brown MD V - John Smith MD - Bob Jones MD The design should also allow me to query a practitioner and the query will show all the entities he or she is a member of. If this is not the correct place to post this posting, please let me know the correct place and I will make the necessary changes. Thanks, Stephen
View Replies !
Entity Relationship Management Idea
Please let me know what you think of this scheme I have come up with(not to imply that noone else has before me) for managingrelationships.I have created an entities table with Individual and Organizationalsubtypes. I need to be able to relate them to eachother (e.g., someare customers of or suppliers to others, some have employer/employeerelationships,...). I know this is not an uncommon thing to do.So, I have created relationship pairs with left and right values. Thepairs are things like employee/employer, customer/vendor,contractor/client,... Then I can create relationships that will letme look in two directions. For example, if I say entity1 has anemployee/employer relationship with entity 2, that means that entity1is an employee of entity2 and entity2 is an employer of entity1.Entities (This is just a view of the combined ind/org subtypes tables)EntityID EntityName1 Doe, John2 MyCorp, Inc.3 Smith, Jane4 AnotherCorp, Inc.RelationshipTypesRelTypeID RelLValue RelRValue1 Employee Employer2 Customer Vendor3 Client ContractorRelationshipsRelTypeID LEntityID REntityID1 1 24 2 22 3 3Then I can query for everyone that has a relationship with a specificentity by using:SELECT Entities.EntityName, RelationshipTypes.RelLValue ASRelationship FROM RelationshipsLEFT JOIN Entities ON Entities.EntityID = Relationships.LEntityIDLEFT JOIN RelationshipTypesON Relationships.RelTypeID =RelationshipTypes.RelTypeIDWHERE REntityID = 2UNIONSELECT Entities.EntityName, RelationshipTypes.RelRValue ASRelationship FROM RelationshipsLEFT JOIN Entities ON Entities.EntityID = Relationships.REntityIDLEFT JOIN RelationshipTypesON Relationships.RelTypeID =RelationshipTypes.RelTypeIDWHERE LEntityID = 2Returns:EntityName Relationship (to EntityID = 2)Doe, John EmployeeSmith, Jane ContractorAnotherCorp, Inc. Customer
View Replies !
Relationship Diagram
Hi there, I just set up my AppData and i'm trying to connect the Membership to a tbl_Profile that i created.I notice there's an application_id and a user_id which are uniqueidentifiers. I've been trying create a relationship to tbl_Profile's user_id column but it won't let me saying it's not compatible. Am i suppose to set tbl_Profile's user_id column to int or uniqueidentifier? I've tried both and it won't let me... THanks!
View Replies !
Relationship Diagram
Hi, Can anyone tell me in which issue of SQL magazine is the relationship diagram of system tables published? Can i see it online somewhere? TIA.
View Replies !
Reporting Off Of MS CRM Tying Notes Entity To Opportunity Entity
I am trying to create an opportunity report that includes notes from the notes entity. Unfortunatly, when I pull the fields from the notes entity into my reports, it seems there is no way to tie the notes to specific opportunities or accounts that they are associated with and I get all notes under the first item listed on my report. Is there a way to link data sets like Access lets you link tables?
View Replies !
Primary Entity Always Switched With Secondary Entity
Hi... I just tested to create a Report Model using SQL Server 2005 Reporting Services. But I found some problems when I tried to create a report using the Report Builder, that the entity (that was supposed to be a primary entity) always switched to secondary entity when I drag a field from other entity. For example: The entity that was supposed to be the primary one is the 'Sales Target per site' table. List of fields of 'Sales Target' table: - Site ID - Sales Target value The entity that was supposed to be the secondary one is 'Sales Order' table. List of fields of 'Sales Order' table: - Site ID - Sales Order Number - Sales Value First, I drag Site ID and Sales Target value from 'Sales Target per site' entity. Then, I drag the Sales Order Number from 'Sales Order' table, and......... 'Sales Target' entity switched to be a secondary entity, and 'Sales Order' become the primary one =( anybody help me to solve this problem please.... thanks, Reza
View Replies !
Not Able To Create A DB Diagram In SQL Server 2005. No Menu Option For Creating A DB Diagram??
I have created a database with several tables. I want to create a database diagram to show the relationshipbetween the tables. Below are the steps from the SQL Server 2005 documentation on how to create a database diagram. The problem is that when I right click on the Database Diagrams folder I am only given two options. They are:"Working with SQL Server diagrams" and "Refresh"There is no menu choice to create a new database diagram. Can anyone tell me what the problem here is? To create a new database diagramIn Object Explorer, right-click the Database Diagrams folder or any diagram in that folder. Choose New Database Diagram on the shortcut menu. The Add Table dialog box appears. Select the required tables in the Tables list and click Add. The tables are displayed graphically in the new database diagram.
View Replies !
Cannot Add An Entity That Already Exists.
Hello, Why do I receive this error "Cannot add an entity that already exists." I'm trying to add three data at one call using LINQ, after getting the error above then refreshing the page, only one data is inserted.... Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim db As personalDataContext = New personalDataContext Dim p As New personal For i = 0 To 3 - 1 p.name = "Mick" p.number = "01213" p.picture = "image/image.jpg" db.personals.InsertOnSubmit(p) db.SubmitChanges() Next End Sub... cheers,imperialx
View Replies !
Record (entity) Versions...
Database newbie question: My sample database (T-SQL syntax): CREATE DATABASE sample GO USE sample CREATE TABLE customers (CustomerId int IDENTITY(1,1) PRIMARY KEY CLUSTERED,name varchar(50),address varchar(50)) CREATE TABLE invoices (InvoiceId int IDENTITY(1,1) PRIMARY KEY CLUSTERED,date datetime,CustomerId int REFERENCES customers(CustomerId)) INSERT customers (name,address) VALUES ('First Company Ltd.','New York') INSERT customers (name,address) VALUES ('Second Company Ltd.','Washington') INSERT invoices (date,CustomerId) VALUES ('Jan 1, 2004',1) INSERT invoices (date,CustomerId) VALUES ('Jan 2, 2004',1) INSERT invoices (date,CustomerId) VALUES ('Jan 2, 2004',2) SELECT * FROM customers GO CustomerId name address 1 First Company Ltd. New York 2 Second Company Ltd. Washington SELECT i.date,c.name,c.address FROM invoices AS i INNER JOIN customers AS c ON i.CustomerId=c.CustomerId GO date name address 2004-01-01 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 Second Company Ltd. Washington UPDATE customers SET address='Boston' WHERE name='First Company Ltd.' GO INSERT invoices (date,CustomerId) VALUES ('Jan 3, 2004',1) SELECT * FROM customers GO CustomerId name address 1 First Company Ltd. Boston 2 Second Company Ltd. Washington SELECT i.date,c.name,c.address FROM invoices AS i INNER JOIN customers AS c ON i.CustomerId=c.CustomerId GO date name address 2004-01-01 00:00:00.000 First Company Ltd. Boston 2004-01-02 00:00:00.000 First Company Ltd. Boston 2004-01-02 00:00:00.000 Second Company Ltd. Washington 2004-01-03 00:00:00.000 Second Company Ltd. Boston Is it possible in any of the RDBMS's to make this last query return the following result set? 2004-01-01 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 First Company Ltd. New York 2004-01-02 00:00:00.000 Second Company Ltd. Washington 2004-01-03 00:00:00.000 First Company Ltd. Boston
View Replies !
Lookup Entity Not Working
Hi, I have a table called Posts which contains an attribute Hospital ID. This is a foreign Key to the Hospitals table, which contains two fields : Name & Region. In my report model, I would like the Hospital ID to be replaced with just the Hospital name. I have set the Hospitals entity to IsLookup=True and the IdentifyingAttribute to Hospital ID. However, in the report builder Hospital ID is still being displayed with no sign of the hospital name. Can anyone point out where I'm going wrong? I have tried setting the Name field in Hospitals to Role or Merge as I read that using 'name' might cause some problems but that made no difference
View Replies !
Report Model Entity Descriptions
If I want to set a description for each column in a large model with many tables, it is a pretty intensive manual effort. Is there any way to autogenerate the enity descriptions from say the extended properties table designer description?
View Replies !
Entity Results Based On Parameter
In the report designer cant we createb report paramter to create an table using new named query. when I deploy the report model and when the power user try to access the entity it should prompt an prompt asking for which quarter information does he need. Thats is when an end user click on the entity it should prompt for paramter and based on the paramter the results of entity should be avaialble. In some cases based on user i want to limit the number of fields in an entity can an user see. Regards, Navin
View Replies !
REPORT Model - Missing Entity
Hi , I created 3 tables in SQL server magmt studio as student - sno (pk), sname subjects - subno(pk), subname marks - sno(fk), subno(fk), marks While creating the report model: 1.Created the data source - no problem 2. created the data source view - no problem added all 3 tables here. 3. created the report model - only subject and student show up here. Where is the marks table? Please help Regards, Reshma
View Replies !
Question Related To E-r Model And Entity
Hello to everyone! I would like to ask you sthg as far as the e-r model is concerned! I haven't started of course to use SQL yet,cause i have to make the e-r model first. I have a a question to make : For example i have to keep data for a Personal Computer (PC) So i have the entity : COMPUTER COMPUTER has many characteristics/fields like the primary key which is going to be PC_ID and it's unique for every computer,NAME_OF_PC the name and also TYPE_OF_MOTHERBOARD, TYPE_OF_RAM, TYPE_OF_HARD_DISK etc. I have to keep for the TYPE_OF_MOTHERBOARD the manufacturer, the motherboard's code etc. Shall i make an entity for the motherboard or for the HARD_DISK or for the RAM? Cause i want next to change these fields of every COMPUTER if it's n eeded! e.g. i have the PC_ID = 12 and i want to change the hard disk cause it's not working!(shall i keep an entity of the hard disk or not?) Can sm advise me what i shall do? Thanks, in advance! :)
View Replies !
Associative Entity - Combining Result
Hi, I have the following table (1) Item Table ItemID Name 1 Sample Item (2) Brand Table BrandID Name 1 Sample Brand - 1 2 Sample Brand - 2 (3) ItemBrand Table ItemID BrandID 1 1 1 2 Desired Output ItemID ItemName Brand1 Brand2 -------------------------------------------------------- 1 Sample Item Sample Brand - 1 Sample Brand - 2 How to get the desired output?
View Replies !
External Entity Handling Database Tables
Hi, I'm trying to find out whether it is possible to integrate an external entity into MS SQL Server in following way: the entity defines certain set of tables when user performs a query on one of these tables, the query is sent to the entity for processing and results are returned back to SQL server (and to client) I thought integration services could be used for this task, but I'm quite unfamiliar with MS SQL server, so I don't know whether it would be a feasible solution...
View Replies !
List CRM Entity Attributes And Data Types
Hi, I am using CRM 3.0 and have a requirement to list all the the tables, attributes names and display names and datatypes. Is there any easy way to export this information from the CRM tool or prepare a SQL query that will list the information?
View Replies !
Design To Accomodate Entity Based Schema Versioning
in simple words it's about versioning at record level.ExampleTableEmployee - EmployeeId, EmployeeName,EmployeeAddress, DepartmentId,TableDesignationMap - EmployeeId, DesignationId, EffectiveDate,validityTableDepartment - DepartmentId, DepartmentTableDesignation - DesignationId, designationVia Modify-Employee-Details screen following are editableEmoyeeNameEmployeeAddressDepartmentDesignationthis screen should allow user to navigate through changes history.Example :Version -1EmoyeeName John SmithEmployeeAddress 60 NewYorkDepartment AccountsDesignation AccountantVersion -2EmoyeeName John SmithEmployeeAddress 60 NewYorkDepartment AccountsDesignation Chief Accountant - changedVersion -3EmoyeeName John SmithEmployeeAddress 60 NewYorkDepartment Sales - changedDesignation Marketing Manager - changedQuestion :What is the best proposed database design for maintaining historyrecords bound with version and retrieval techniqueBest RegardsSasanka
View Replies !
Changing The Primary/base Entity On The Report Model
Let's say there is a relationship A 1--* B defined in a report model. When using the model either in Report Builder or while defining the dataset in Report Designer I find that if I mean for entity A to be at the root and I accidentally click on B's fields, B becomes the root entity. While I understand the reasoning behind this, I cannot find any way to get back to A as the base entity. Even if all B fields are removed from the report, B remains as the root. This is very frustrating as the entire report/dataset will need to be rebuilt from scratch. Any ideas?
View Replies !
VS 2005 REPORT MODEL MAXIMUM ENTITY SIZE
Hi, I'm opening a Report Model with 3mb size in a 256 mb memory and cannot load Report Model...Tried it on a 1.5 GIG memory and I was able to open Report Model. But we need to open a 14 mb Report Model. When we tried to open this in our 1.5 GIG memory, we were not able to do so...Does CPU memory have to do with the size of our Report Model in loading it?
View Replies !
Limit On Blob/image Data Type In SQL Compact 3.5 SP 1 BETA For ADO Entity Framework?
Hi! I tried to save some image data, but it get truncated at 8000 (the table column is defined as Image). I then wrote a converter to try ntext-datatype instead, but it gets truncated at 4000. Error message: System.Data.SqlServerCe: @3 : String truncation: max=4000, len=4168 The code uses only ADO entity framework for database access. Is there a way to store binary data larger than 8000 bytes? I am running SQL Compact 3.5 sp 1 BETA. Henning
View Replies !
How To Have The DB Diagram
Hi all the SQL wizards there!!!I have a Data base consisting of 675 tables. There isn't any data basediagram created and not even any data is present in the system tablesto identify the realtionship betweeen the tables.i am planning to havethe realtionship created betweeen all the tables for easier access. Icouldn't figure out how to do that. Can anyone help me to relate thetables !!!!!!The Database in is in SQL server 2000.
View Replies !
ER Diagram
Hi,I'm a newbie to MS SQL server 2000. Is there any way or freeware to generatean ER diagram of a database??Thanks in advance,Wing
View Replies !
ER Diagram
Is there any tool to generate ER diagram in sql server 2000. If not where can i generate an ER Diagram. Thanks.
View Replies !
DB Diagram
Does anyone know if MS has improved the db diagram feature in SQL Server 2000? Specifically, can a diagram in SQL2000 be saved to an external file (like a DTS package) or transferred from one db to another using "Save as" (again, like a DTS package)? Also, do they have a password feature for an owner (view, change, etc.) vs. an operator (view/print only)? Thanks for any feedback, Joe T
View Replies !
ER Diagram
I am looking for the ER diagram of Sql Server systables. I know it is somewhere in MSDN. can any one give the URL or any source where i can find? Advance Thanks MAK
View Replies !
ER Diagram
Hello I designed the ER diagram of some compony like blockbuster with some tables and i inserted 5 values in it.Now after creating the tables and inserting values i want to write a stored procedure to get members information,list all members with their age,member type name.So please help me writing the stored procedure. Thanks
View Replies !
ER Diagram
Hi, I'm a new to MS SQL server.Is there any way or freeware to generate an ER diagram for a compony like e-bay. Thanks in advance
View Replies !
Database Diagram
I am working through a book about setting up a database, though i'm doing it slightly differently, using a sql server database on a remote server rather than the local sql server express database shipped with visual studio. everything has been going fine until i've reached a part where they want to add a database diagram to the existing database. they talk about right clicking the database diagram node, and selecting add, but for some reason there is no database diagram node, so i can't do it this way. the book also says using the data>add new>diagram from the menu, but when i do this i either have no diagram option (when i have no table opened) or else the diagram option is greyed out and unselectable (when i have a table opened). any ideas on how i can add a database diagram? dc
View Replies !
Cannot Create Db Diagram
When trying to create a DB diagram on my local SQL Server 2005 db, I get the following error: cannot insert the value null into column "diagram_id" I have searched the web and can't seem to find anything on this. I just simply drag one table from my local db onto the diagram windows and try to Save it and that's what I get. I'm able to save diagrams on a networked SQL Server. Does anybody know how I can resolve this issue?
View Replies !
UML: Context Diagram
I'm finding the context diagram for system's analysis and design a challenge. I'm trying to draw a logical data structure for the scenario below. I can't get past level 0, I have one external entity....Please take a quick look, any suggestions would be most welcome. LDS of Staff and Student Database. The University of Chicago accepts students on to both undergraduate and postgraduate courses. The UOC records student details, personal and the qualifications they have gained at A-level(or equivalent) and above. Students are required to have qualifications of A-level or above in-order to undertake any of its undergraduate courses. For a postgraduate course, students must have at least a bachelor’s degree. However some exceptions are made for mature students for undergraduate and post graduate courses. The student records are kept for ten years after thy have left the course before being removed from the main database and archived. A student records will be reinstated if the student enrols on a new course. All the courses are made up of modules. Some of the modules are taught to more than one course. Some courses allow electives, i.e. a student may choose to do some modules and not others, the student’s choice must be recorded. All lectures at the university belong to a department, e.g. physics, fine art, admissions, etc. but not staff in a department are lectures, there will e administration staff and researchers. One lectures is assigned as the “course leader�, the individual will deal with all the academic matters arising from the course. A lecturer will not be the course leader of more than one course at anyone time. The course leader is always from the same department that has responsibility for the course. Lectures may teach a module on any course. Usually a module is taught by one and only lecturer but there are exceptions. Each module has a number of assessments. Typically this is two assignments and an exam, although there are some variations. The details of each assessment and marks for each individual student are recorded. Each member of staff has a line manager to whom they are directly responsible. The line manager is of course another member o staff. The line managers of lectures and researchers are always more senior academics. The line manager of administration staff will be another administer for at lower levels but will be a departmental head for the more senior administrators. Each student is assigned a personal tutor from the lecturing staff. The lecturer concerned may change but only the current tutor is recorded on the database.
View Replies !
Diagram In SQL Server
Hello, I was trying to use Diagram in SQL Server, it is good but it does not have any printing or option to export it to other environment such as Word. Is there any free tool I can use to create Diagrams of my database?
View Replies !
Exporting Diagram
When using the DTS to copy a db from my local MSSQL to the remote server (connecting via IP address) everything is copied ok except the diagram laying out the relations. The table relations *are* copied because the damn thing works as expected also on the remote server. I figured out that the diagrams are saved in the sysfile 'dtproperties' but when copying using the DTS query tool from local to remote this table is not visible. I need to remove some relations on certain tables when bulk loading new data and was just wondering how I got to copy the diagram (as opposed to creating a new diagram on the remote server and adding relations manually). Thanks a lot for any ideas, Niels
View Replies !
Diagram Of Master DB
Is there a way to get the diagram of the MASTER Db in MS-SQL? When iright click on Enterprise Manager that option is not available but itis available in any other database (Model Db acts the same).Thanks,Gent
View Replies !
Sql 6.5 Data Diagram
Hi 1) How can i have a list of about 100 database table with their column name and datatype into a list which i can use for my query Some thing like a data diagram that came into effect with 2000 2) My database keeps on growing for each day how do i make only current year transaction (info) in the database and rest somewhere backed up so each time we make a query we dont have to go through each and every record since past 5 yrs in database to return a query New bee so explain
View Replies !
SQL Diagram Error
Hi. I am getting back into working SQL now after a bunch of years and I am having problems with creating relationships with my tables. All of the fields are defined the same, to clear that. The error message that I am getting is: 'StaffTable' table saved successfully 'Billing Data Table 2' table - Unable to create relationship 'FK_Billing Data Table 2_StaffTable'. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Billing Data Table 2_StaffTable'. The conflict occurred in database 'HIMS_TRANS_UPDATE', table 'StaffTable', column 'StaffID'. Any suggestions.
View Replies !
Data Diagram
Has anyone found an application complete a data diagram of MS SQL. I just been handed over a SQL server, that has not been documented. I need to quickly get a handle on how the tables are connected and the fields there in. Thanks
View Replies !
Invisible Diagram
We have a problem viewing a diagram on a Win98-client. The diagram was made on that client but the next day it was invisible. I can see the diagram from my NT4WS-client. The Win98-client has got the server registered as dbo, even as 'sa' the diagram is invisible. Seems this is not a securityproblem. Anyone a clue? Someone posted a message in msnews.microsoft.com/sqlserver* but there where no followups...... Thanks, Jeroen
View Replies !
Diagram Problem
I loaded service pack 2 for SQL 7 an I now get this error message when trying to save my diagrams. Does anyone have clue to what the issue is? This feature use to work before SP2 Can insert the value NULL into column 'version table' Reportcard.dbo.dtproperties column does not allow nulls. INSERT Fails The dt_Adduserobject procedure attempted to return a status of NULL, which is not allowed. A value of 0 will be returned instead.
View Replies !
SQL Diagram Tool
Has anybody see a tool can draw a Tree diagram for Parent-Child(PK-FK) relationships for SQL 7.0 DB. Appreciate your help. Thanks
View Replies !
|
TRACKER
