{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2023,10,1]],"date-time":"2023-10-01T11:31:52Z","timestamp":1696159912421},"reference-count":33,"publisher":"World Scientific Pub Co Pte Lt","issue":"01","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["Int. J. Unc. Fuzz. Knowl. Based Syst."],"published-print":{"date-parts":[[2012,2]]},"abstract":"<jats:p> In fuzzy relational databases, the data dependencies, especially the fuzzy functional dependency(ffd) plays an important role in maintaining the consistency of the database and in avoiding the redundant storage of the data. In the past, it has been shown that the type-2 fuzzy relational databases captures impreciseness and incompleteness in data in a better way. The aim of this paper is to provide the concepts for database normalization in a type-2 fuzzy relational database, so that the normalized schemas can be obtained. Here, we deal with the fuzzy functional dependency(ffd) based normalization of type-2 fuzzy relational databases. We use the concepts of fuzzy functions to derive the fuzzy equality and using this fuzzy equality, we define a new definition of fuzzy functional dependency. First we discuss various approaches proposed by the researchers in this context and show why our fuzzy functional dependency is better, as compared to the earlier ffds proposed by the researchers. We call our ffd as non-0 LHS ffd. We identify an anomaly called \"spurious ffd\" and show that some of the significant contributions proposed by the earlier researchers are suffering from this anomaly, but the non-0 LHS ffd does not suffer from it. Then, we prove that the set of inference rules for the non-0 LHS ffd are sound and complete. We use the definition of non-0 LHS ffd in obtaining the first three normal forms upto BCNF for type-1 and type-2 fuzzy relational schemas. The result of the decomposition and the procedure to obtain the membership value of the decomposed relations is proposed. The associated concepts like the fuzzy key, fuzzy superkey, fuzzy foreign key are defined in terms of non-0 LHS ffd. On the basis of these concepts, we define full ffd, partial ffd etc. In the last, we show that in our case, the relationship of total-ordering between the three normal forms in classical relational databases is also observed. <\/jats:p>","DOI":"10.1142\/s0218488512500067","type":"journal-article","created":{"date-parts":[[2012,2,6]],"date-time":"2012-02-06T11:56:49Z","timestamp":1328529409000},"page":"99-138","source":"Crossref","is-referenced-by-count":5,"title":["NORMALIZATION IN TYPE-2 FUZZY RELATIONAL DATA MODEL BASED ON FUZZY FUNCTIONAL DEPENDENCY USING FUZZY FUNCTIONS"],"prefix":"10.1142","volume":"20","author":[{"given":"P. C.","family":"SAXENA","sequence":"first","affiliation":[{"name":"School of Computer &amp; Systems Sciences, Jawaharlal Nehru University, Delhi 110067, India"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"D. K.","family":"TAYAL","sequence":"additional","affiliation":[{"name":"Department of CSE, IGIT, GGSIP University, Delhi 110067, India"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"219","published-online":{"date-parts":[[2012,4,30]]},"reference":[{"key":"rf1","unstructured":"B.\u00a0Buckles and F.\u00a0Petry, Fuzzy Information and Decision Processes\u00a02, eds. M.\u00a0Gupta and E.\u00a0Sanchez (North Holland, Amsterdam)\u00a0pp. 361\u2013371."},{"key":"rf2","doi-asserted-by":"publisher","DOI":"10.1016\/0165-0114(82)90052-5"},{"key":"rf3","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4613-1319-9"},{"key":"rf4","volume-title":"Fuzzy Logic \u2013 Intelligence Control and Information","author":"Yen J.","year":"2003"},{"key":"rf6","doi-asserted-by":"publisher","DOI":"10.1177\/016555158501100204"},{"key":"rf7","doi-asserted-by":"publisher","DOI":"10.1016\/0165-0114(87)90149-7"},{"key":"rf8","doi-asserted-by":"publisher","DOI":"10.1145\/42338.42344"},{"key":"rf9","first-page":"321","volume":"17","author":"Ba Z. M.","journal-title":"Int. J. Intelligent Systems"},{"key":"rf10","doi-asserted-by":"publisher","DOI":"10.1016\/0165-0114(94)00247-5"},{"key":"rf11","first-page":"341","volume":"92","author":"Liu W. Y.","journal-title":"Fuzzy Sets and Systems"},{"key":"rf12","doi-asserted-by":"publisher","DOI":"10.1002\/int.4550090503"},{"key":"rf13","doi-asserted-by":"publisher","DOI":"10.1016\/0306-4379(96)00016-6"},{"key":"rf16","volume-title":"Introduction to Database Systems","author":"Desai B. C.","year":"1999"},{"key":"rf17","volume-title":"Introduction to Database Systems","author":"Date C. J."},{"key":"rf18","unstructured":"M.\u00a0Umano, Fuzzy Information and Decision Processes, eds. M. M.\u00a0Gupta and E.\u00a0Sacnhez (North Holland, Amsterdam, 1982)\u00a0pp. 339\u2013347."},{"key":"rf19","doi-asserted-by":"publisher","DOI":"10.1016\/S0165-0114(96)00071-1"},{"key":"rf20","doi-asserted-by":"publisher","DOI":"10.1016\/S0165-0114(96)00299-0"},{"key":"rf21","doi-asserted-by":"publisher","DOI":"10.1016\/S0165-0114(98)00152-3"},{"key":"rf22","doi-asserted-by":"publisher","DOI":"10.1002\/(SICI)1098-111X(199807)13:7<641::AID-INT4>3.0.CO;2-K"},{"key":"rf23","doi-asserted-by":"publisher","DOI":"10.1016\/S0165-0114(97)00280-7"},{"key":"rf24","doi-asserted-by":"publisher","DOI":"10.1016\/0165-0114(93)90255-G"},{"key":"rf25","volume-title":"Fuzzy Points, Fuzzy Relations and Fuzzy Functions: Discovering the World with Fuzzy Logic","author":"Klawonn F.","year":"2000"},{"key":"rf26","doi-asserted-by":"publisher","DOI":"10.1007\/978-94-011-5300-3"},{"key":"rf27","doi-asserted-by":"publisher","DOI":"10.1016\/j.fss.2003.12.007"},{"key":"rf28","volume":"2","author":"Saxena P. C.","journal-title":"Int. J. Intelligent Technology"},{"key":"rf29","volume":"3","author":"Saxena P. C.","journal-title":"Int. J. Computing, Multimedia & Intelligent Techniques, Poland"},{"key":"rf30","volume-title":"Fuzzy Functions","author":"Novak V.","year":"1994"},{"key":"rf33","volume-title":"Database Management and Design","author":"Hansen H.","year":"2003"},{"key":"rf34","volume":"7","author":"Liao S. Y.","journal-title":"IEEE Transactions on Fuzzy Systems"},{"key":"rf35","volume-title":"An extended Boyce-Codd normal form in fuzzy relational databases","author":"Chen G.","year":"1996"},{"key":"rf36","volume":"151","author":"Dutta R. N.","journal-title":"Fuzzy Sets and Systems"},{"key":"rf37","first-page":"885","volume":"19","author":"Yazici A.","journal-title":"Int. J. Intelligent Systems"},{"key":"rf38","volume-title":"Fundamental of Database Systems","author":"Elmasri R.","year":"2000"}],"container-title":["International Journal of Uncertainty, Fuzziness and Knowledge-Based Systems"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.worldscientific.com\/doi\/pdf\/10.1142\/S0218488512500067","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,8,6]],"date-time":"2019-08-06T16:27:45Z","timestamp":1565108865000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.worldscientific.com\/doi\/abs\/10.1142\/S0218488512500067"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2012,2]]},"references-count":33,"journal-issue":{"issue":"01","published-online":{"date-parts":[[2012,4,30]]},"published-print":{"date-parts":[[2012,2]]}},"alternative-id":["10.1142\/S0218488512500067"],"URL":"https:\/\/doi.org\/10.1142\/s0218488512500067","relation":{},"ISSN":["0218-4885","1793-6411"],"issn-type":[{"value":"0218-4885","type":"print"},{"value":"1793-6411","type":"electronic"}],"subject":[],"published":{"date-parts":[[2012,2]]}}}