I'm looking at 
, and I feel like I know what's going on until I see "PlayersIn" and "Foliage". Foliage is a double-line-bordered attribute because it is multivalued. What does that mean? How does it look in an actual database query? I don't know what the "PlayersIn" dotted-line bordering indicates. Can you please explain what it indicates, and when it is useful? What does it mean, what does a query look like, why is it important, etc.?
dia: in Chen's Notation, what are dot-bordered atts and what are multivalue atts for?
1.7k views Asked by Wolfpack'08 At
1
There are 1 answers
Related Questions in DATABASE-DESIGN
- SQL schema for a fill-in-the-blank exercise
- When an E-R attribute should be perceived as a relationship attribute or as an entity set attribute?
- steps to create a web app with backend and database and web
- Use data type uuid or varchar(36) for my UUID column?
- Containing Object Design
- Many-to-many relationship between objects of the same type
- When hashing an API key, should I hash the suffix / prefix as well?
- Database design, authentication and authorization in a microservices ticketing system
- Unique index on 3 columns where NULL conflicts with all other values in one column
- Can i create a table with 2 foreign keys? These 2 foreign keys are 2 primary keys of 2 different tables
- I have a basic ms access question about a relationship between 3 tables
- how can i calculate mutual friends/followers efficiently?
- Access Table ,setting in design ,column 'Catagory' as Combobox in lookup with list "Action";"War";"Drama". in vb.net DGV and Detail how to multiselct
- Table Design for Calculating Median Over User-Defined Period from Pre-Processed Data
- Use conditional constraint or normalize table?
Related Questions in STANDARDS
- Does the qsort() function provide performance guarantees?
- Are all Oracle alert log errors 5 Digits long?
- Are these three default constructors equivalent in C++?
- Concept vs. Typename Parameter in Template Template
- Why does std::memory_order_acq_rel always trigger warnings in C++11?
- I am trying create standard logic app with workflows in it using arm template
- in my date column some rows i have 10/12/2007 and in some rows 10-12-2007 now i want to transfer the date into 2007-12-10 in big query
- Why can't C++ using-declaration expose a protected member of base as a public member of derived?
- Is `int(int) const` a valid function type in C++23?
- Why doesn't std::source_location provide lengths to avoid performance penalty in C++20?
- Why isn't it an error if the arguments are more than required in std::format?
- How much of the C++ standard library requires compiler support?
- How to ensure that the input of a function is within a list of options?
- Is it safe to use fmax for integer types in C?
- Graphql date range as input field
Related Questions in ERD
- Moodle Database - Reverse Engineering ERD
- An associative Entity with optional participation on one side and mandatory participation on the other
- ER diagroms Composite Key representation in m;n relationship
- How to specify relation based on a condition in Entity Relationship Diagram (ERD)?
- Is there any identifying or non-Identifying relationship in this ERD?
- Which Lucidchart license is required for import data to directly get metadata from database to create ERD?
- erd diagram Car buying and selling website
- is it allowed to leave an attribute empty in the Entity–relationship model?
- One to many relationship in Product Ordering System with Crow's Foot Notation
- Can an Identifying relationship be one-to-one?
- How to model a complex relationship involving a Weak Entity and entities related to its parents?
- Mermaid Entity-Relationship diagram in top-down layout
- Relations between entities in ER diagram: can they have a key?
- Total Disjoint vs U-type in EERD
- Do Entity-Relationship diagrams need attributes to represent relationships?
Related Questions in NOTATION
- Do not want scientific notation on plot axis again
- Turning infix notation to prefix notation has problems in formatting (Python)
- Alphatab tutorial won't load Guitar Pro files
- How to write a number in scientific notation in Python keeping the mantissa as integer
- React dot notation component passing between components
- How do I convert values that are given in scientific notation into decimals?
- How can I return an object that supports dict and dot-notation from SQLite queries in Python?
- Representing logical operations in math/logical notation
- Formatting numerical tick labels into exponential notation in ggplot2, without rescaling x- or y-axis
- How to return scientific notation with only a few decimal places with the notation still intact?
- why scientific notation leaves an extra character "1" after e in R?
- Normal to RPN conversion
- Normalizing a board game notation
- What would be the time complexity of this code? Big O notation
- What does this for loop syntax mean?
Related Questions in DIA
- What is the Touch UI replacement of xtype tableedit2
- Problem with adjusting the box line width
- Permanently change the color palette in the GTK color picker
- ER DIAGRAM Drawing
- Is there any documentation for the Dia (diagram editor) module for python?
- Block Dia Diagram Editor from saving backup copies of files
- How to change font in Dia and fix its font rendering issues?
- How to explicitly specify which archive-files should be handled by auto-compression-mode?
- How to input Chinese in dia
- How can I get the gtk window of a C running program through a python script?
- How to write superscript in DIA(Ubuntu16.04)?
- Is development of Dia (diagram software) permanently halted?
- Does This ER Schema Make Sense
- how to insert text outside a object in DIA?
- dia2code - how to handle use of stl classes
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
*Important note: the links contain java, but they are .ca websites and therefore likely secure.
Foliageis multi-valued, and I'm still unsure why anyone would want to do that. I read some documentation, here, on Chen Notation, that say: 'You may want to store degrees in a multi-value field, to show that someone has more than one degree, like a BA and an MS.' I don't understand why a foreign key for degree types isn't used with a dependency table,employeeID x degreeID? Maybe because it's less confusing to have only one table? As far as 'foliage' is concerned, I thought, 'Maybe there are many kinds of foliage, and it's unimportant to people. Maybe it's faster to use a multivalue field because joins are not necessary.'As far as the yellow, dot-bordered attribute, it's a
derived attribute. Derived attributes are attributes which can be obtained by parsing other attributes. Sometimes derived attributes are listed for human convenience, it appears. I'm not sure if it's only an issue of elegance, or if this can somehow speed the code up, though.